Forum Discussion

NelsonYan's avatar
NelsonYan
New Member
2 years ago

How to load query to specific sheet in excel for Mac

Hi team,   I know that we can choose to load query to specific sheet in excel for windows, but I can't find this function in excel for mac!   not sure if i miss something, any input are welcome...
Need Help
AmiraBedh's avatar
AmiraBedh
Icon for Super User rankSuper User
2 years ago

If you want to load the data into a specific sheet, you'll need to copy and paste it manually.

If you want to keep the link between the query and the specific sheet (so it refreshes automatically) . After pasting the data, you can set up a connection between the query and the destination sheet using VBA.

NelsonYan's avatar
NelsonYan
New Member
2 years ago

Thanks AmiraBedh 

Looks like it's really some limitation on Mac.

Do you have more information on VBA setup? I need to make the query connection active on the table.

 

 

Nelson

  • AmiraBedh's avatar
    AmiraBedh
    Icon for Super User rankSuper User
    2 years ago

    What do u want to achieve exactly ?

    • NelsonYan's avatar
      NelsonYan
      New Member
      2 years ago

      What I want to achieve is just like what we can do on Windows.

      1. Load the query to specific sheet

      2. Data of query in that sheet can be refreshed properly