Hello,
Hope somebody here can help me.
I have a price adjustment file that I get emailed every day. I have to filter and sort this into a basic report for managment.
It comes in raw data with these headers:
DATE STOCKCODE MAN DESC CUSTOMER COST LISTPRICE SELL PRICE DIP QTY TOTALDIP REASON SALESPERSON
and I have recorded a macro to sort the data by REASON and rename sheet2 to ESP.
there are approx 15 differnet reasons on a daily basis.
I need to filter out these reasons: ESPUPDATEFAIL and BLANK and transfer them onto sheet2 (ESP) whilst removing them from sheet1
Problem is the 'blank' reasons are actually blank (no data) and there is a different amount of 'blank' and 'ESP 'reasons each day (anything from 0 to 100)
Can anyone help me? Im guessing im going to need some sort of formula that searches for certain words/letters in the reason column?
once I have copied and deleted this data, I am ok, because I have the second part of the macro thats sorts by MANUFACTURER and formats all the data.
that is working fine.
I have attached two example workbooks.
the 1st one is the file after the first sort macro.
the 2nd one is the end result.
I simply need help identifying, copying & pasting data from sheet1 to sheet2 and then deleting the relevant rows fron sheet 1.
Thankyou in advance.
I eagerly await replies
Michael
Bookmarks