Variables in VB Code

[Guest]

I'm trying to get a macro to check the contents of a field- then filter a
columb on another sheet based on that content e.g
On one sheet "x" appears- this being variable- then goes to another sheet,
to a defined columb and filters on "*x*"

Any ideas?

Thanks in advance.

 

[Tom Ogilvy]

turn on the macro recorder. Filter your data - use a custom criteria
contains.

Now turn off the recorder

Look at the recorded code. Change the criteria to get its value from the
appropriate cell and hard code in the sheet name.