I have a workbook with several worksheets I want to create a new worksheet that consolidates all the weekly and monthly totals (see attached). Note the first worksheet has a different layout than the rest of the worksheet. I have created named ranges for all of the data's values. Any help appreciated
Have you considered having all data entry on 1 sheet for this? You could include a column for the person's name, and have all data entered into a single table. You could then run a summary from that single sheet
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I want each person on a separate sheet. It would end up too big as there is usually heaps of notes that goes with each sheet. That's why I created columns for week/month num & totals so I could then easily summarise the data.
define too big?It would end up too big as there is usually heaps of notes that goes with each sheet.
And what would a sample answer look like?
Attached is a sample from this FY. I'm setting up for next FY. I would prefer each persons on separate sheets so I easily just open that sheet to look at what has been done throughout the year and then can make up invoices from information displayed on each sheet. Entry dates for each person are a several days a week, all year round.
I agree with FDibbins, to get all data on 1 sheet.
After that it is easy to analyze the data, with a pivot table.
See the attached file, to get an idea (of a pivot table).
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Thank you for you help, time and effort.
Since you are relative new on the forum.
It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks