Autofill a row from sheet 1 to a column on sheet 2
I want cells D2, E2, F2, G2, H2, etc on sheet one
to autofill onto columns on sheet 2 ="Sheet 1'!D2 ="Sheet 1'!E2 etc. Is this possible? |
Autofill a row from sheet 1 to a column on sheet 2
Enter this in A1 of Sheet2
=INDIRECT("Sheet1!"&LOOKUP(ROW(),{1,2,3,4,5,6},{"A ","B","C","D","E","F"}&COLUMN())) then copy across and down... ----------------OR------------------------- If you want beyond F then add to the lookup or enter numbers in Col A of sheet3 and corresponding letter numbers in Col B and use VLOOKUP(Row(),Sheet3!A:B,2,false) instead of Lookup ----------------OR----------------------------- Use =INDIRECT("Sheet1!"&CHAR(ROW()+64)&COLUMN()) it will work for 26 columns... "Janet" wrote: I want cells D2, E2, F2, G2, H2, etc on sheet one to autofill onto columns on sheet 2 ="Sheet 1'!D2 ="Sheet 1'!E2 etc. Is this possible? |
All times are GMT +1. The time now is 02:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com