vendor

I have two lists. One is my source data. The second is the truncated version that I want the first list replaced with. I need a solution that will make this efficient and preferably automated as I don't want to have to follow a lengthy process every time I update the source data (typically...

I have searched all over the internet for a solution to this but have so far been unsuccessful. Lots of folks with similar issues out there but not exactly the issue I am having. I am trying to import a custom list that contains 54 entries. I have the list typed into excel with each list...

I have a huge excel spreadsheet that I have inherited through an acquisition. 32,000 rows with 10 columns. I would like to count some dollar amounts in column "K" based on a vendor name in column "F and a division name listed in column "E". For example if I wanted to know how much money, from...

Hi all - first post! Not sure how to word what I want but here goes. I have an excel spreadsheet that on one sheet records details of invoices and on another records authorisations to pay invoices. I want a cell to automatically search the Authorisation sheet for a row and ideally a...

Hello All, I need your assistance. See the tables below. So, I need to extract a unique list of vendor codes from the "DATA" below based on their area codes. Then, I need to sum the values under "Presence" corresponding to the vendor codes. The cell (B1) next to "Area Code" below is where I...