+ Reply to Thread
Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20

Thread: Tracking income and invoices for projects - multiple search results

  1. #16
    Registered User
    Join Date
    01-11-2011
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Tracking income and invoices for projects - multiple search results

    Dave,
    Is it easy to add another column to the search results? I want to add which heading the $ amount comes under. So, for example, if you look at July all of the $ amounts come under HF. Could another column be added to show which heading the amounts comes under?

    Sorry, I am not that familiar using VB.

    Thank you

  2. #17
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Cochrane,Alberta
    MS-Off Ver
    XL 2003,2007,2010
    Posts
    6,843

    Re: Tracking income and invoices for projects - multiple search results

    Hi,
    I am not sure what you mean as all the values come from the same heading does it not?

  3. #18
    Registered User
    Join Date
    01-11-2011
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Tracking income and invoices for projects - multiple search results

    All the amounts can be taken from the 'Total Invoice Cost' heading, but they are entered below the initials of the supplier (E.g. DM, HF, etc) I have attached an image of what I mean.

    For example, for the amount of $60.87, i would need the extra results column to display 'GN'. then if the results were showing the amount of $5.39, I would need it to display 'HF'.

    Does this explain it a little better? Sorry if I did not make it clear.

    Thanks again.

  4. #19
    Registered User
    Join Date
    01-11-2011
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Tracking income and invoices for projects - multiple search results

    Woops. Didnt attach.
    Attached Images Attached Images

  5. #20
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Cochrane,Alberta
    MS-Off Ver
    XL 2003,2007,2010
    Posts
    6,843

    Re: Tracking income and invoices for projects - multiple search results

    The code gets the value only from the total invoice column, not the other columns you specify in the picture.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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.2.0