Hello,
I have two sheets named as "Atmos" and "Surface" in a single Excel file . What I'd like to do is to copy the data in "Surface Condition" and "Surface Temperature" columns in "Surface" sheet and paste them into the columns in "Atmos" only when their "Station_Name" AND "Observation Time" match, and write "N/A" when there is no matching record. The actual dataset contains nearly 0.5 million rows to match and copy from.. I've tried Index & Match and it worked for a fairly small file but was taking way too long for my actual dataset. Please help me to write an efficient VBA script for this...... Thanks!
View attachment Sample.xlsx
I have two sheets named as "Atmos" and "Surface" in a single Excel file . What I'd like to do is to copy the data in "Surface Condition" and "Surface Temperature" columns in "Surface" sheet and paste them into the columns in "Atmos" only when their "Station_Name" AND "Observation Time" match, and write "N/A" when there is no matching record. The actual dataset contains nearly 0.5 million rows to match and copy from.. I've tried Index & Match and it worked for a fairly small file but was taking way too long for my actual dataset. Please help me to write an efficient VBA script for this...... Thanks!
View attachment Sample.xlsx