Copy rows to total page
Solved/Closed
Tom
-
Feb 12, 2010 at 10:52 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 12, 2010 at 03:51 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 12, 2010 at 03:51 PM
Related:
- Copy rows to total page
- Total copy - Download - File management
- Total video converter free download - Download - Video converters
- Excel duplicate rows n times ✓ - Excel Forum
- Quick heal total security removal tool ✓ - Antivirus Forum
- Total war warhammer3 скачать - Download - Strategy
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Feb 12, 2010 at 12:02 PM
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 ?
Feb 12, 2010 at 12:19 PM
Different people will get the monthly forms that have the titles January, February, etc... and the manager gets the total page.
Feb 12, 2010 at 03:51 PM
Assumptions.
1. The sheets are names Jan, Feb, ....
2. The Master sheet is called Master
3. The column 1 does not have blank value (it is used to find the max number of rows)
4. There are no more than 11 columns
5. Master sheet already have header row.