PDA

View Full Version : VBA Assistance Needed



owennatmoore
08-21-2018, 01:55 AM
Just a bit of background information, im a novice with VBA for Excel, essentially, we have a customer who has numerous DTA excel files, within those files we need to take specific cells and put them into a new workbook, now I am led to believe a macro has the capability to do this.

I have attempted to recreate what is required by simply trying to copy an A1 cell from 2 different workbooks in the same folder in windows, to a third (still in that folder) using a macro in the 3rd workbook.

At the moment I am having no luck, the cells the customer requires D113 AND H113 as stated in multiple DTA files, im aware the files all have to be in the same folder for the Macro to take effect.

Could anyone point me in the right direction?

Kindest regards,
Owen

Logit
08-21-2018, 08:17 AM
.
https://stackoverflow.com/questions/19351832/copy-from-one-workbook-and-paste-into-another