technomonkey
03-03-2006, 07:01 AM
Excel VBA - Looking up and Pasting Data
Hi all, I am trying to lookup a date with a description next to it on one worksheet and list all those matches vertically on another worksheet, if the date matches the current date. Basically if i have data:
01/03/2006 Mailing 2
01/03/2006 Mailing 3
03/03/2006 Mailing 4
03/03/2006 Email 5
04/03/2006 Mailing 5
I would like for it for example, for today to bring back on another sheet:
Mailing 4
Email 5
I don't mind if you need to enter a day or month to display this data. It would be even more useful if someone new how I could enter a month and bring back those items listed within that month.
Thanks.
Hi all, I am trying to lookup a date with a description next to it on one worksheet and list all those matches vertically on another worksheet, if the date matches the current date. Basically if i have data:
01/03/2006 Mailing 2
01/03/2006 Mailing 3
03/03/2006 Mailing 4
03/03/2006 Email 5
04/03/2006 Mailing 5
I would like for it for example, for today to bring back on another sheet:
Mailing 4
Email 5
I don't mind if you need to enter a day or month to display this data. It would be even more useful if someone new how I could enter a month and bring back those items listed within that month.
Thanks.