Hi guys and gals,

After using Excel pretty heavily with work (as an engineer) I've finally given in and trying to learn how to create some Macros to make life with Data Analysis a bit easier.... I'm only just getting into it, and while a few of the ones that I've found and modified have not worked, I've been able to problem solve them until they would.

The problem that I have at the moment is a little more complex... Tried to attach a version of the spreadsheet that I'm working on, but realised that I don't have permissions.

What I'm wanting is as follows.

1 - Raw Data taken from testing and pasted in D2 of "Modified Test Data" worksheet (extending to EF25 at least, possibly more). This data is then rounded (to create new data shown in columns A & B), duplicates removed and then sorted. This gives the output as currently existing in the "Modified Test Data" worksheet. This data can be varied numbers of columns and rows

2 - I then want to be able to automatically Delete any existing data in the "Engine Analysis" worksheet, and copy the columns of data (from Row 4 down) from "Modified Test Data" to the "Engine Analysis" worksheet, and paste them according to the headers (Preferrably matching Headers from both rows 2 and 3).

Note - There are some cases where there are multiple headers with the same values in "Engine Analysis" as the data is used for a number of calculations.

Currently I've played around trying some macros that I've found online, but having issues problem solving why they don't appear to be copying... One of these is included in the attached spreadsheet, although it doesn't delete existing data and also doesn't reference the headers in row 3.


Would really appreciate some assistance with this if possible

Andy
Power Curve Analysis - 2.xlsm