A Mirroring Spreadsheet...

[J Ray]

Im creating a workbook that on one sheet will have about 25 columns of
information, and a row for each item. What I want my outcome to be is a
spreadsheet that mirrors the master, but is limited with the columns that is
in it. Basically, I want it to be a quick reference sheet to the master. Is
there a way to do this? I would be addiding and deleting things from the
"master" and would like the "reference" sheet to reflect the same
information, less a couple columns.

I work in the construction company, and the "master" sheet reflects all the
current jobs we have open, and contains the job name, start & completion
dates, location, engineer, crew, job type, job number, invoiced amount,
received amount, notes, etc.... Im wanting this "reference" sheet to have
just the job name, crew, start date, completion date and notes on it. Then
when I delete a job from the "master"(store it in another sheet), the
"reference" sheet will show the same thing.

It may sound confusing, but that is what Im needing. Any help that you
could give would be great. If there is a formula for this, Im just not sure
of the name. If someone could point me in the right direction, that would be
great

Thanks again for all the help.

 

[Simon Lloyd]

Why use seperate workbooks?, it would be a lot easier in the sam
workbook, you can simply use something like this: Sheet1!A1 in sheet
and copy down, do the same for each column you want to show (chang
Sheet1 for your master sheet)

Im creating a workbook that on one sheet will have about 25 columns o
information, and a row for each item. What I want my outcome to be is
spreadsheet that mirrors the master, but is limited with the column
that i
in it. Basically, I want it to be a quick reference sheet to th
master. I
there a way to do this? I would be addiding and deleting things fro
th
"master" and would like the "reference" sheet to reflect the sam
information, less a couple columns

I work in the construction company, and the "master" sheet reflects al
th
current jobs we have open, and contains the job name, start
completio
dates, location, engineer, crew, job type, job number, invoiced amount
received amount, notes, etc.... Im wanting this "reference" sheet t
hav
just the job name, crew, start date, completion date and notes on it
The
when I delete a job from the "master"(store it in another sheet), th
"reference" sheet will show the same thing

It may sound confusing, but that is what Im needing. Any help that yo
could give would be great. If there is a formula for this, Im just no
sur
of the name. If someone could point me in the right direction, tha
would b
great :

Thanks again for all the help

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com

 

[J Ray]

Thanks for that...I didn't even think of using Sheet1!A1. I appreciate it.
I am still having a problem.

I wont be using seperate wookbooks, just seperate spreadsheets. Each
spreadsheet will represent a contractor that we work with. These can be
considered the "master" sheets. Then I am needing to have that "reference"
sheet that I spoke of before. I need to pull all of the jobs, from each
contractor (on seperate sheets) into the "reference" sheet...to use as a
scheduling aid. Then, once a job is complete, I will be removing the job
from the contractor sheets, and would like the "reference" sheet to reflect
the same thing.

I 'm not sure if this will be too complex, or if Im just thinking about it
too much, and it's a simple formula. I appreciate any more help you could
give.

Thanks so much!!!!
J Ray

 

[Simon Lloyd]

Ideally i need to see a workbook to help you with that, the workbook ca
contain dummy data but the data type should be the same and so shoul
the structure
For further help with it why not join our forums (shown in the lin
below) it's completely free, if you do join you will have th
opportunity to add attachments to your posts so you can add workbooks t
better illustrate your problems and get help directly with them. Also i
you do join please post in this thread (link found below) so that peopl
who have been following or helping with this query can continue to d

Thanks for that...I didn't even think of using Sheet1!A1. I appreciat
it
I am still having a problem

I wont be using seperate wookbooks, just seperate spreadsheets. Eac
spreadsheet will represent a contractor that we work with. These can b
considered the "master" sheets. Then I am needing to have tha
"reference
sheet that I spoke of before. I need to pull all of the jobs, from eac
contractor (on seperate sheets) into the "reference" sheet...to use a

scheduling aid. Then, once a job is complete, I will be removing th
jo
from the contractor sheets, and would like the "reference" sheet t
reflec
the same thing

I 'm not sure if this will be too complex, or if Im just thinking abou
i
too much, and it's a simple formula. I appreciate any more help yo
coul
give

Thanks so much!!!
J Ra






Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1
(http://www.thecodecage.com/forumz/showthread.php?t=124433

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com

 

[J Ray]

Thanks Simon! I did join, although I wasn't competely sure how to attache
the current thread, so I just copied our conversation, and posted it with a
dummy file.

Any help that you could give would be great.

Thanks again,
J Ray