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

Closed
Teresa367 Posts 1 Registration date Saturday 10 January 2015 Status Member Last seen 10 January 2015 - 10 Jan 2015 à 18:41
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 11 Jan 2015 à 04:08
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 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 262
11 Jan 2015 à 04:08
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.