Have a table with formulas in couple of columns that this user form is removing.

[SKEEEETER]

Hi guys, I have created a booking system for a friend's holiday home, it all works as it should. But it only allows to add bookings to the table tblBookings.

If any amendments or it needs to be removed it had to be done manually.

I then did a search and found post on here https://www.excelforum.com/excel-pro...ml#post5370273

This does exactly what I need I am slowly adjust the code, so it all works before I make look better.

I have 2 issues that trying fix, In the 1st column idNO it generates id number form the code =Row()-2 which automatically numbers this column as rows are added. Also in column 4 it also has a formula
=INT([@[End Date]])-INT([@[Start Date]]).

When you either press add or amend buttons, it replaces what is in idNO and Days columns, removing the formula


[ATTACH]816151[/ATTACH

[BadlySpelledBuoy]

In your Add and Update subs, change this part:

Please Login or Register  to view this content.

To this:

Please Login or Register  to view this content.

BSB

[SKEEEETER]

That has done it thanks so much.

[BadlySpelledBuoy]

No problem. Happy to help

BSB

[SKEEEETER]

Is there a way when hit hit the Add button it does not prompt to IDno in as this generated by table.

Please Login or Register  to view this content.

I have tried to modify but little unsure which bits need to stay and which bits to go.

[BadlySpelledBuoy]

Get rid of this bit:

Please Login or Register  to view this content.

BSB