need to copy all entries with todays date into another worksheet

T

Tester

Hi there,

I have a spreadsheet which contains 10 workbooks.

Each workbook contains 1 data entry per row (consisting of 10 fields
across) - the first field being the date.

What I need is to automatically show ALL entries for today (or a
specific date that I put into cell A1) from the 10 workbooks into a
summary workbook.

Some of the fields in the 10 workbooks contain @sum formulas, and i
want to copy just the number, rather than the formula itself (hope
that makes sense)

Would appreciate any advice you could give me.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif or other formula needed for multiple data/critera results 3
Fixing date of entry 14
Calculating an average of data between two dates 1
Totaling Volume within a range of dates 3
Show value from one cell in another cell if today falls between a date range 5
Copy to another worksheet IF 3
Using SumIf Across Multiple Worksheets - Excel 2003 0
Formula results display only after pressing Enter key 1

Top