Use Check Box Value to Auto Fill Table

[madkinson]

We have an idea that should reduce keying errors when a user enters a bill of lading in our ticketing system. I've developed a simple Excel sheet with a list of all available rail cars. The can use a "Select All" button to select all cars then uncheck the ones that aren't being used for this particular train (each train has about 125 cars).

What I can't figure out is how to write code that would automate the process where the user would click an "Add Cars" button and the code would take each line where the box is checked and do a VLOOKUP to fill in the rail car number selected as well as the rest of the values for that car as shown in the second attachment.

Maybe a VLOOKUP isn't the best solution? Any help is greatly appreciated. Thanks.

 

[madkinson]

Let me make another try at this.

I have a list of Railcars that users will choose selected ones when building a train. There are about 130 cars in each train so typing them in manually has produced many user errors. I was thinking I could write code that would look at each checked car number, do an INDEX/MATCH on a second sheet, and write that number plus weight, date, etc from the second sheet to a blank sheet. I am really struggling with this so I would really appreciate any help provided.

The first sheet is the one where the user would check the box next to each car # to be built into the train. It's actually easier to check them all then have them deselect the cars they don't need.

Dolese Rail Cars- Tare Weight- Gross Weight_Macro_Version_MrExcel.xlsm
	A	B	C	D
1	Equipment Id	Col
2	OFOX88006			TRUE
3	OFOX88011			TRUE
4	OFOX88128
5	OFOX88161			TRUE
6	OFOX88169			TRUE
7	OFOX88177
8	OFOX88186			TRUE
9	OFOX88189			TRUE
10	OFOX88197
11	OFOX88231			TRUE
Railcars

The second sheet is the one used for the lookup. There are 2 blank columns that will be filled in on the 3rd sheet with a sequential number.

Dolese Rail Cars- Tare Weight- Gross Weight_Macro_Version_MrExcel.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	Location	Date	Train #	Ref #	Track	Vehicle ID	Gross	Net	Qty	Load Status	In/Out Status
2	151	1/9/2023	1			OFOX88006	268000	216000	108	L	I
3	151	1/9/2023	1			OFOX88011	268000	216000	108	L	I
4	151	1/9/2023	1			OFOX88128	268000	216000	108	L	I
5	151	1/9/2023	1			OFOX88161	268000	216000	108	L	I
6	151	1/9/2023	1			OFOX88169	268000	216000	108	L	I
7	151	1/9/2023	1			OFOX88177	268000	216000	108	L	I
8	151	1/9/2023	1			OFOX88186	268000	216000	108	L	I
9	151	1/9/2023	1			OFOX88189	268000	216000	108	L	I
10	151	1/9/2023	1			OFOX88197	268000	216000	108	L	I
11	151	1/9/2023	1			OFOX88231	268000	216000	108	L	I
CarData

The third sheet is what I hope to end up with.

Dolese Rail Cars- Tare Weight- Gross Weight_Macro_Version_MrExcel.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	Location	Date	Train #	Ref #	Track	Vehicle ID	Gross	Net	Qty	Load Status	In/Out Status
2	151	1/9/2023	1	1	1	OFOX88006	268000	216000	108	L	I
3	151	1/9/2023	1	2	2	OFOX88011	268000	216000	108	L	I
4	151	1/9/2023	1	3	3	OFOX88161	268000	216000	108	L	I
5	151	1/9/2023	1	4	4	OFOX88169	268000	216000	108	L	I
6	151	1/9/2023	1	5	5	OFOX88186	268000	216000	108	L	I
7	151	1/9/2023	1	6	6	OFOX88189	268000	216000	108	L	I
8	151	1/9/2023	1	7	7	OFOX88231	268000	216000	108	L	I
Sheet1