LarsDyrby
asked on
Copy value to another sheet when condition is met
Can somebody help me with some VBA-code that loops through a range and copies the value in a cell to another sheet when condition is met.
Example:
Check if the value of cells A1:A10 = x, if yes copy the corresponding values from B1:B10 to another sheet
Best wishes
Lars
Example:
Check if the value of cells A1:A10 = x, if yes copy the corresponding values from B1:B10 to another sheet
Best wishes
Lars
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Used the advanced filter
Thx to Rob
Thx to Rob
Could you be more specific?
Open in new window
Regards