Macro to sort and place data in adjacent columns

[T15K]

Hello

I am trying to create a macro to sort some data and then place it in separate in tabs depending on the case. There are 3 possible cases in Col A (ABC), 2 cases in Col B (1,2) and col C and D contain values.
I have attached an example excel file which illustrates the problem. Basically, the process is the same sorting all the data by col A, then col B, then col C, and then copying each group across into separate tabs.

While sorting data using the "sort" function in the "data" tab and copying and pasting is a simple way to achieve the outcome it is a bit time consuming, and as I need to do this for >150 different files, if it were possible to create a macro to automate this process I would be very grateful.

Please contact me if you require any further information.

I thank you in advance for your assistance

T15K

[noboffinme]

Hi T15K,

Can you be a bit more specific about what you want this macro to do?

Could you describe it in steps such as

1."Sort Column 'A' on the 'Raw Data' worksheet, then Copy Columns 'A' - 'D' & Paste the Range 'A2'-'D6' into the 'A1' worksheet in the correct Columns" for example.

2.Next step

3.Next step

Thanks

[T15K]

As you can see in the example spread sheet, I would like a macro that copies rows of data from the raw data tab into the corresponding tab based on the value that appears in Col A and Col B. For example, if there is A in col A, and B in col 1, then copy that row of data into the tab called A1. If the data is C in Col A and 2 in Col B, then that row of data is copied into the tab called C2.

I hope this clears it up
T15K

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[T15K]

Hi John,

Thank you for that excellent solution. Can I just request one modification?
The macro that you created adds new tabs for each type of data (E.g A1, B2 etc).
Would it be possible for me to already have the tabs set up and named in the worksheet, and then the macro just copies the data into the corresponding existing named tab?
The reason for this request is that I need to have some other basic formulas and formatting already set up in each tab, and then just have the data fed into there, rather having the macro create a new tab each time. Does this make sense?

I hope this is not too difficult to do and I thank you again for your help so far.

T15K

[JOHN H. DAVIS]

It doesn't sound too difficult. Can you provide the tab names? Also an attachment with a sample of where to paste?

[JOHN H. DAVIS]

See if this helps?

Please Login or Register  to view this content.

It assumes the Sheet names are set up as before with the Category and Type.

[T15K]

Thanks John. That is perfect. Thank you very much for your help.

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.


9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.