multiple cell reference from sheet to sheet

K

KMR R.A.

help please.....

I would like to have my list of project names & their respective #s as an
original column on the first work sheet and reference it to subsequent
worksheets so that adding a project name can only be done on the first sheet
and coalating entire rows per column headers can be done on any sheet even if
the subsequent sheets have additional or different column headers. (or
something similar)

(i am excel iliterate, for now)

i.e.
1-Proj Closeout (worksheet)
A B C D
E F
1 project# project name project type construction $
sf $/sf
2 2008-01 Smith 01-Custom Home $1.3
6,500 $200
3 2008-02 Jones 02-Retail-new bldg $$$$$
#### $$$$

2-Residential summary (worksheet)
A B C D
E F
1 project# project name project type construction $
sf $/sf
2 2008-01 Smith 01-Custom Home $1.3
6,500 $200

3-Retail summary (worksheet)
A B C D
E F
1 project# project name project type construction $
sf $/sf
2 2008-02 Jones 02-Retail-new bldg $$$$$
#### $$$$

kmr
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top