A Mirroring Spreadsheet...

J

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.
 
J

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
 
J

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
 

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