Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replacing sheet reference in multiple cells...
Hi, I have a sheet with an 'April' column of data referencing cells in an 'Apr06' sheet... Next to that column I have the 'May' one, which I want to reference cells in 'May06' sheet. I have dragged the formula along with $C$5 for example, so the cells are correct, but is there anyway I can replace the Apr06 reference with May06 in one fail swoop?? Thanks -- neilcarden ------------------------------------------------------------------------ neilcarden's Profile: http://www.excelforum.com/member.php...o&userid=35623 View this thread: http://www.excelforum.com/showthread...hreadid=554887 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replacing sheet reference in multiple cells...
Highlight the column that you want to change and then CTRL-H (Find &
Replace). In the dialogue box enter: Find What: Apr06! Replace With: May06! then click Replace All. Hope this helps. Pete neilcarden wrote: Hi, I have a sheet with an 'April' column of data referencing cells in an 'Apr06' sheet... Next to that column I have the 'May' one, which I want to reference cells in 'May06' sheet. I have dragged the formula along with $C$5 for example, so the cells are correct, but is there anyway I can replace the Apr06 reference with May06 in one fail swoop?? Thanks -- neilcarden ------------------------------------------------------------------------ neilcarden's Profile: http://www.excelforum.com/member.php...o&userid=35623 View this thread: http://www.excelforum.com/showthread...hreadid=554887 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replacing sheet reference in multiple cells...
Yes, that works - spot on thanks mate -- neilcarden ------------------------------------------------------------------------ neilcarden's Profile: http://www.excelforum.com/member.php...o&userid=35623 View this thread: http://www.excelforum.com/showthread...hreadid=554887 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replacing sheet reference in multiple cells...
You may want to look at Edit Links as an alternative to Replace. I find it
works easier than Replace in some cases. "neilcarden" wrote: Yes, that works - spot on thanks mate -- neilcarden ------------------------------------------------------------------------ neilcarden's Profile: http://www.excelforum.com/member.php...o&userid=35623 View this thread: http://www.excelforum.com/showthread...hreadid=554887 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
Relative Sheet Reference (Summary Sheet) | Excel Discussion (Misc queries) | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
changing multiple cells from relative to absolute reference | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |