Manipulating data in Multible worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jason Cottrell - 29 Mar 2008 10:59 GMT

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

Signature

Jason

Reply to this Message

Fred Smith - 29 Mar 2008 23:52 GMT

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.

> Hi,
> I am currently setting up a workbook with about 10 sheets. Ech sheet has
[quoted text clipped - 11 lines]
> Access at the office.
> Thanks

Reply to this Message

Jason Cottrell - 30 Mar 2008 05:32 GMT

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

Signature

Jason

> Although we don't know exactly how your data is laid out, and how you want
> to manipulate it, the likely best advice is:
[quoted text clipped - 20 lines]
> > Access at the office.
> > Thanks

Reply to this Message