I have a workbook where I have to fill in three cells in each sheet.
The yellow cells are the input fields.
I start in sheet 35944
If I go to the next sheet (38745) I want to have the choice, Fill in Text Yes or No, if text from the 3 cells in sheet 35944 must be filled in 38745 and so on for the next sheets.
If i make the choice Yes, the same text has to be fill in.
If i make the choice No, nothing has to be done.
The layout names are yet to be appointed numbers.
Thanks Jos
That would need the use of a worksheet event. Means VBA.
Would that be a problem for you?
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
Hi, Tsjallie.
Thanks, but that is no problem.
Ok, try this.
Uses the worksheet_activate and worksheet_deactivate events of each sheet.
Asking YesNo and copying happens in a sub.
Thanks, this will work for me.
Good to here that.
One tip yet:
this message box popping up each time will soon get pretty annoying.
May be a good thing to test if the text in the actived sheet is already the same as in the source sheet before popping up the messagebox.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks