I created a spreadsheet with three tabs, one containing a set of dates with sales from last year, one containing a set of dates with planned sales for this year, the last is a summary of last year sales vs. planned sales and a spot to enter projections. What I would like to do is be able to enter a date range and have excel pull the numbers for that range from both of the tabs. Does this make sense? Hope you can help