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. |
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. |
All times are GMT +1. The time now is 02:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com