invoices

Hello all, happy hump day! I have columns for 30days past invoice date, 60days past invoice date, 90days etc. The formula is set to record a date according to todays date vs invoice date and puts that date in the appropriate column (30-45-90-120). There is a running total for invoices until...

Need help modifying the below code to add any new files imported to the bottom of my master sheet (Ariba Invoices). Currently when I import a new file it overwrites. I need it to find the last row on Ariba Invoices master sheet and add the new data. Any help greatly appreciated. Sub...

Hey guys, i’ve lurked on here forever now and have learned so much. Always considered myself a resourceful guy (been writing my own scripts for games since I was 12) however my actual education is limited. I graduated from college in accounting / finance, not software or IT. However i’m known...

Hi, I am looking for a way to automatically create PDF invoices using Excel. I have a standardized excel-sheet with customer information and I'd like to be able to push a button and the customer information to be gathered into an invoice template that I've created. I.e. for each line of...

Hi everyone, my first post on here, so please be kind. I have a list of invoices raised and alongside each which Purchase Order they refer to. In a Pivot I can see the total invoices raised against each P.O, but I am struggling to show the outstanding value of the P.O. The list is constantly...

Hello All- I've created a gift certificate that I would like a VBA to print sequential numbers in three separate ranges (I1, I12, I23). There are three gift certificates per page each needing it's own number. I found a VBA that will do one range very well - it prompts me with a beginning and...

I hope to word this correctly or at least so it makes sense. I receive a list of open invoices every day in a Excel file and then merge these together. Basically I insert a date into column A so I know the count of days that the invoices appear in the report. Sometime, very often in fact, the...

hi, Just need a bit of help with some data for over due invoices. for example the data will look like <colgroup><col><col span="3"><col span="4"><col><col span="2"></colgroup><tbody> Date Balance Current P1 P2 P3 P4 Older Due Date Payment Terms Days Overdue 19/09/2017 2,160.00...

Hi everyone I have data in two tables. The first table contains invoices that have been paid. The second table is invoices that have been submitted for payment. I need the check the invoices in table 2 against table one to see if they have been paid already. I want to match the value of...

I have a table with invoices and revenue. Invoice Revenue A 200 B 600 A 500 C 400 The output I'm trying to get is the number of unique invoices less than 500. So this example, it would be one invoice, "C" for 400. The DAX formula below, sees...

I'm creating a 2018 budget spreadsheet against which I'll track invoices for burndown charts. My budget rows are created as LineID Vendor etc etc Jan Feb Mar ... Dec Total XY001 IBM $50 $50 $100 $50 $xxx AM005...

I have a sheet with data split into 52 weeks and there is totals on each line I want to be able to pick a company from c and from 0 "y" I want to get all where these are the same on sheet2 I want each roe. this is so I can show what invoices have to be paid. Thanks

I am creating customer collections letters and need to be able to add rows of data into the letter based on how many past due invoices the customer has. Each customer has its own tab, and the number of past due invoices is in cell B3 on each tab. I need a macro that will go to each tab and add X...

Hello everyone! I'm new to this forum and this is my first post so please be kind. :) I am a travel agent and we do all our invoices in excel. We save each invoice as its own workbook. (I know that's probably not the most efficient way but I didn't make up the rules it was just like that when...

I'm hoping someone here can answer this question. What I'm trying to do is set up a worksheet with product information (barcode number, item description, and unit price) to use as a databse and then set up a separate worksheet with invoice information (invoice number, product code, item...

Hello its seems great commune here. i have been looking for many solutions and im not good at vba, anyway i have a minute away from banging my head into wall :laugh: Anyway my problem is: i have over 200 clients whos invoices needs to be sent out in every month. is there way to auto generate...

Hello. I am glad I found this forum. I have a problem for which I haven't found a real solution but I am sure there has to be one so here I am praying you guys can point me in the right direction. Firsty of all my knowledge of Excel is intermediate and NONE for macros. I started at a new job...

Hi everyone, First, I'd like to thank the collective community for their efforts in solving other people's excel issues as I've had many of the same problems. Secondly, I've looked all over the place and I've not been able to resolve my current issue with invoice numbering in an excel...

Let me preface by saying my knowledge of excel is very basic and I am learning but due to the economy I was thrown into this position and am grateful to have it so I'm just trying to swim, sorry if this has been answered before but here goes: I am looking at the inventory list here and was...

We are trying to move away from Paper and Pen.... I've created our new invoice in Excel, but need a way to insert an Electronic Signature, for the Customer to "sign", making the Invoice / Contract legally binding. Trying to find a way to do this without having to pay for a third party plug in...