I have a spreadsheet that details monthly state of sales leads. One of the cells called "status" can contain info such as Opportunity / Offer / Order / Registered Lead etc. When a cell says "offer" I want to then copy other information which will appear in this same row into a spreadsheet in another tab. Is this possible??
Please note, there will be multiple cells containaing the status "order".
Please let me know how to do this, I have been struggling for time now and this is getting really urgent...!!
ANY help much appreciated.
Bookmarks