i don't know anything about coding a macro to undo itself after
running (search the newsgroup, tho, because i know i've seen stuff on
this)...... but if you simply want the macro to unhide - copy - paste
- rehide by itself, you can code that into the macro. then you
wouldn't have to do it manually.
but it sounds like that isn't exactly what you want.
susan


On May 29, 3:11 pm, Kiba wrote:
I need a macro because the macro that runs also ensures a way to undo all of
the cahanges. So if anyone has an idea how to do this with macro I would
appreciate it. Thanks Anyway FSt1 I use to have it set that way but too
many errors ended up being saved.



"FSt1" wrote:
hi,
you can use a formula.
if you had data in sheet 1 cell A1 and you want this shown in sheet 2 cell
d5, then in D5 put the formula =sheet1!A1.
what ever is in sheet 1 cell A1 will also show in Sheet 2 cell D5.
NO macro needed.

Regards
FSt1

"Kiba" wrote:

Ok So I have a worksheet, currently it has a macro that copy and pastes data
from the master sheet to several other worksheets. Some of the sheets are
hidden and inorder to copy and paste to them when the update button is
pressed I have to un hide and re hide. Is there a way that I can link cells
so that they can update when button is pressed without unhiding?- Hide quoted text -

- Show quoted text -