Hi Experts,
I'm currently using excel VBA to copy DATA from one WORKBOOK to another if 2 criteria's are met =
Both workbooks are saved in one folder.
Workbook 1 name - ExcelMints.xlsx
Workbook 2 name - ExcelChoco.xlsx.
I've been trying to get it to work for a while but no luck. What i'm trying to achieve is :
Criteria 1 : If B:B in Sheet ExcelChoco is present within the range of B:B AND
Criteria 2 : If E5:E10000 contains a value then copy cell value in "E" to cell E in ExcelMint.xlsx
Criteria 3 : If Cell B="DARK-01" or "Power-01" leave blank/ignore
Can someone please advise/help me with the following ?.
Help would highly be appreciated.
Bookmarks