| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
Sheets are absolute, I would personally just do a search and replace and
replace the sheet names. Here's a link to a UDF by John Walkenbach http://www.j-walk.com/ss/excel/tips/tip63.htm Regards, Peo Sjoblom "AuMiQuinn" wrote: As if that wasn't confusing enough... Sheet 2 has a value in A15 which it's reading from Sheet 1's A15. How do I copy Sheet 2 to a new sheet 3 so that Sheet 3's A15 points to Sheet 2's A15 and not Sheet 1's? How do I make the "=+Sheet1!A15" a relative value? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transfer data from sheet to sheet | Excel Discussion (Misc queries) | |||
| Automatic cell increment with data from sheet 1 to sheet 2 | Excel Worksheet Functions | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
| Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Threaded Mode
