• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1204
  • Last Modified:

Excel sheet structure/design

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.
0
dtebh
Asked:
dtebh
1 Solution
 
Dave BrettVice President - Business EvaluationCommented:
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

Cheers

Dave

0
 
byundtCommented:
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:

Projects
0
 
dbase118Commented:
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.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

dbase118
EE Cleanup Volunteer
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now