| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
copy link from next worksheet
I have a wookbook containing approx 65 separate sheets. First sheet is a
summary page which i need to copy a value from each separate sheet. I can't copy these using a fill series, and to do an individual link from each sheet would take a while, so my question: Is there a quick way to copy a link and fill down (where down means moving to next worksheet). ie. summary sheet a1 = worksheet 1 cell b1 summary sheet a2 = worksheet 2 cell b1 summary sheet a3 = worksheet 3 cell b1 Many thanks in advance, -- Jan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy with link between sheets - all the formats dissapear?!? | Excel Discussion (Misc queries) | |||
| how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel | |||
| Past Link then copy | Excel Discussion (Misc queries) | |||
| How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
| Copy worksheet with Pivot Table and break link to original workshe | Excel Worksheet Functions | |||
Threaded Mode
