Summary Sheet

K

kell22

New Member
Joined
Oct 12, 2010
Messages
16
I have a workbook which has 8 sheets of data and what I want is to create a front summary sheet which displays the tasks which are due in the next 7 days from accross all the sheets. Can this be done using a vlookup formula, when I have tried this it only dispolays the first occurance, thus no good as there could be 10 tasks to complete on the same day!

Thanks
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
You must log in or register to reply here.

Similar threads

P
  • Question Question
Ordering and Macros
Replies
0
Views
175
pledge8236
P
S
  • Question Question
Turn around times based on days and hours worked
Replies
2
Views
136
smllchng5
S
S
  • Question Question
Sum total minutes on Excel 365 (web version of Excel)
Replies
2
Views
185
felixstraube
F
X
  • Question Question
How To Create Multiple Sheets(With Criteria) From One Sheet?
Replies
1
Views
328
Kerryx
K
I
  • Question Question
Making code easier to work with at start of new tax year
Replies
2
Views
174
ipbr21054
I

Forum statistics

Threads
1,224,600
Messages
6,179,834
Members
452,947
Latest member
Gerry_F

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top