Good evening ,

I scrape info from a website daily, and each day i need to run filters and do several adjustments. I was wondering if someone can assist to make a macro that I run each day? It would be greatly appreciated.

First marcro would be to clear contents of any cells in Column "G" that contain the word "From" Then move numbers (prices) from Column "I" to Column "G" i.e. I2 to G2, I3 to G3 etc.

Next macro is to search column "J" for the words "instock" or "Out of stock" and move those to Column "L" in the corresponding row replacing the "null" word there.
OR


If Column "L" contains the word "null replace it with the contents of column "J"

Thank you