How do you show data from 1 sheet to another based on date?

November 16, 2015 at 16:39:35
Specs: Windows 7
I'm building a spreadsheet to compare sports statistics where the match-ups are different every week. I'd like to have a sheet which has each team's schedule including date and "week number". Another sheet will have each team's stats. And the third sheet will show me a breakdown of the match-ups based on the current date. I'm stuck on having Excel recognize which information to pull from based on the date.

See More: How do you show data from 1 sheet to another based on date?

Report •

November 16, 2015 at 16:54:46
Without some idea of how your data is laid out, it's a little tough to give you a specific answer.

A common method for pulling data from one range to another "based on" something is VLOOKUP. If you read up on that function, you may find that it will work for you.

If not, or if you can't figure it out, you'll need to post some example data so that we know what we are working with. Please click on the following line and read the instructions found via that link before posting your example data.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question