Hello sir, will you suggest me please how can i set the constant column reference in excel. I have 2 sheets. 1 sheet i have to store the all record of complete year & Sheet 2 i want to use for print the pages of current record. I want when i will enter the new column in front of yellow column in sheet 1 then its reference should not change on sheet 2. Becoz sheet 2 column f2 show the reference of sheet 1 E to F.
i want it should be always sheet1 E without any changes.
Thanks & regards
Prince
How can we set the constant cell in excel
-
- 2StarLounger
- Posts: 171
- Joined: 02 Mar 2015, 17:00
How can we set the constant cell in excel
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78548
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: How can we set the constant cell in excel
In F2 on Sheet2:
=INDIRECT("'sheet1 ( all record )'!E"&ROW()+1)
Fill down to F15.
=INDIRECT("'sheet1 ( all record )'!E"&ROW()+1)
Fill down to F15.
Best wishes,
Hans
Hans