Previous Topic Next Topic

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 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - 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

Answer 1 / 1
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 262
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

Similar discussions

Can no longer paste text into insta
6hypnone -
Richierichmeister -

6 responses
How can I make my name text invisible in Discord
imbenmark -
imbenmark -

4 responses