Help to create a formulae
I have 5 sheets, Heath, Gary, John and Fred.
They go to their sheet Heading: Date Question1 Question2 Question3 They ent 3/3 5 6 1 They enter a date for each monday its filled out. then enter a number between 0 and 10. I have a mastersheet. It has the same heading as above but with the sheet name in column b What i would like is in the master sheet is if in column4 row1 cell a date. How can i change the date in col 4 row 1 that when it looks at the other sheets it will display only the figures for that date? Hope you understand and can help. Thankyou |
Help to create a formulae
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software "FredDave" wrote in message ... I have 5 sheets, Heath, Gary, John and Fred. They go to their sheet Heading: Date Question1 Question2 Question3 They ent 3/3 5 6 1 They enter a date for each monday its filled out. then enter a number between 0 and 10. I have a mastersheet. It has the same heading as above but with the sheet name in column b What i would like is in the master sheet is if in column4 row1 cell a date. How can i change the date in col 4 row 1 that when it looks at the other sheets it will display only the figures for that date? Hope you understand and can help. Thankyou |
All times are GMT +1. The time now is 11:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com