+ Reply to Thread
Results 1 to 4 of 4

Copy Data from one Sheet to another based on multiple criteria

  1. #1
    Registered User
    Join Date
    01-22-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    4

    Copy Data from one Sheet to another based on multiple criteria

    Please see attached file,

    In B10 i have a drop down menu to select a customer and then their old discounts are pulled from the customers sheet.
    What i need to do is add the new discounts in column F, and the macro upon running must replace the existing values in the customers sheet.

    Been at this for days with no luck.

    Thanks
    ParisG
    Attached Files Attached Files
    Last edited by ParisG; 01-23-2014 at 02:58 AM.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    19,680

    Re: Need Help with a challenging Macro/VBA

    Welcome to the Forum ParisG!

    OP complied with request to update title
    Last edited by 6StringJazzer; 01-22-2014 at 09:36 PM.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    12-07-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    31

    Re: Copy Data from one Sheet to another based on multiple criteria

    Hi

    Try the attached, I`ve used the range method "find" to locate the item code column and customer row this will generate an error if the search item can`t be found I`ve handled this for the item code simply by bringing up a message box with the item code that couldn`t be found and allowing the process to continue. I`ve not done the same for the customer name since the name comes from customer tab and theoretically will always be found. I also made your named range "Customers" dynamic so it will grow as you add customers.

    Regards
    Ian
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    01-22-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Copy Data from one Sheet to another based on multiple criteria

    Hi Ian,

    This is absolutely brilliant, thank you so much for your assistance.

    Regards
    Paris

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Challenging macro: Cost/frequency/spread
    By JamesGoulding85 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-31-2013, 11:25 AM
  2. Macro to Segregate the data based on Multiple Criteria's in Multiple Columns -Challenging!
    By Novice_To_Excel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-08-2012, 07:31 AM
  3. Challenging question about if function with macro
    By keis386 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2011, 06:44 AM
  4. Challenging?
    By ChrisMattock in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-07-2006, 11:20 AM
  5. Challenging Macro to perform evaluate function on each cell
    By qwertyjuan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-20-2005, 03:35 PM

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