Home |
Search |
Today's Posts |
#1
|
|||
|
|||
copying formulas with different references
Spreadheet 1 "Hourly" is referring to Spreadsheet 2 "Daily".
Spreadsheet 1 will contain 744 hourly values in a continuous column. Spreadsheet 2 has the required data arranged by days with twelve rows between each successive day's set of 24 hour data. How do I easily capture the easily refer to the data on Spreadsheet which on Day 1 is in cells B13:B36, on Day 2 is in cells B49:B62, on Day 3 is in cells B73:B106, etc.? There's a pattern, but Excel's not picking it up correctly when I copy the formulas. |
#2
|
|||
|
|||
are you sure the data isn't
Day 1 B13:B36 Day 2 B49:B72 Day 3 B83:B106 Assuming you refer to the day number in a cell on sheet 2 if you want each cell to come over individually for each hour =indirect("Sheet1!B"&(12+hour+36*(day-1))) "Karl in Springfield" wrote: Spreadheet 1 "Hourly" is referring to Spreadsheet 2 "Daily". Spreadsheet 1 will contain 744 hourly values in a continuous column. Spreadsheet 2 has the required data arranged by days with twelve rows between each successive day's set of 24 hour data. How do I easily capture the easily refer to the data on Spreadsheet which on Day 1 is in cells B13:B36, on Day 2 is in cells B49:B62, on Day 3 is in cells B73:B106, etc.? There's a pattern, but Excel's not picking it up correctly when I copy the formulas. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shortcut for copying formulas referencing different worksheets | Excel Discussion (Misc queries) | |||
Excel Error when copying formulas | Excel Worksheet Functions | |||
excel 2002 - copying formulas to another worksheet | Excel Discussion (Misc queries) | |||
Replicating Formulas with Various Worksheet References | Excel Worksheet Functions | |||
Copying options: contents, results, formulas, etc. | New Users to Excel |