Hello,
I would like to use VBA code to create a multiple filter criteria in column "B" in "Sheet1", based on cell values, only from cells in unhidden rows, from column "A" in "Sheet2".
Cell values in column "B" in Sheet1
QTO-B1C0524
QTO-B1C0424
QTO-B1C0224
QCO-U200264
JDO-U019300
CDO-C007768
Cell values from unhidden rows in column "A" in "Sheet2".
QTO-B1C0224
JDO-U019300
By running the VBA code, column B in "Sheet1" shall look like
QTO-B1C0224
JDO-U019300
I am very greatful for any help in this matter.
Kind regards
Ingemar
I would like to use VBA code to create a multiple filter criteria in column "B" in "Sheet1", based on cell values, only from cells in unhidden rows, from column "A" in "Sheet2".
Cell values in column "B" in Sheet1
QTO-B1C0524
QTO-B1C0424
QTO-B1C0224
QCO-U200264
JDO-U019300
CDO-C007768
Cell values from unhidden rows in column "A" in "Sheet2".
QTO-B1C0224
JDO-U019300
By running the VBA code, column B in "Sheet1" shall look like
QTO-B1C0224
JDO-U019300
I am very greatful for any help in this matter.
Kind regards
Ingemar