Help me break this macro into two separate macros?

I need the code below to be two separate macros.

Step one: Take from "source" move to "pay file" then move to "filter"
Step two: move from "filter" to the other five tabs accordingly (rh,vo,wg,nsf,cn), this would have to include A:B as well, as it currently does not.

We have to input more data after the filter that needs to accompany the data over to the other tabs. Previously it was columns "A:J" but now it is "A:L" if that needs adjusting.

attached is a workbook, sheet 1 is the extra data that we must input after the first macro. so if you want to "Run Filter" and copy that data from sheet one into the "filter" A:B, you'll see the corresponding info on the RH,vo,wg,nsf,cn sheets.

The problem with what I have now is if the SSN# doesn't have 9 numbers, then it throws it all off because one data may have 0 in front, or stored as text, or something strange and this way we are just rearranging the current steps into a more friendly way.

Please Login or Register  to view this content.