davenportusmc
Board Regular
- Joined
- Aug 7, 2014
- Messages
- 53
So I am not to great at VBA codes. Some help would be great.
I have data in multiple wbs, but organized all in one row, in the order that I want it.
All these wb are located in one folder - C:\Users\jdavenport\Desktop\Mr.excel
Each wb has different names.
I need to reach into each workbook located within the file and on the sheet called "Data Extraction" and copy everything from A4 to CG4. Just the one row of information.
Then paste this information into a new workbook. One row after another.
Summary: get all data from Sheet "Data Extraction" (Located in all WBs in my desktop folder) and paste it into a new workbook so I can then filter and find averges of expenses.
I know this has been answered before, but I just cant seem to get it. I am losing my cool over here....
I have data in multiple wbs, but organized all in one row, in the order that I want it.
All these wb are located in one folder - C:\Users\jdavenport\Desktop\Mr.excel
Each wb has different names.
I need to reach into each workbook located within the file and on the sheet called "Data Extraction" and copy everything from A4 to CG4. Just the one row of information.
Then paste this information into a new workbook. One row after another.
Summary: get all data from Sheet "Data Extraction" (Located in all WBs in my desktop folder) and paste it into a new workbook so I can then filter and find averges of expenses.
I know this has been answered before, but I just cant seem to get it. I am losing my cool over here....