If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Macro Help - Jumping Sheets!
Hi All
I have a workbook which contains 200 sheets. What I need to do is to insert a "cover" sheet and then create a macro to pick up the same five cells from each worksheet (b3, b4, c26, e26, h26) and copy and paste the values into the Cover Sheet going progressively down a column for each cell. so i need the macro to go to Sheet1 get the value from B3 and paste it on the cover sheet in A2, then get the value B4 and pasit on the cover sheet in B2 etc... then go to Sheet2 get the value from B3 and paste it on the cover sheet in A3, then get the value B4 and pasit on the cover sheet in B3 etc... If anyone can help it would be a massive time saver! Cheers Nick |
#2
|
|||
|
|||
Macro Help - Jumping Sheets!
Hi
see your existing post P.S.: please don't multipost -- Regards Frank Kabel Frankfurt, Germany NICK wrote: Hi All I have a workbook which contains 200 sheets. What I need to do is to insert a "cover" sheet and then create a macro to pick up the same five cells from each worksheet (b3, b4, c26, e26, h26) and copy and paste the values into the Cover Sheet going progressively down a column for each cell. so i need the macro to go to Sheet1 get the value from B3 and paste it on the cover sheet in A2, then get the value B4 and pasit on the cover sheet in B2 etc... then go to Sheet2 get the value from B3 and paste it on the cover sheet in A3, then get the value B4 and pasit on the cover sheet in B3 etc... If anyone can help it would be a massive time saver! Cheers Nick |
Thread Tools | |
Display Modes | |
|
|