jelmer123456
New Member
- Joined
- Mar 3, 2021
- Messages
- 16
- Office Version
- 365
- Platform
- Windows
Hi, im trying to find a solution to my problem
I'm trying to copy the data from picture 1 to picture 2 , but only when the value on row 1 matches.
For my work I have to copy paste alot of data. With the particular file im doing right now picture 1 would have data from $A till $DC with ~2300 rows.
$A till $DC and row 1 will always be the same and the amount of rows change per export file.
Picture 2 goes from $A till $AO and all the values on row 1 from match a value from picture 1.
Copying every row by hand makes me go insane as they are in a different order.
I've spend the last 2 hours trying to find a solution but im stuck and looking for help. I checked all the "has this question already been asked" posts that got suggested but that didn't really help.
Any suggestions?
I'm trying to copy the data from picture 1 to picture 2 , but only when the value on row 1 matches.
For my work I have to copy paste alot of data. With the particular file im doing right now picture 1 would have data from $A till $DC with ~2300 rows.
$A till $DC and row 1 will always be the same and the amount of rows change per export file.
Picture 2 goes from $A till $AO and all the values on row 1 from match a value from picture 1.
Copying every row by hand makes me go insane as they are in a different order.
I've spend the last 2 hours trying to find a solution but im stuck and looking for help. I checked all the "has this question already been asked" posts that got suggested but that didn't really help.
Any suggestions?