K
kmr
How can I have a master list of names on one sheet that reflects in
subsequent sheets and when coalated by row will coalate on subsequent sheets.
i.e.
first sheet is a column of project names & #s
subsequent sheets are "Residential Projects" "Commercial Projects" etc. w/
column headers for things like "sqaure footage", "total construction cost",
etc.
When I coalate the first sheet by name or # it's respective row on the
subsequent sheets coalates with it and vise versa.
Any suggestions would be appreciated.
subsequent sheets and when coalated by row will coalate on subsequent sheets.
i.e.
first sheet is a column of project names & #s
subsequent sheets are "Residential Projects" "Commercial Projects" etc. w/
column headers for things like "sqaure footage", "total construction cost",
etc.
When I coalate the first sheet by name or # it's respective row on the
subsequent sheets coalates with it and vise versa.
Any suggestions would be appreciated.