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.

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

J Ray;449459 Wrote:
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

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=124433

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" wrote:


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

J Ray;449459 Wrote:
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

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=124433

Ideally i need to see a workbook to help you with that, the workbook can
contain dummy data but the data type should be the same and so should
the structure.
For further help with it why not join our forums (shown in the link
below) it's completely free, if you do join you will have the
opportunity to add attachments to your posts so you can add workbooks to
better illustrate your problems and get help directly with them. Also if
you do join please post in this thread (link found below) so that people
who have been following or helping with this query can continue to do
so. :)J Ray;450046 Wrote:
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" wrote:


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

J Ray;449459 Wrote:
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

Regards,
Simon Lloyd
'Microsoft Office Help' ('http://www.thecodecage.com'
(http://www.thecodecage.com/))

------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon
Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread: 'A Mirroring Spreadsheet... - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...d.php?t=124433)




--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=124433

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

"Simon Lloyd" wrote:


Ideally i need to see a workbook to help you with that, the workbook can
contain dummy data but the data type should be the same and so should
the structure.
For further help with it why not join our forums (shown in the link
below) it's completely free, if you do join you will have the
opportunity to add attachments to your posts so you can add workbooks to
better illustrate your problems and get help directly with them. Also if
you do join please post in this thread (link found below) so that people
who have been following or helping with this query can continue to do
so. :)J Ray;450046 Wrote:
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" wrote:


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

J Ray;449459 Wrote:
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

Regards,
Simon Lloyd
'Microsoft Office Help' ('http://www.thecodecage.com'
(http://www.thecodecage.com/))

------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon
Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread: 'A Mirroring Spreadsheet... - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...d.php?t=124433)




--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=124433