Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
TW
Lv 5
TW asked in Computers & InternetSoftware · 10 years ago

select info by date in Excel?

Hello.

What I would like to do is:

have a worksheet with all the data in, the column headings would be:

date | description | price

then on a separate worksheet I want an invoice where I can enter 2 dates and it will pull through all the data falling within those 2 dates.

I am hoping that, for example, if there are 10 rows of data falling between the 2 dates, that the 10 rows will be pulled through and appear on the invoice page.

I hope that makes sense, and thank you for any help.

1 Answer

Relevance
  • garbo7441
    Lv 7
    10 years ago
    Favorite Answer

    You will have to use a macro or event handler in VBA to accomplish this. What are the worksheet names and which row in the 'invoice' worksheet will be the first row to contain the extracted data?

Still have questions? Get your answers by asking now.