Home |
Search |
Today's Posts |
#3
![]() |
|||
|
|||
![]()
Oops! Read the post wrong. Apologies for any harm.
I tried this on a small sample and it seemed to work. Highlight the column that you want to change and go to EditReplace. Replace 'Sheet 2004' with 'Sheet 2005'. In my test I selected "Replace all" and it only replce those in highlighted column. HTH cwilson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Graph and Cell References | Excel Discussion (Misc queries) | |||
changing the value of each cell in a range by a certain percentage | Excel Discussion (Misc queries) | |||
Changing Cell Fill Colour | Excel Discussion (Misc queries) | |||
CELLS HAVING SAME NUMBER BY CHANGING ANY CELL | Excel Discussion (Misc queries) | |||
Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) |