Can a macro / formula be made to automate data moving to tabs?

[LDouble3]

Hi,

If anyone can help me with this it would be great.

Basically the attached spreadsheet has two tabs 'Paste sheet 1' and 'Paste sheet 2' which data is pasted into each week. i then have to manually filter by column I and copy and paste the entire data (rows) to the corrisponding Tab.

eg: Filter I by SALES and copy and paste all data into the 'Sales' tab.

Both sheets that i paste data in have data for each tab so the data is simply put onto the same tab.

Can a macro run this for me as the key is filtering column i which will always be this column and then moving all the data to the correct tab referring to column I

Any help on this would be a massive help.

Cheers.

[arlu1201]

Any reason why there is data in 2 paste sheets and not in one?

Also, is it possible to change the tab name from Admin to Administration Salaries? This is to ensure smooth copy paste of the data.

[LDouble3]

Hi,

Yes i can have the names of tabs changed to names of column I, this is not a problem.

Reason there are 2 sheets is because i will be copying the data from 2 different sources so i need to keep them separate for audit purpose but i would like the macro to combine them onto the same tab literally one below another on the same tab would be fine .... if this makes sense!

[arlu1201]

Try this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button

[LDouble3]

Arlu, thank you so much this now works!!