Hi All,

I have looked through past threads so please accept my apology if this has already been covered.

I have a set of data, it is a horrible data dump from an online form and I do not need it all, only specific columns contain the data I want.

Furthermore, each time the online form is completed, the questions are tailored based on business sector. Hence there is data in different columns that I would like to group into a single column under that heading.

To clean this data, I want to copy the data I need for each category and paste it into a different tab.

To help further articulate, if the category in cell C3 reads Apples, copy Sheet1.E3 to Sheet2.C1 and if cell C4 reads Pears, then copy Sheet1.J4 to Sheet2.C2.

So if E3 contains the profit for company in row 3 and J4 contains the profit for company in row 4 - the profits for each company will now be collated into one column under 'company profit'. Excel will know which cells to copy based on the value in the category field in the data source.

It would be incredible if I could work out how to get a Macro to run the above instruction for every row in a selection and paste into next tab starting from first empty row.

I hope that makes sense, any help would be appreciated! I am really stuck. Thanks in advance.