Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill reference formula but repeating n times before incrementi
I have one sheet with Col A having 100 numberic values (Item Numbers)
In my second sheet, I have 7 rows with variable data in Col A to Col E. I need these 7 rows to repeat for each of the values in sheet 1 (adding the value of the Item Number into Col F). I.e. have the 7 rows with value of Sheet1!A1 in Col F then repeat the same 7 rows, but this time have the value of Sheet1!A2 in Col F. Ending up with 700 rows (7 for each Item Number) I want to drag the row values down, having autofill increment the cell reference to Sheet 1 only after every 7th row. Is this possible? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to reference different worksheets in an autofill formula | Excel Discussion (Misc queries) | |||
Repeating/incrementing dates 35039 times | Excel Discussion (Misc queries) | |||
How do i use the same name multiple times in repeating worksheets | Excel Discussion (Misc queries) | |||
reference autofill. | Excel Worksheet Functions | |||
reference a repeating cell in a formula | Excel Worksheet Functions |