COMBINE NAMES WITH AMOUNTS

Copper Contributor

Jun 04, 2020

Dustin-Doucette
Thanks for your reply!

I have added 2 print-screens, hope this makes things a little more clear.

I have tried multiple options but without any success.

information from page 2 needs to be transferred to page 1. This should be done when i mention a certain name, or name in combination with a nr.

page 1.

ONE	TWO	THREE	FOUR	FIVE	SIX	SEVEN	TICKET		TICKET EXTRA		FEE	FEE EXTRA	CONTROLE	EXTRA	VALIDITY
A	1500						10	<--This information needs to be mentioned as soon as I use the letter A in column A	30	<--This information needs to be mentioned as soon as I use the letter A in column A				nr.1	30-6-2020	<--This information needs to be mentioned as soon as I use the letter A + nr.1(column A+O)
B	2000						20	<--This information needs to be mentioned as soon as I use the letter A in column A	40	<--This information needs to be mentioned as soon as I use the letter A in column A				nr.2	31-5-2020
C	1600						30	" ''	50					nr.3	30-7-2020	" "
D	1800						40	" ''	60					nr.4	30-6-2020	" "
E	2000						50	" ''	70
F	1900						60	" ''	80
G	2500						70	" ''	90

Page 2.

I could send you a copy of the excel file as well, just let me know if you need this.

Thanks again for your help!

Forum Discussion