ForLoop VBA for multiple range

Give your picture before and after that

Originally Posted by chee321

Hi,

I am having some issues with coming up with a VBA code that runs to lookup one column for "text" and If "text", copy ActiveCellOffset(0,1) to another sheet.
Whenever a "text" is detected and copy, the next sheet output cell has to insert another row.

'Lookup Column 2 for "Fail" and copy next column cell to output into next sheet

A Pass Explanation1 -Skip row
B Pass Explanation2 -Skip row
C Fail Explanation3 -Copy explanation3 and output other sheet
D Fail Explanation4 -Copy explanation4 and output other sheet below explanation3

Help is very appreciated T-T
-CH

Perhab like this only idea not test

Please Login or Register  to view this content.

Or like this only idea not test

Please Login or Register  to view this content.