Macro Help - Jumping Sheets!

N

NICK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro Help - Jumping Sheets 2
Macro Help - Jumping Sheets 1
Autofiller Tool Help 3
Open Workbook on Specific Worksheet 3
Summarizing data 2
COUNTIF, Sorting, on Two Sheets 1
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Formula to return a formula 1

Top