Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoFill with sheet reference help | Excel Worksheet Functions | |||
AutoFill with sheet reference help | Excel Worksheet Functions | |||
Autofill a Sheet Reference | Excel Worksheet Functions | |||
Multi-sheet autofill | Excel Discussion (Misc queries) | |||
autofill next sheet with next set of dates | Excel Worksheet Functions |