Looping Through Worksheets & Pasting Links

[Phil Floyd]

The first sheet in a workbook is named "Master". The second sheet is named
"Summary". After that, I will have a varying number of worksheets.
Starting with the third sheet, I would like to take paste a link from L3 on
the third sheet to B4 on the "Summary" sheet and also paste a link from M4
on the third sheet to C4 on the "Summary" sheet. Then offset down to B5 on
the "Summary" sheet and start the process all over again for the fourth,
fifth, etc. sheets. Something like this:





Sheet3 L3>>paste link>> Summary B4

Sheet3 M3>>paste link>> Summary C4



Sheet4 L3>>paste link>> Summary B5

Sheet4 M3>>paste link>> Summary C5



Sheet5 L3>>paste link>> Summary B6

Sheet5 M3>>paste link>> Summary C6



etc.



I have not been very successful in looping through all of the sheets while
not affecting the first 2 sheets.



Any help would be great.



Thanks,

Phil

 

[Frank Kabel]

Hi
have a look at the following site for a starting point:
http://www.rondebruin.nl/copy2.htm

 

[Phil Floyd]

Thanks Frank. This got me going in the right direction.

Phil