macros with conditions

[front-line]

Hi to all, if anyone can help me with the following, it would be really appreciated.

So.. I have 2 sheets.

Sheet2: it contains data that is being imported from an external link with the following info:



Date Time Expected people Amount of people
9/12/2009 8 233 181
9/12/2009 11 346 341
9/12/2009 14 432 389
9/12/2009 17 542 521
9/12/2009 20 654 666
9/12/2009 23 734 719
9/13/2009 8 255 251
9/13/2009 11 366 323
9/13/2009 14 477 454
9/13/2009 17 588 568
9/13/2009 20 699
9/13/2009 23 700
9/14/2009 8 810
9/14/2009 11 920
9/14/2009 14 950
9/14/2009 17 990
9/14/2009 20 1010
9/14/2009 23 1200



I would like to create a Macro in sheet1 where I would have the following information:

Date Time Expected people Amount of people
today's date up to now up to now up to now



And I want it when I run the macro, it automatically refresh the data in sheet2 and put it in sheet1 with the information up to date until now.

Any expert can help ?

[shg]

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.