Ok I missed that the formulas did not copy over fully when I made this little example spreadsheet. The attached version should have that fixed.

I am trying to summarise some of the data from the 'Master Data' tab into the 'Summary data Panels' tab based on the panel numbers within each site. I have already gone through and made a note of the data ranges for each panel, these are listed in the 'Summary data Panels' tab column AH and the values relate to the 'Master Data' tab.

The formulas that I am using are listed in the 'Master Data' tab X2:AE16.

Using the Data ranges listed in the 'Summary data Panels' tab I copy and paste the relevant data range into the formulas adding the relevant column letter (listed in brackets above each formula). Once these formulas have been completed for a panel (or data range as listed in AH) then they are copied into their relevant positions in the 'Summary data Panels' tab. These positions are highlighted in orange in the 'Summary data Panels' tab.

This whole process is manual. I am looking for a way to automate it a bit. Its not a simple as dragging the corner down as the data ranges for each panel are different. I need a way for the formulas to be locked to a column and then can refer to the AH column to find the data range or some other solution which doesn't have me manually copying and pasting each entry.

I really appreciated your help I have gone through 5000 entries this way and still have 7000 to go I would love any way to speed this up

Attached Files

Flaking data.xlsx (424.9 KB, 9 views)