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
Hi,
I am not sure what you mean as all the values come from the same heading does it not?
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.
Woops. Didnt attach.
The code gets the value only from the total invoice column, not the other columns you specify in the picture.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks