Excel question, write update to 2 sheetss

[Edbrugman]

Can someone help me.
What I would like,
If I make a booking with the Booking to Date macro, the line is also copied to the Admin sheet.
I would like the same thing when I use Save/Update, now only the line in Data is updated and not in the Admin sheet.

 

[BobBridges]

1) I don't see any "Booking to Date" procedure here. There's Update_Booking, data_Booking and Booking_Update. Did you mean one of those?

2) I don't see any procedure named anything like "Save/Update"; I'm guessing you mean you want something to happen automatically when you save the workbook, and/or when you change a worksheet?

I think we need better information here, that is, more details.

 

[Edbrugman]

I use the DataBooking macro for Booking to Date. This macro writes to 2 sheets Data and Admin.
I use the Booking Update macro to update a booking but the Data sheet. What I would like is that if I update a booking on the data sheet, I also update the Admin sheet.

 

[Belleke]

Cross post on a Dutch site with a solution made by a good friend of mine.
https://www.piepcomp.nl/threads/exel-regel-terug-plaatsen-na-update.12370/#post-118073

 

[vletm]

Edbrugman​

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

 

[BobBridges]

So, Ed, do you have a solution or shall I keep reading?

 

[Edbrugman]

Apologies wanted an answer too quickly will not happen again

 

[Edbrugman]

No Bob, I don't have a solution for this question yet

 

[Marc L]

Hi Belleke : can you confirm there is no solution on the Dutch site ?​

​

 

[Belleke]

They are working on it, there should be a solution in a few days.

 

[Marc L]

Thanks, will take a look later …​

​

 

[Edbrugman]

Dear Excel people.
With a bit of continued trying and a little help from ChatGPT, I managed to change this formula.
Also cancel the formula for the Booking tr