Hi,
I currently have a master address file (approx. 1100 contacts) and 8 separate sheets where I can keep addresses organized by category (Professional, Medical, etc.). In column A I have an indicator that shows which other sheet the contact also belongs in.
I was wondering if anyone knew how to use visual basic coding to write a macro to scan the first sheet, copy the rows based on the criteria in column A, and paste them into their respective sheets. This way I would only have to update the main sheet and run the macro to organize the file. If you show me how to code it for just one or two of the sheets I could figure the rest out from their.
Thanks
Bookmarks