invoices

I have used Excel for many years, but am new to Access! I am creating a database on which to log invoices received and track progress with authorisation, disputes, etc. through to eventual payment. As each invoice could have multiple progress updates relating to it, and each progress update...

I have a macro to save a worksheet and protect it. It then also saves the new worksheet as a PDF. I want to save the PDF into a particular subfolder called "Invoices" The sub folder will always be in the main folder. I cant use a spefic path at the main folder needs to work on different...

Hi, I need help to summarize data as shown in picture. sum up duplicate invoices amount. Thanks [/URL][/IMG]

I have a list of Invoices with a Date and Email Addresses from a sales database. I have counted the number of invoices per email address...but now I need to mark each invoice as "First / Second/Third, Fourth, Fifth Order .. basically what sequence.... I am trying to calculate the number of...

I have over 900 individual invoices created by excel, all are stored in a directory d:\invoices and are named Inv10001.xlsx to inv100909.xlsx I have a new spreadsheet called Address Book with one sheet called Address list. I want a macro or a vba code to open each of the invoice files and copy...

Hello Everybody, I woud lile your help on some issues i'm facing when i try to populate a combobox from a specific range based on a certain condition. Below is a listbox i created that provides the summary of all the invoices registered (see image below as an example): When i select an i...

https://1drv.ms/x/s!AvjBsEPEq12ngT3R9p-e8rqgVZkN?e=k7e4yd I have two columns. First column =age of invoice Second column = $ I want to do SUMIFS for invoices > 365 days E6 works fine for invoices 'Not Due' E7 should pick up $0.00 but instead picks up everything Not sure why..

https://1drv.ms/x/s!AvjBsEPEq12ngTpjIV0Ri5AcMKZa?e=0sU8cn I have a table of data. First column = company names. Other columns = invoice amount aging by days E.g. column B = 1 - 010 means invoices overdue between 1 day and 10 days. I am summarizing the info in a PV. Suppose I want to create...

Hi all. I am trying to filter the number of say invoices pending and the formula bellow does this. =COUNTIF(E:E,"NO") However, the goal here is to show only the number of customers with outstanding unpaid invoices. These would be marked on say collumn E as NO. So, say column D has customers...

So we receive hundreds of invoices from our customers every day. The invoices are in pdf format but such that you can select the text and copy and paste etc Is there a way to convert multiple pdfs of invoices into data so that I can see it Excel or Word?

https://1drv.ms/x/s!AvjBsEPEq12ngR1M8FneK-3B1Ew7?e=1pqHkd Hey guys, Let me explain my setup. This workbook is what I use to manage invoices that we pay to other companies. Company (1) sends us invoices. We'll pay them. Each week, Company (1) will send us a statement with a list of...

Hi, I have this code in use which when in my database & i press its button the corresponding invoice is then shown. At the time the invoice were saved like this, 1.pdf 2.pdf 3.pdf Private Sub OpenInvoice_Click() Const FILE_PATH As String = "C:\Users\Ian\Desktop\REMOTES ETC\DR COPY...

Hey guys, I need a help. I have a excel file with lots of macros VBA codes to make invoices. There are around 5-6 pages in the excel file. Is there any way to make this excel file go online ? I mean that can i upload it in a server/cloud where multiple people can access it at the same time and...

Hi, I've been trying to write a macro for this but can't figure out the proper way to go about accomplishing this correctly. I have one workbook open (Important to note that the name of this workbook can vary) with a table called "Invoices". Lets call this workbook WorkBook A. I have another...

Hope someone can tell me what I am doing wrong. I have copied and pasted from this web page: https://www.mrexcel.com/news/next-invoice-number/ and have corrected all the cell numbers to do with my saving details, and the macro is perfect. BUT, when I then go in to the invoices again, to...

Hi there, I have two lists on one spreadsheet with the invoice number being common to both lists. The list on the left is from a supplier and the one on the right is my list. The list is about 2,000 lines and what the supplier wants to find out is if I have received their invoice and is it paid...

Hi, I was wondering if anybody will be able to help me. I am fairly new to VBA. I have created a macro that will pull the data from file based on multiple criteria, group them together, assign invoice number and separate the invoices with blank rows. It will look something like this (with a...

Hi, The working code supplied below is what i use to view a saved invoice. What i am looking for is to now use the same code but with an edit. Once the button is pressed it will look for the invoice number & print it as opposed to viewing it. Thanks Private Sub OpenInvoice_Click() Const...

Attached file. after you step into the macros. once it filters invoices unpaid by the first customer, in the pivot. It gives an error I was not able to resolve this. anyone able to help me run this code please. Objective of this macro is automate: filter on pivot for each customer, that...

Good Afternoon. Working in a finance department, we quite often get issuesthat payments are received, but we have no idea what invoice numbers have beenpaid in that particular payment. This is because the client has not provided aremittance advice (list of invoices they have paid). I am...