VBA script to copy data to another worksheet if the conditions

[Closed]
Report
Posts
1
Registration date
Monday December 21, 2015
Status
Member
Last seen
December 21, 2015
-
Posts
1316
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
August 21, 2021
-
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

Posts
1316
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
August 21, 2021
237
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.