Hi, I have a workbook with 8 worksheets. The first is the "master". In A1 to
J1 I have names (each are different) and G-I have two rows that have names. I
haven't figured out how to make 2 column cells combine to make one yet. A few
of the rows have drop downs so i can select different inputs to the column. I
want to find out how to make a formula so when i add new info, it adds it to
the other appropriate worksheet. That way I dont have to cut and paste. Any
ideas on how this can be done? I'd appreciate any help. Thanks, Scott

To combine the first name in G2 and last name in H2, put this in I2:
=G2&" "&I2

I have some suggestions for you, but I don't know if any of them are what
you're really after since I'm not sure what your other worksheets contain or
accomplish.

One solution is to just apply an auto filter to the Master...then you may
find the other sheets are no longer needed.
Another solution is to use pivot tables on the other sheets to offer summary
reporting from various angles based on the data in the Master.
A third idea is to enter the data on the "other" respective page to begin
with and tell the Master to copy the data from all the other pages...much,
much easier than what you have asked for here.
Otherwise, you're going to need a macro, and macros that copy data in real
time are generally not a good idea. Most folks use built-in Excel tools to
summarize or reorganize the existing data from its raw state in order to
maintain the data's integrity.

If you need help tackling one of the above (like trying out option #3
above), let me know and I'll help. It would be good if you could expound on
what each field contains on each worksheet.

-KC
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Scott" wrote:

Hi, I have a workbook with 8 worksheets. The first is the "master". In A1 to
J1 I have names (each are different) and G-I have two rows that have names. I
haven't figured out how to make 2 column cells combine to make one yet. A few
of the rows have drop downs so i can select different inputs to the column. I
want to find out how to make a formula so when i add new info, it adds it to
the other appropriate worksheet. That way I dont have to cut and paste. Any
ideas on how this can be done? I'd appreciate any help. Thanks, Scott

KC, could I send you the file and then you can make a recommendation on how I
might accomplish what I'm trying to do?

Scott

"KC Rippstein" wrote:

To combine the first name in G2 and last name in H2, put this in I2:
=G2&" "&I2

I have some suggestions for you, but I don't know if any of them are what
you're really after since I'm not sure what your other worksheets contain or
accomplish.

One solution is to just apply an auto filter to the Master...then you may
find the other sheets are no longer needed.
Another solution is to use pivot tables on the other sheets to offer summary
reporting from various angles based on the data in the Master.
A third idea is to enter the data on the "other" respective page to begin
with and tell the Master to copy the data from all the other pages...much,
much easier than what you have asked for here.
Otherwise, you're going to need a macro, and macros that copy data in real
time are generally not a good idea. Most folks use built-in Excel tools to
summarize or reorganize the existing data from its raw state in order to
maintain the data's integrity.

If you need help tackling one of the above (like trying out option #3
above), let me know and I'll help. It would be good if you could expound on
what each field contains on each worksheet.

-KC
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Scott" wrote:

Hi, I have a workbook with 8 worksheets. The first is the "master". In A1 to
J1 I have names (each are different) and G-I have two rows that have names. I
haven't figured out how to make 2 column cells combine to make one yet. A few
of the rows have drop downs so i can select different inputs to the column. I
want to find out how to make a formula so when i add new info, it adds it to
the other appropriate worksheet. That way I dont have to cut and paste. Any
ideas on how this can be done? I'd appreciate any help. Thanks, Scott

Absolutely. Feel free.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Scott" wrote:

KC, could I send you the file and then you can make a recommendation on how I
might accomplish what I'm trying to do?

Scott

"KC Rippstein" wrote:

To combine the first name in G2 and last name in H2, put this in I2:
=G2&" "&I2

I have some suggestions for you, but I don't know if any of them are what
you're really after since I'm not sure what your other worksheets contain or
accomplish.

One solution is to just apply an auto filter to the Master...then you may
find the other sheets are no longer needed.
Another solution is to use pivot tables on the other sheets to offer summary
reporting from various angles based on the data in the Master.
A third idea is to enter the data on the "other" respective page to begin
with and tell the Master to copy the data from all the other pages...much,
much easier than what you have asked for here.
Otherwise, you're going to need a macro, and macros that copy data in real
time are generally not a good idea. Most folks use built-in Excel tools to
summarize or reorganize the existing data from its raw state in order to
maintain the data's integrity.

If you need help tackling one of the above (like trying out option #3
above), let me know and I'll help. It would be good if you could expound on
what each field contains on each worksheet.

-KC
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Scott" wrote:

Hi, I have a workbook with 8 worksheets. The first is the "master". In A1 to
J1 I have names (each are different) and G-I have two rows that have names. I
haven't figured out how to make 2 column cells combine to make one yet. A few
of the rows have drop downs so i can select different inputs to the column. I
want to find out how to make a formula so when i add new info, it adds it to
the other appropriate worksheet. That way I dont have to cut and paste. Any
ideas on how this can be done? I'd appreciate any help. Thanks, Scott

Haven't heard from you. You might try sending to kcrippsteinATnetscapeDOTnet.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Scott" wrote:

KC, could I send you the file and then you can make a recommendation on how I
might accomplish what I'm trying to do?

Scott

"KC Rippstein" wrote:

To combine the first name in G2 and last name in H2, put this in I2:
=G2&" "&I2

I have some suggestions for you, but I don't know if any of them are what
you're really after since I'm not sure what your other worksheets contain or
accomplish.

One solution is to just apply an auto filter to the Master...then you may
find the other sheets are no longer needed.
Another solution is to use pivot tables on the other sheets to offer summary
reporting from various angles based on the data in the Master.
A third idea is to enter the data on the "other" respective page to begin
with and tell the Master to copy the data from all the other pages...much,
much easier than what you have asked for here.
Otherwise, you're going to need a macro, and macros that copy data in real
time are generally not a good idea. Most folks use built-in Excel tools to
summarize or reorganize the existing data from its raw state in order to
maintain the data's integrity.

If you need help tackling one of the above (like trying out option #3
above), let me know and I'll help. It would be good if you could expound on
what each field contains on each worksheet.

-KC
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Scott" wrote:

Hi, I have a workbook with 8 worksheets. The first is the "master". In A1 to
J1 I have names (each are different) and G-I have two rows that have names. I
haven't figured out how to make 2 column cells combine to make one yet. A few
of the rows have drop downs so i can select different inputs to the column. I
want to find out how to make a formula so when i add new info, it adds it to
the other appropriate worksheet. That way I dont have to cut and paste. Any
ideas on how this can be done? I'd appreciate any help. Thanks, Scott