Hello all,
I am attempting (so far with no luck) to use VBA to copy information from closed workbooks into a summary sheet.
Essentially, the information I need is on Sheet1 of each workbook in the range B2:L2 in a specific folder.
All of the google searches I've performed so far have led me to code that does not work for the task at hand.. or I'm really not changing the right things in the code.
Anyone care to help?
Thanks in advance.
I am attempting (so far with no luck) to use VBA to copy information from closed workbooks into a summary sheet.
Essentially, the information I need is on Sheet1 of each workbook in the range B2:L2 in a specific folder.
All of the google searches I've performed so far have led me to code that does not work for the task at hand.. or I'm really not changing the right things in the code.
Anyone care to help?
Thanks in advance.