VBA to Copy/Paste Rows by Client Name to Different Spreadsheet

Closed
Teresa367 Posts 1 Registration date Saturday January 10, 2015 Status Member Last seen January 10, 2015 - Jan 10, 2015 at 06:41 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Jan 11, 2015 at 04:08 AM
Afternoon,
I am new at VBA programming. I have tried sub copyrange and if/then with limited success.

I have a master worksheet and individual worksheets with names from the master.
I would like to have the code automatically be able to find the client's name on the master, copy the row & paste to the client's individual spreadsheet, then sort the individual spreadsheets by date - without duplicating dates.

Any help would be greatly appreciated.

Thank You,
Teresa
Related:

1 response

vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 259
Jan 11, 2015 at 04:08 AM
Hello Teresa,

Have a look at the following thread from a couple of days ago and let us know if its a similar situation to yours:-

https://ccm.net/forum/affich-787457-data-transffering

If it is, I'm sure that we can adjust it a little to suit your requirements.

Best regards,
vcoolio.
0