Reema has attended:
Excel Introduction course
Excel Intermediate course
Excel VBA Intermediate course
Sheet reference
I have referenced a large number of cells in one column to Sheet A, but they should refer to exact cells in sheet B, how can I change Sheet A to sheet B maintaining the cell reference?
RE: Sheet reference
Hi Reema
Thanks for getting in touch.
This is easiest achieved with Find and Replace. Highlight the cells that need to change, and on the Home ribbon select Find & Select > Replace.
In the box "Find What" type "Sheet A" (without quotes). In "Replace with" type "Sheet B". Click Replace All and the substitutions will be made for you.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
