Hi, New to the forum and looking for some help! I have never done macros/VBA before, so I feel over my head as I've just learned VLOOKUP and HLOOKUP, but let me explain what I'm trying to do...
I have Workbook (1) that has 40+ worksheet tabs in it all named with different numbers (ex. 303, 505, 606, etc.). Each worksheet is setup with the same format and data in same cells (like a form).
In a new workbook, Workbook (2), I want to copy data from specific cells in each Worksheet from Workbook (1) (Cells C6, G14:G19, M30:Q30, and M31:Q30), and have them pasted in new rows in Workbook (2).
So automatically:
cell C6 of Workbook (1) Worksheet 303 would be copied to Workbook (2) cell A3
cell G14:G19 Workbook (1) Worksheet 303 would be copied to Workbook (2) cell B3:G3
cell M30:Q30 Workbook (1) Worksheet 303 would be copied to Workbook (2) cell H3:K3
cell M31:Q31 Workbook (1) Worksheet 303 would be copied to Workbook (2) cell L3:O3
(then continue on to do all the rest of the worksheets in Workbook (1), filling them in on the next row)
cell C6 of Workbook (1) Worksheet 505 would be copied to Workbook (2) cell A4
cell G14:G19 Workbook (1) Worksheet 505 would be copied to Workbook (2) cell B4:G4
and so on...
Does this make sense? I have been scrounging the internet and forums. I thought I saw a thread that might be in the right direction but again (only needed specific worksheet tabs, I need them all), I don't know VBA or macro to understand whats going on with the code. I've tried playing around but go no where yesterday. Please help!
Bookmarks