Forum Discussion
Copying row to another sheet based on cell value
Hi, I'm trying to copy a row from a sheet named ALL to a sheet named ENG if the value ENG appears in column F. Can anyone see why the below macro module isn't working? Thanks.
Your code looks at column X, not at column F. Change both occurrences of "X" to "F".