Hello guys,
I have 2 sheets, one contains Accounts (“ACC”), and the other is for loading(“LOAD”)
I am looking for a code which would look :
if the value contained in the range A of sheet(“ACC”) is in one of the cells of range A of (“LOAD”) Then
Copy the range(B to M) from sheet(“ACC”) and paste it in range (B to M) in LOAD sheet
e.g.:
Capturesss.PNG
This is the code I have, but ACC sheet can contain 200 accounts and I don't want to repeat "Or" 100 timesPlease Login or Register to view this content.
Anyone can help?
Thank you very much,
Jeremy
Bookmarks