Macro to separate out raw data

Very difficult but any help or direction would be GREATLY appreciated. Here is what I am trying to accomplish:

I am trying to write a macro that will separate out the 'Data' tab in the attached document. It will look in Column 'D' from the 'Data' tab and match the name with the worksheet.

1.) Column A from the data tab would go into the 'submitted date' field for the different tabs
2.) Column J would go in the 'client name' column
3.) Column L would go in the 'carrier' column
4.) Column M would go into the 'monthly premium' column
5.) Column Z would go into the 'status' column
6.) Lastly, Column C in the data tab would have to read 'Medicare Supplement'. If it read something else, it would not go into the 'Medicare Supplement' section of each worksheet. It would just stay where it is.

In summary, if the 'Data' tab had a row that read 'Spencer Dean' in column D, the policy information for that row would populate into the 'Spencer Dean' worksheet in b6:f55.

If this is way too complicated or not possible, please let me know. Thank you to anyone whom reads this, whether you can offer any direction or not.

jph89,

This is entirely possible, though its unlikely you'll find someone willing to create it for you from scratch. As some pointers to get you started, I'd loop through your different worksheet names (ignoring the worksheet name 'Data') and filter on column D for that text. Then copy paste from the 'Data' tab to that worksheet to the appropriate columns.

jph89,

Did you attach something to your most recent post or in your original post? Because I don't see an attachment in post 3 and I don't see that the original post was edited.
(Edit: I see you have attached the file now)

As for your question, you don't need to apply the filters on the sheets anywhere, they would only exist in the macro code. The sheet getting filtered is the 'Data' sheet column D. So if you have a sheet named "aaa" and a sheet named "bbb", sheet 'Data' column D would get filtered "aaa" and all resulting rows would be copied to sheet 'aaa' in the appropriate places. Then sheet 'Data' column D would get filtered for "bbb" and all resulting rows woulc be copied to sheet 'bbb' in the appropriate places. So the only thing getting filtered to sheet 'Data' column D. The filter criteria are the other sheet names.

You can try this, but will error out if sheet doesn't exists

Please Login or Register  to view this content.