Excel sheet structure/design

Posted on 2003-03-20
Medium Priority
Last Modified: 2012-08-14
I'm attempting to use an excel workbook that contains 2 worksheets for 2 purposes:

1. Summarize data and display in sheet A (project estimates) that is listed in detailed records in sheet B (associated project task entries) and 2. validate items entered in sheet B (task entries) against entries in sheet A (project estmates).

Just can't seem to get the structure working...Is this beyond what excel can do easily and I should just "punt" and use ACCESS?

Maybe someone could point me to an example of a similar structure or just get me started (major hang up is formula referencing ie "PROJECTS" in sheet A from sheet B and vice versa).

Thanks in advance.
Question by:dtebh
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 50

Accepted Solution

Dave Brett earned 300 total points
ID: 8178121
What you are proposing is quite straightforward in excel. There are quite a few ways to skin this particular cat. Here is a start.

1) Use a PivotTable  (look at help)
2) Use COUNTIF & SUMIF formulas
3) Manually add totals up

As your request is rather general it is difficult to provide specific help, if you need further guidance beyond "it can be done", why don't you post an example



LVL 81

Expert Comment

ID: 8178403
to reference Projects on Sheet B, you would call the data (in any spreadsheet formula):

"Sheet A"!Projects

If Projects is used as a range name only on Sheet A, then you could refer to it (on Sheet B) just as:

LVL 15

Expert Comment

ID: 10095441
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Answered by brettdj
Please leave any comments here within the next seven days.


EE Cleanup Volunteer

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
New style of hardware planning for Microsoft Exchange server.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question