VBA script to copy data to another worksheet if the conditions

Closed
r_jayesh Posts 1 Registration date Monday December 21, 2015 Status Member Last seen December 21, 2015 - Dec 21, 2015 at 05:53 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Dec 23, 2015 at 05:53 AM
Hi ,
Can someone help to give some VB script copy data from one sheet to new sheet if the conditions matches. I have a guest list with name, email address, mobile no .... and dates for as 19-Jan , 20- Jan & 21-Jan, I want all 19-Jan data to be copies to new worksheet , and all 20th to new and 21st in to new, and whenever I update in the master database, those changes should reflect in the worksheets like 19th , 20, Please someone help to do this, Thanks in advance

1 response

vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 259
Dec 23, 2015 at 05:53 AM
Hello R_jayesh,

Will it always be 19th, 20th and 21st of January? If not, what other dates? The rest of the year?

Please expand your post with more detail and perhaps upload a sample of your work book but change any data to dummy data. You can upload a sample of your work book by using a free file sharing site such as DropBox, ge.tt or SpeedyShare and then post back with the link to your file.

Cheerio,
vcoolio.
0