Hey All,
Was wondering if you could help me out with an excel sheet - i have a way of doing what i want to achieve, but it is working out to be very difficult and "messy"
Basically i have a data input sheet which has the Day/Date and then loads of columns, from answered calls, lost calls, average talk times... the list goes on...
What i want to be able to do is on a front sheet have the user enter a date, which then causes the sheet to populate with the details for that date - now i know a VLOOKUP works fine, the problem is the date the enter is the week commencing date so i do not just want that line i want that line and the 6 beneath it all added up.
i.e
09/03 - 10
10/03 - 7
11/03 - 6
12/03 - 5
13/03 - 10
14/03 - 12
15/03 - 10
So when i type 09/03 in the "Week Commencing Box" it does not give me 10, but instead gives me 60.
Any one suggest what to do rather then having 7 VLOOKUPS?
Cheers,
Dan
Was wondering if you could help me out with an excel sheet - i have a way of doing what i want to achieve, but it is working out to be very difficult and "messy"
Basically i have a data input sheet which has the Day/Date and then loads of columns, from answered calls, lost calls, average talk times... the list goes on...
What i want to be able to do is on a front sheet have the user enter a date, which then causes the sheet to populate with the details for that date - now i know a VLOOKUP works fine, the problem is the date the enter is the week commencing date so i do not just want that line i want that line and the 6 beneath it all added up.
i.e
09/03 - 10
10/03 - 7
11/03 - 6
12/03 - 5
13/03 - 10
14/03 - 12
15/03 - 10
So when i type 09/03 in the "Week Commencing Box" it does not give me 10, but instead gives me 60.
Any one suggest what to do rather then having 7 VLOOKUPS?
Cheers,
Dan