Ok here is the Sheet im working on.
If you go to the first sheet (Monthly summary) theer is essentially a table that summaries all the costs in the other 31 sheets (each representing a day of the month)
What i am trying to do is, for example in the sheet ('1') (day 1) im trying to reference cells j81 to r81 into the 'monthly summary' sheet into cells J5-J13.
And i want to do that for each day of the month, i.e. 31 sheets, so for day 2 of the month (2!) i want to put j81-r81 into "monthly summary" K5-K13 and so on for each day.
And i have 3 tables to fill. so as u can imagine it would take ridiculously long to reference each cell individually from each other 31 sheets. I treid something with index in the K column but its wrong :S
Thanks for your help, it is really appreciated.
Bookmarks