zack carter
asked on
VBA or alternative Excel Database Creation advice
Hi Peers,
I need your advice and guidance.
I have an excel database called Master-Document that I need to import several hundred excel files in a folder into.
Unfortunately, this needs to be ran on a Mac and I am no expert on using Macs.
Example Import Files
[list=2][/list] Each time a document is imported into the master Document the above is added as a new column at the end of the last column.
[list=3][/list] I then need to match the imported data row to the store row in the list.
[list=4][/list] The solution that the exports come out of the store numbers column is stored as a text and not a number.
Any help appreciated on this.
I need your advice and guidance.
I have an excel database called Master-Document that I need to import several hundred excel files in a folder into.
Unfortunately, this needs to be ran on a Mac and I am no expert on using Macs.
Example Import Files
[list=2][/list] Each time a document is imported into the master Document the above is added as a new column at the end of the last column.
[list=3][/list] I then need to match the imported data row to the store row in the list.
[list=4][/list] The solution that the exports come out of the store numbers column is stored as a text and not a number.
Any help appreciated on this.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
ASKER
I have tried using the blow code which i found on Ron De Bruin website but i need your help if possible.
For some reason copying the column range E5:AA8 is pasting the values at the bottom of row data in the master document.
I have tried all variations of codes from google and i am still non the wiser why its not pasting into the next emplty column in range A5: AA8.
This is the code that i have been playing around with:
Open in new window
The below is the master VBA code for the Mac solution.
Any advice would be appreciated.
Open in new window