Wanting to be able to sort will make this a LOT harder than just having
static cells writing to each other.
As far as the macro bit goes, I'd be happy to send you a dummy workbook if
you like, though with your latest twist, I no longer think it will do what
you need.
If I might make a suggestion though, have you considered having all your
data on a single master sheet as described, and then using that as the
source for a Pivot table, which would allow you to possibly create
individual years on other sheets if thats what you want. That way you only
worry about updating in one place.
Also, depending on your data, it might also be possible to do this with
formulas, linking the individual sheets into the master sheet. Personally
though I'd be trying to make it work via a Pivot table if it could.
It sounds like your data is in a databse style format anyway, so if that is
the case then you have an ideal base for a Pivot table.
Regards
Ken......................
"ksks16" wrote in
message ...
OK. I'm really working hard on this. My problem is that I want
everything on sheets 2,3,4 etc. to be mirrored on sheet 1 and still be
able to edit in either place. I don't want the contents of sheets 2-4
to replace themselves.
In my project, I have sheets 2 - 4 with yearly data (sheet2=2005;
sheet3=2004; sheet4=2003; etc) and sheet1 is my master list where I
would like to show ALL of the years combined. If I see an error on
sheet4 I want to be able to update it and the change transfer to
sheet1; or if an error is on sheet1 - update it and the change transfer
to the appropriate sheet.
Sheet1 needs to be able to be sorted in different ways without losing
the information and also needs to have the capability of adding a 5th
or 6th sheet.
Complicated, I know. If there is ANY way to do this, a suggestion
would be great. Otherwise I can just keep updating the individual
sheets to their respective link on Sheet1.
ksks16
--
ksks16
------------------------------------------------------------------------
ksks16's Profile:
http://www.excelforum.com/member.php...o&userid=30841
View this thread: http://www.excelforum.com/showthread...hreadid=505045