+ Reply to Thread
Results 1 to 6 of 6

Pulling numbers and sum

  1. #1
    Registered User
    Join Date
    09-02-2008
    Location
    Richmond
    Posts
    71

    Pulling numbers and sum

    The codes I have all look for col A then B and the C to return the numbers.

    I need it to look for Home Delivery “k” then the number (next cell “l”) then “college route” M then the number “n” sum I and N together and return to cell c46

    This file is not in the same folder as the master list file its pulled by the file name in Text box 3, a command button is used for this



    Please Login or Register  to view this content.


    I also need one that just pulls data out of a cell on , and inputs in the cell on the master file
    Attached Files Attached Files

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    I'm not sure what you man by look for Home Delivery in K, will this occur more than once?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    09-02-2008
    Location
    Richmond
    Posts
    71

    update

    Home delivery would be in a cell I want the number to the right of that cell same with the others. But some of them need to be added to others for a total and some stand alone.

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    If there is only one row containing Home Delivery, is that cell fixed?

  5. #5
    Registered User
    Join Date
    09-02-2008
    Location
    Richmond
    Posts
    71

    answer

    attached is the file, this will be the same layout each time other then the amounts changing
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    09-02-2008
    Location
    Richmond
    Posts
    71

    Help

    Can anyone help me with this?

+ 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