Forum Discussion
I cant make a formula in sheet 2 using data in sheet 1.
I cant make a formula in sheet 2 using data from parts of sheet 1 . Some parts of sheet one I can but other parts of the same sheet I cant. When try to in part of sheet 1 one the cursor goese feom + to an arrow head.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- Thanks I will try but I'm not an Excel expert. I am basily clicking in a cell in sheet 2 (Where I want the answer) then going to sheet 1, clicking the cell I want then going to the next cell I want in the foumulare X-Y I wnt in sheet 2 from data in sheet 1. Oddly on parts of sheet 1 I can do this fine and I get the answer in sheet 2 but lower down in sheet 1when I try to do the same the cursor chages to an arrow and I can select the cell.
It's impossible for me to tell what causes this without seeing the workbook.
