selective data sheet creation with using VBA

[Nodemoton]

Good evening / morning,

Trying to solve this for my boss:

there are 3 Columns in a sheet: Name / previousStock / newStock

I need to get a macro to create another sheet named "Stock Adjustment Report"
which will contain all 3 columns where "previousStock" value did not equal "newStock"

Would be so grateful for a hint on how to tackle this one.

Kind Regards,

[JBeaucaire]

You can do this with an autofilter. If you create a new 4th column with a formula that tests the two colums for a match.

D2: =B2=C2
...copied down.

Now turn on the autofilter and filter column D for FALSE, you're looking at your "report" without creating a second sheet.

[Nodemoton]

Thank you so much. It worked, I managed to automatically record a macro as I applied autofilter on self-created columns referenced from another sheet - and everything solved itself !

[JBeaucaire]

Good work.

If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.