| 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 |
| 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) | |||
Threaded Mode
