Display info from a separate report by matching the date

**Srp** · 05-31-2011, 06:07 AM

Hello all,

I'm trying to get one report (that is created daily) to pull information for that date from another report (which is build more like a database, containing all the daily info for the entire year thus far). These are two separate workbooks in separate folders.

On the first report, I have the date set up automatically with =Today()-1. I'm using the -1 because the report is created around 3 or 4 in the morning the next day, but is reporting the previous day volumes and times.

I was trying to get a formula that would compare the date cell at the top of the first report (ex. A1) with column A (which is the list of dates for the year) on the second report. Once it found a match, it would then pull the corresponsing info from column C (volume) and column D (finished time) of the second report and display them in cells (ex. B5 and C5) on the first report.

If any more information is needed, please let me know.
Any help would be greatly appreciated.

**Richard Buttrey** · 05-31-2011, 06:19 AM

Hi,

Please Login or Register  to view this content.

where Book2 contains the second report. If Book2 is not open in memory you'll need to preface the [Book2] references with the drive and path, e.g. C:\MyFolder\[Book2]

Change the row refs 1:100 as appropriate

Regards

Regards

**Srp** · 05-31-2011, 06:58 AM

It worked! Thank you very much.

**tsparacino** · 06-02-2011, 09:58 AM

Originally Posted by Richard Buttrey

Hi,

Please Login or Register  to view this content.

where Book2 contains the second report. If Book2 is not open in memory you'll need to preface the [Book2] references with the drive and path, e.g. C:\MyFolder\[Book2]

Change the row refs 1:100 as appropriate

Regards

Regards

I'm glad I found this thread because I'm trying to do a similar task, just slightly different... here's the setup:

Sheet 2 of my workbook contains a database of information... several hundred entries. Each row contains data like this: Location, coverage time, start time, end time, and other non pertinent info.

Sheet 4 of my workbook needs to be a report that lists the Location, coverage time, start time and end time only and only if one of the other non-pertinent cells in that row is greater than 0.

I could easily do this with an IF function for each column, but the only way I know to do it is for Sheet 4 to mirror sheet two row for row, however I don't want 50 blank rows before I get to another true return... If the rows in Sheet 2 that need to be returned and displayed on Sheet 4 are rows 2, 50, 150, and 200 I want them all listed one below the other (e.g. rows 2,3,4,5 etc) As I'm sure you guessed, Sheet 4 is a report page giving a snap shot of Locations and their data that meet the criteria... ANY help would be greatly appreciated. I've hit a wall.

Thanks!

**Richard Buttrey** · 06-02-2011, 11:43 AM

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

Regards