I have 2 workbooks and I want to connect both. In the 1st one, I want E13 = the value in A2 from the 2nd one.
I'm using this function
=INDIRECT("'C:\Users\lab9\Desktop\Plastic Rules\Calculations\[Cutter Calculations.xlsx]In'!$A$2")
How to increment the cell number ,i.e., how to change from A2 to A4, A6 .. A44 when dragging down??
Thanks
I'm using this function
=INDIRECT("'C:\Users\lab9\Desktop\Plastic Rules\Calculations\[Cutter Calculations.xlsx]In'!$A$2")
How to increment the cell number ,i.e., how to change from A2 to A4, A6 .. A44 when dragging down??
Thanks