Feb 12, 2010 at 10:52 AM
Posts4479Registration dateThursday January 28, 2010StatusContributorLast seenMay 5, 2022
Feb 12, 2010 at 03:51 PM
I have an Excel spreadsheet with 13 worksheets. The first 12 worksheets are January through December. The 13th worksheet is a total. Each worksheet has identical columns and rows.
In all worksheets, there are about 10 columns like Date, Name, Address, Account Number, Department, Employee Name, etc...
What I am trying to do is enter the information in each monthly worksheet and have the data I'm entering automatically copied to the total worksheet. The total worksheet would contain all the data entered. I'd have a monthly breakdown, but the total page contains all transactions.
I have all the worksheets set up, but can't come up with the code to do the copy. Any suggestions, please?
Posts4479Registration dateThursday January 28, 2010StatusContributorLast seenMay 5, 2022767 Feb 12, 2010 at 12:02 PM
With macro it can be done. But why have 13 sheets ? why not have one sheet from the start where you enter all your transactions, have a column there for month (if not already there) and then if you want to see some monthly transaction, just filter on that month ?