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
1345
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 20, 2022
- 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 reply

vcoolio
Posts
1345
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 20, 2022
249
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