Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-03-2022, 12:46 PM
ArviLaanemets ArviLaanemets is offline Summing data from multiple worksheets in a workbook and placing into another worksheet Windows 8 Summing data from multiple worksheets in a workbook and placing into another worksheet Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Quote:
Originally Posted by grNadpa View Post
Before I attempt to educate myself on Excel defined tables and Validation lists, would you take a moment confirm that your solution should work for my project?
Yes, it will work!

Designed properly, such design allows:
Register project's detailed phases and their budgets/costs monthly (I advice to use month number in format yyyymm);
Register project's start and end at any month;
Register projects of any length (from single month to several years);
In case this is needed, registering both planned budget and real costs spent;
Design monthly and yearly reports for single project, and as total of all projects in report period;
Design reports for totals of selected project (from start to end);


etc.

Based on your post, I assume the main data entry table will be, where planned (and realized) phases of project are registered (E.g. Month, Project, Phase, [Type], Amount, ...). (Type is optional - in case you want enter both planned and realized phases.)
Reply With Quote
  #2  
Old 10-03-2022, 02:36 PM
grNadpa grNadpa is offline Summing data from multiple worksheets in a workbook and placing into another worksheet Windows 10 Summing data from multiple worksheets in a workbook and placing into another worksheet Office 2016
Advanced Beginner
 
Join Date: Mar 2022
Posts: 46
grNadpa is on a distinguished road
Default

Quote:
Originally Posted by ArviLaanemets View Post
Yes, it will work!

Designed properly, such design allows:
Register project's detailed phases and their budgets/costs monthly (I advice to use month number in format yyyymm);
Register project's start and end at any month;
Register projects of any length (from single month to several years);
Thank you for your encouraging reply.

As mentioned, I have some self-study ahead of me to understand "defined tables" and "Validation Lists". Is "Register" as you use it above also an Excel keyword concept?

And, dare I hope, is there a internet-viewable example in Excel that you know of that approximates your approach?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Summing data from multiple worksheets in a workbook and placing into another worksheet Appending unique data from one worksheet to existing data on another worksheet EdStockton Excel 1 08-06-2014 11:00 PM
Combine or merge multiple worksheets into one worksheet timomaha Excel 1 07-21-2014 01:02 PM
Summing data from multiple worksheets in a workbook and placing into another worksheet Multiple Dynamic Worksheets Consolidated into One Static Worksheet mars1886 Excel Programming 3 02-09-2014 12:50 AM
Summing data from multiple worksheets in a workbook and placing into another worksheet How do I merge data from one sheet in a workbook out into multiple sheets nolesca Excel 4 06-07-2010 08:13 AM
Summing data from multiple worksheets in a workbook and placing into another worksheet Cells from other worksheets apear on current worksheet Equilar Excel 3 05-03-2010 01:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:23 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft