Hi All,
I hope someone will be able to help with this.
TAB1, called Travel Log, contains Date, Trip #, Section #, and Passenger #.
I want to take the Passenger # total and sequentially number rows in TAB2, called Passenger Names, while also pulling the Date, Trip #, and Section #.
Each trip has sections, each section has different passengers. I need to track the passenger names for each section.
I would like it to operation as follows:
When a passenger # is entered in TAB1 row 1; the Date, Trip #, Section #, and Passenger #, is entered in TAB2. If there are 10 passengers, there will be 10 rows entered.
When a passenger # is entered in TAB1 row 2; the Date, Trip #, Section #, and Passenger #, is entered in TAB2. If there are 3 passengers, there will be 3 rows entered starting on row 11.
I have included an example in TAB2 of my attachment of what the the finished product should look like as based on the data entered in TAB1.
Thank you all so much for your help!!
Bookmarks