Table1:Main Table
Product # colour stage time
111 red s1 00:00:00
222 white s2 01:00:00
333 blue s1 02:00:00
444 red s3 03:00:00
555 red s4 04:00:00
the above table updated automatically from another sheet , each product goes trough stages the start sage S1 and the end stage S4 ,what i want , for example take product number 111 , the stage S1 become S2 I want the tracking information to be in another table as below
Table2:
111 red s1 00:00:00
111 red s2 00:30:00
222 white s2 01:00:00
333 blue s1 02:00:00
444 red s3 03:00:00
555 red s4 04:00:00
another example, if product 444 changes from s3 to s4 the the updated table (table2) will be as below :
Table2:
111 red s1 00:00:00
111 red s2 00:30:00
222 white s2 01:00:00
333 blue s1 02:00:00
444 red s3 03:00:00
444 red s4 03:30:00
555 red s4 04:00:00
could this be done by formula or VB code please help - highly appreciated.
Product # colour stage time
111 red s1 00:00:00
222 white s2 01:00:00
333 blue s1 02:00:00
444 red s3 03:00:00
555 red s4 04:00:00
the above table updated automatically from another sheet , each product goes trough stages the start sage S1 and the end stage S4 ,what i want , for example take product number 111 , the stage S1 become S2 I want the tracking information to be in another table as below
Table2:
111 red s1 00:00:00
111 red s2 00:30:00
222 white s2 01:00:00
333 blue s1 02:00:00
444 red s3 03:00:00
555 red s4 04:00:00
another example, if product 444 changes from s3 to s4 the the updated table (table2) will be as below :
Table2:
111 red s1 00:00:00
111 red s2 00:30:00
222 white s2 01:00:00
333 blue s1 02:00:00
444 red s3 03:00:00
444 red s4 03:30:00
555 red s4 04:00:00
could this be done by formula or VB code please help - highly appreciated.