Manipulating data in Multible worksheets
 

Hi,
I am currently setting up a workbook with about 10 sheets. Ech sheet has
some common employee data. I have linked all of the sheets to one master
sheet which holds personal information. I will in the future want to sort
delete add records and such. The problem I am having is this:
the 4 common columns can be sorted rearranged etc. but when I do so the
related data for each row on the other work sheets is not effected. I then
have to manually move the data on each respective sheet to match the new
order.
Shouold I be using a relational data base, or is there some way to lock the
data in a row for each separate sheet?
I hope someone can help me with this. I currently don't have access to
Access at the office.
Thanks
--
Jason

Manipulating data in Multible worksheets
 

Although we don't know exactly how your data is laid out, and how you want
to manipulate it, the likely best advice is:

1. Put all your data in one spreadsheet. Use as many columns as you need.
2. Use Pivot Tables to summarize your data on various sheets.

Regards,
Fred.

"Jason Cottrell" wrote in message
...
Hi,
I am currently setting up a workbook with about 10 sheets. Ech sheet has
some common employee data. I have linked all of the sheets to one master
sheet which holds personal information. I will in the future want to sort
delete add records and such. The problem I am having is this:
the 4 common columns can be sorted rearranged etc. but when I do so the
related data for each row on the other work sheets is not effected. I then
have to manually move the data on each respective sheet to match the new
order.
Shouold I be using a relational data base, or is there some way to lock
the
data in a row for each separate sheet?
I hope someone can help me with this. I currently don't have access to
Access at the office.
Thanks
--
Jason

Manipulating data in Multible worksheets
 

Dear Fred,
Thanks for the advice I will try that and see how I get along.
Much appreciated.
--
Jason


"Fred Smith" wrote:

Although we don't know exactly how your data is laid out, and how you want
to manipulate it, the likely best advice is:

1. Put all your data in one spreadsheet. Use as many columns as you need.
2. Use Pivot Tables to summarize your data on various sheets.

Regards,
Fred.

"Jason Cottrell" wrote in message
...
Hi,
I am currently setting up a workbook with about 10 sheets. Ech sheet has
some common employee data. I have linked all of the sheets to one master
sheet which holds personal information. I will in the future want to sort
delete add records and such. The problem I am having is this:
the 4 common columns can be sorted rearranged etc. but when I do so the
related data for each row on the other work sheets is not effected. I then
have to manually move the data on each respective sheet to match the new
order.
Shouold I be using a relational data base, or is there some way to lock
the
data in a row for each separate sheet?
I hope someone can help me with this. I currently don't have access to
Access at the office.
Thanks
--
Jason