VBA update table

[ruslan1986]

Hello dear Excel users.
I`m working around excel programm for the weighbridge (weighing of gross and tare trucks with some cargo).
Usually Process going like that:

Weighing Gross - Truck 1
Weighing Gross - Truck 2
Weighing Tare - Truck 1
Weighing Gross - Truck 3
Weighing Tare - Truck 2
Weighing Tare - Truck 3

What I need:
When I enter new Truck number in Sheet 1 with some additional data (Gross or Net weight) macros should add that truck to the new row of Sheet 2, or update some of the previous trucks in Sheet 2 which has no one of the weights (gross or tare) if Truck number from Sheet 1 is similar one to closest truck from the last row of Sheet 2.

Thanks in your advance.
From me some 20$ bonus to your bank account

[maniacb]

Try this code in the sheet module

Please Login or Register  to view this content.