Sort - copy rows to corresponding worksheet

Hello,

I have a spreadsheet that contains a seperate worksheet for each property. The first worksheet is where a list of invoices recieved will be entered with several bits of information. What I need is for all of the information on the first sheet to be copied to the correct worksheet based on the address which is in column A. Each week the information in the first sheet "invoices" will be cleared and new information will be entered that will be need to copied to the corresponding property worksheet. The code I have copies the information but I get an error when there is an address that does not have a worksheet with the same name. Is there a way to have it prompt the user to either correct the address if it was a typo or create a new worksheet? Thanks for any help.

here's the code:

Please Login or Register  to view this content.

Thanks a bunch John! That works great. Now my program runs "test for sheets" and if no new sheets are required then the sort subroutine runs. Thanks for your help.

Maybe this is a question for another post but is there a way to alter the code posted about so that after it is determined that a row is to be copied to a worksheet, there is a check to see if the row being copied already appears in the worksheet? Possibly something that checks the data in columns B, C, D and if they're all identical to a row already in the worksheet then a message pops up detailing the duplication?

kcj
KJ

Hey John,

I guess my first concern is double posting. I wouldn't whoever was in the spreadsheet to accidentally run the macro twice before the data in the first sheet had been cleared, thus causing each sheet to have double record of an invoice. I think to fix this I could have the "invoice" sheet cleared after all of the data has been copied. This first sheet will be cleared, with new data entered and copied weekly so I guess that would work.

A secondary concern was that sometimes our vendors will send us a copy of an invoice we've already recieved and we pay it again not realizing that it's a duplicate. We often receive so many invoices that it's hard to notice duplicates. I agree, such a detailed, column by column check would probably end up being more trouble than it's worth. I agree with the part about being careful lol. I will just start recording the invoice number and maybe a check of just that column would be more feasible. Would that be something I could implement easily with vlookup? I'm guess that would go right before this part of my code:

Please Login or Register  to view this content.

KJ

Thanks John. One question about the code you provided, is there an easy way to apply a format to each sheet created by the sheets.add.name line? Maybe if "sheet2" has the desired headings, format, conditional format applied to a certain column, could I just have each new sheet follow that format?

KJ