+ Reply to Thread
Results 1 to 2 of 2

Copy, Paste, Delete from sheet 1 to sheet 2 - VBA

  1. #1
    Registered User
    Join Date
    07-15-2010
    Location
    Coventry, UK
    MS-Off Ver
    Excel 2003
    Posts
    6

    Copy, Paste, Delete from sheet 1 to sheet 2 - VBA

    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.

    Please Login or Register  to view this content.

    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.

    Please Login or Register  to view this content.
    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
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-15-2010
    Location
    Coventry, UK
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Copy, Paste, Delete from sheet 1 to sheet 2 - VBA

    can anyone suggest what sort of functions i need to be looking at to find TEXT within a specified column?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1