So I have a sheet with data (data sheet). Each rows is a data points and the columns are metadata for each point.
I want to split the data into 4 rows in another sheet (schedule sheet)so I can see the metadata across a timeline. EG, choose a data point to occur in a particular quarter and show metadata in the three rows below.
I've tried merging rows in the schedule sheet and copy and paste data from data sheet, Excel doesn't allow copy into merged cells. I've also tried using cell references, but when copying references down the references jump by 4 rows.
In the attached example, schedule sheet correctly reads A3, A4 & A5 when manually entered into cells A5, A9 & A13 respectively.
When copying formula down from A13, the formula starts to jump 4 references
Bookmarks