Update worksheet from Master workbook

[txheart]

Hey y'all,

I could've sworn I'd already posted this question here, but when I cam
in this morning and typed my handle into search to see if anyone ha
answered yesterday's help post, I can't find the question. Strange
Anyway, here goes...

I work for an insurance company; there are 7 employees, each wit
access to the network server in addition to their own 'c' drive. W
have multiple data sheets, one for clients information, one for agent
information, insurance companies information, etc. that are all store
on the network.

Those files get updated anytime something needs to be changed. Thi
might not be everyday, just whenever needed. The first person to ope
the file gets "edit" mode, the rest will only have read-only access.
rarely have to edit, so if I'm the first one in then, invariably, I'l
be asked to exit so someone else can get in and edit.

I've decided that I want my own separate access. I've made a workboo
with 10 different worksheets, each tab named after a database that's o
the network. Every morning I go into the worksheet, erase everything
re-import external data. The problem is, I lose all of my formattin
that I may have done.

Is there any way to have any -*changes *-that are made to the networ
file show up in my file? I'd like my file to update any changes
additions, deletions that are made to the master files, but keep th
formatting that I've done on my file. And, I'd like this don
automatically.

Can anyone help? I've been tackling this question all week, but haven'
gotten to an answer yet. I probably thought I'd already posted her
because I've asked for help here before, and received it. *sigh*..
anyone

 

[Don]

one way is to record the format changes to a macro and execute that once the
data is loaded (if you can not do "past / special / values" ) Click
tools/macro/record macro (you can assign a short cut like cntl+t) and it will
record all the formating you do until you stop the record.

You can also have your formating sheet that you hit the paint brush and
paint to the area? Try this first