In MS Excel, how do I fill in a column with the same cell from se.
In MS Excel, how do I fill in a column with the same cell from sequential
worksheet tabs automatically For example I want my column of cells to automatically copy the same cell $H$6 from all the sequential worksheets 1-20 so for the first cell in the column I have: ='1'!$H$6 But how do I get the cell below it in this column to increment to: ='2'!$H$6 when I do a copy and fill? the " ='1' " part doesn't seem to want to increment, even if I try " ='+1' " Thx, Curt |
One way:
=INDIRECT(ROW() & "!H6") In article , "krempin" wrote: In MS Excel, how do I fill in a column with the same cell from sequential worksheet tabs automatically For example I want my column of cells to automatically copy the same cell $H$6 from all the sequential worksheets 1-20 so for the first cell in the column I have: ='1'!$H$6 But how do I get the cell below it in this column to increment to: ='2'!$H$6 when I do a copy and fill? the " ='1' " part doesn't seem to want to increment, even if I try " ='+1' " Thx, Curt |
Thanks McGimpsey! That pretty much got me there ... since the row # didn't
align with the tab #, I just made another column with that ref the tab #, that is, I created a column numbered 1-20 and then: =INDIRECT(A3 & "!H6") - THANKS! "JE McGimpsey" wrote: One way: =INDIRECT(ROW() & "!H6") In article , "krempin" wrote: In MS Excel, how do I fill in a column with the same cell from sequential worksheet tabs automatically For example I want my column of cells to automatically copy the same cell $H$6 from all the sequential worksheets 1-20 so for the first cell in the column I have: ='1'!$H$6 But how do I get the cell below it in this column to increment to: ='2'!$H$6 when I do a copy and fill? the " ='1' " part doesn't seem to want to increment, even if I try " ='+1' " Thx, Curt |
All times are GMT +1. The time now is 09:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com