Currently, a spreadsheet is filled out on a weekly basis to update ongoing monthly costs (invoices etc).
The spreadsheet has 6 tabs, relating to different types of cost.
What I want to do, is create a spreadsheet (or copy the data to an existing spreadsheet, either/or) and have all the copied data on one sheet.
A typical entry will have invoice date/description/invoice number/PO number/Cost/Tax/Total
For example
Sheet 1 has 40 entries
Sheet 2 has 10 entries
Sheet 3 has 150 entries
Sheet 4 has 5 entries
Sheet 6 has 25 entries
(each month there will be a different amount of entries)
The final sheet will have the breakdown of all entries, with a total at the end of that section. Then a grand total at the end. There has been errors made by staff doing this task though, so I feel that an automated process might reduce such errors. I'm not great with VB, but if I could get this working, then future changes I should be able to figure out.
Whether it would be easier to copy all to a sheet on the original, then copy to a new file/spreadsheet afterwards I don't know.
Any help would be greatly appreciated.
Thanks
The spreadsheet has 6 tabs, relating to different types of cost.
What I want to do, is create a spreadsheet (or copy the data to an existing spreadsheet, either/or) and have all the copied data on one sheet.
A typical entry will have invoice date/description/invoice number/PO number/Cost/Tax/Total
For example
Sheet 1 has 40 entries
Sheet 2 has 10 entries
Sheet 3 has 150 entries
Sheet 4 has 5 entries
Sheet 6 has 25 entries
(each month there will be a different amount of entries)
The final sheet will have the breakdown of all entries, with a total at the end of that section. Then a grand total at the end. There has been errors made by staff doing this task though, so I feel that an automated process might reduce such errors. I'm not great with VB, but if I could get this working, then future changes I should be able to figure out.
Whether it would be easier to copy all to a sheet on the original, then copy to a new file/spreadsheet afterwards I don't know.
Any help would be greatly appreciated.
Thanks
