MichelleC987
New Member
- Joined
- Dec 6, 2017
- Messages
- 5
Hi All,
Looking for a little help on how I can quickly highlight the cells referenced in sheet 1 by formulas in sheet 2. The (Ctrl + [) work great if the formula and cell are on the same sheet, but how do I achieve a similar result crossing sheets.
Background: Sheet1 - Raw Data; Sheet2 - Analysis of specific items
Any ideas greatly appreciated! Thank you!!
-Michelle
Looking for a little help on how I can quickly highlight the cells referenced in sheet 1 by formulas in sheet 2. The (Ctrl + [) work great if the formula and cell are on the same sheet, but how do I achieve a similar result crossing sheets.
Background: Sheet1 - Raw Data; Sheet2 - Analysis of specific items
Any ideas greatly appreciated! Thank you!!
-Michelle
