Macro to search for text and then post data on the last row below the last Row RRS feed

  • Question

  • Hi All

    I have a Purchase order on excel that has a Macro that emails and then increments the purchase order number , but i am wanting to go a bit further and pull that data before i update it into a Inventory data Base. Please can somebody help me on this

    The macro will need to do the following:

    search Worksheet 2 ( for example row 4) for the appropriate product code that matches the product code indicated on Worksheet 1 "purchase order" (example in column A). it will then need to copy the data on Worksheet 1 and paste it to the last row on Worksheet 2 below the appropriate column that has the matching product code. Is there will be several product Codes per purchase order it will have to be able to search through them all and paste to the appropriate column on worksheet 2.

    One last thing i will need to copy the date from worksheet 1 to worksheet 2 and paste it to Column a last row so that it lines up with the new transferred data  

    I hope this is possible as it will really help me out a lot.

    Many thanks in advance

    Jason Edwards


    Monday, December 8, 2014 10:42 AM


All replies