| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cross-referencing content of one worksheet with another
You're welcome, Colin.
Pete On Jan 1, 11:11*pm, Colin Hayes wrote: Hi Pete Yes , I understand the principal of course. The problem is in the process rather than the outcome , however. I'm pasting new figures into both sheets so the comparison can be made. As soon as I paste into the first sheet , the calculating starts. This will give false results of course , because I have yet to paste into the second sheet. It's comparing old data. I can't open the second sheet because the machine is preoccupied with calculating on the first sheet. Once this has finished , I can open the second sheet and paste in the figures. When the calculation has finished , I can go back to the first sheet , and the calculating starts again... I've got around this by switching auto-calculation off via the Options menu , and then pasting my data in peace. Then I switch auto-calculation back on , and it does it's job. Seems a bit long-winded , that's all. Anyway , job done Pete , and I'm very grateful for you help and expertise. Best Wishes Colin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cross referencing | Excel Worksheet Functions | |||
| Cross referencing | Excel Worksheet Functions | |||
| Cross Referencing | Excel Discussion (Misc queries) | |||
| Cross referencing | Excel Worksheet Functions | |||
| cross referencing | Excel Worksheet Functions | |||
Hybrid Mode
