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