Hi everyone.
I have a simple table that has expenses in.... Date, Description, amount and ExpenseType.
On a separate tab I have a summary table to give a total of each expense type using the Sumif function.
Sometimes we get data that is out of the range we are working on and then we split it out and do a summary for the split data. What I am looking to do is formulate the summary table (possibly need to be done with VBA, not sure) so that it only totals the visible records in the expenses table, so that we can simply choose that data range we are using and the summary reflect this.
Another possible way would be to have two date ranges on the summary tab and use these as comparative data criteria.
I'm not really sure the best way to start looking at this.
I'm kinda thinking whilst I type and another way would be to have the main data table, then a second data table that pulls records through based on date criteria, (although I have had issues with table size being either too big or too small for the data) then summarise the second table.
Sorry for waffling.
Any pointers would be appreciated.
Thanks
I have a simple table that has expenses in.... Date, Description, amount and ExpenseType.
On a separate tab I have a summary table to give a total of each expense type using the Sumif function.
Sometimes we get data that is out of the range we are working on and then we split it out and do a summary for the split data. What I am looking to do is formulate the summary table (possibly need to be done with VBA, not sure) so that it only totals the visible records in the expenses table, so that we can simply choose that data range we are using and the summary reflect this.
Another possible way would be to have two date ranges on the summary tab and use these as comparative data criteria.
I'm not really sure the best way to start looking at this.
I'm kinda thinking whilst I type and another way would be to have the main data table, then a second data table that pulls records through based on date criteria, (although I have had issues with table size being either too big or too small for the data) then summarise the second table.
Sorry for waffling.
Any pointers would be appreciated.
Thanks