Browse to another workbook, copy data from a table, return to original workbook and paste

Hi all

I have been going around in circles and something doesn't appear to be working on my MacBook Pro. I am using Excel for Mac, v16.69.1 under my office 365 subscription.

even some basic vba to open a file has not been working which leads me to suspect I have an issue on my computer perhaps?

Anyway, what I want to achieve is shown below and I have attached an example file, with two worksheets in.

I have a destination workbook where I wish to paste data to. In this workbook there is a worksheet named MASTER and in there is a table named MASTERdata.
I have placed some example SOURCE data in the tab 'Other Workbook'

I would like the VBA to achieve the following: (From within the Destination Workbook)
Allow me to browse and open a file. This file hosts the source data (as per the other workbook tab)
Copy the 'Assessment Response' data in that table only.
Return to the DESTINATION workbook
Past the values in the next available empty row in the MASTERdata table, transposed, from field 'GG1-Assessment'

I believe this to be straight forward enough but as I mentioned, not have ing any success!

Even the following code returns errors and this is just to open a file!...

Please Login or Register  to view this content.

I would be grateful as ever if anyone could spare me some time and assist.

As I repeatedly say, I am not convinced there is not an issue with the laptop because I keep getting all the errors I am getting

Thank you in advance

Originally Posted by Flowerski

Dear Ed. Probably it is not helpful but exactly your problem is used as exmple in online course by Leila. I remember. Check xelplus.com. Course name is "Unlock Excel VBA & Excel Macros". I know you need that answer right now but for the future I really recommend that course. Good luck

Thank you for this. I subscribe and watch Leila Gharani on YT so I am aware of her.

It does not answer the specifics though, but I appreciate the direction.