Manipulating data in Multible worksheets

[Jason Cottrell]

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

 

[Fred Smith]

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]

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