How do I link each cell to each worksheet to change as I enter dat

  • Thread starter Thread starter KFarms
  • Start date Start date
K

KFarms

I need to enter data in different forms - thus several sheets with the same
information but sorted differently on each sheet. Is there a way to link
each sheet so that if I make changes to one row on one sheet (or the main
sheet), it will change it on all the other sheets in the same row?
Ex. - cow number 23 needs a due date, calving date, etc. - main sheet is
sorted by cow number to look up faster but if I change cow 23's due date on
the main sheet, I want it to change it on the "sort by due date" sheet as
well.
 
From the sheet tabs select all sheets or the required sheets ..

Changes made in one will be reflected in all//
 
From the sheet tabs select all sheets or the required sheets ..

Changes made in one will be reflected in all//
 
Ok - I see what you are saying but......it changes just that cell in each
sheet - I need it to hold the number listed in column A to match each sheet.
Ex. - cow #32 may be listed in a different on a different sheet - ie, due
date vs. calving date vs. how much milk she made - each sheet will put her in
a different line but EACH sheet in column A is the cow's number. Can you
follow me? Or am I getting to complicated? Is it safe to post my phone # if
that is easier? I can't thank you enough for your assistance - if this can
work, it will make my life so much easier.
Thanks,
Heather
 
Ok - I see what you are saying but......it changes just that cell in each
sheet - I need it to hold the number listed in column A to match each sheet.
Ex. - cow #32 may be listed in a different on a different sheet - ie, due
date vs. calving date vs. how much milk she made - each sheet will put her in
a different line but EACH sheet in column A is the cow's number. Can you
follow me? Or am I getting to complicated? Is it safe to post my phone # if
that is easier? I can't thank you enough for your assistance - if this can
work, it will make my life so much easier.
Thanks,
Heather
 
Hi Heather

From many years experience of dealing with all forms of livestock records, I
can assure you that you would be much better served by keeping the data on a
single sheet, not multiple sheets.
Then sort the data according to the view that you want, and filter to show
only the animals that are relevant.
COW ID order, Service Date Order, Calving Date Order, Drying off Date Order,
PD Order etc.

You can hide any of the columns that are not relevant to that particular
Report.
These can be saved as separate Views, which can then be called up at will,
or some simple macros attached to buttons on your main sheet will give you
the view that you want.

If you want to send me direct a copy of your data, I will show you an
example of what I mean.
To mail direct, send to
roger at technology4u dot co dot uk
Change the at and dots to make valid email address
 
Hi Heather

From many years experience of dealing with all forms of livestock records, I
can assure you that you would be much better served by keeping the data on a
single sheet, not multiple sheets.
Then sort the data according to the view that you want, and filter to show
only the animals that are relevant.
COW ID order, Service Date Order, Calving Date Order, Drying off Date Order,
PD Order etc.

You can hide any of the columns that are not relevant to that particular
Report.
These can be saved as separate Views, which can then be called up at will,
or some simple macros attached to buttons on your main sheet will give you
the view that you want.

If you want to send me direct a copy of your data, I will show you an
example of what I mean.
To mail direct, send to
roger at technology4u dot co dot uk
Change the at and dots to make valid email address
 
Back
Top