Search a range of column in sheet and paste data

Rajendra - Feb 14, 2018 at 09:30 AM

I have a sheet which has different currencies like usd, eur, gbp (can be any currency) and sheet 2 has data related to each currency. I need to find the currency from sheet one in sheet 2 and copy the entire row of currency and paste it under the correct currency in sheet two

For ex
Sheet 1

Date symbol currency

Sheet 2

Date ex date currency

Usd some details

Date ex date currency

Gbp some details

I want the macro to find each of these currencies from sheet 1 in sheet 2 and paste data exactly under each currency

See more