invoice

Hello, Is it possible to have a field on a worksheet that can serve as a lookup for an ID that I can pull the related data from another sheet? If so can that data be protected when the data is completed like in an invoice situation? I appreciate any advice or help, XJ

Hi. This is what I got, it works like I want it except for when it's to enter retail price and contractor pricing. what I would want it to do is make sure whoever enters the item and price that they enter it properly... and numbers only... so if they were to enter an item with the $ sign or...

I'm trying to write a formula to work out future potential monthly revenue based on contract start dates and their associated payment terms and value... hopefully someone can assist The input cells would be: Column V from cell V12 is the contract monthly value Column W from cell W12 is the...

I have an invoice table with all the invoices for all the accounts. Each invoice belongs to an account. We log the Invoice Date for each invoice. Each account should have 1 invoice per month. I want to make another table where all the account numbers are listed, and the second column would be...

I'm trying to create a measure that shows what orders haven't been invoiced yet. I have an invoice table with both Invoice Number and Order Number and a Order Table with Order Number. I want to to get the value of the Orders without invoice number.

My excel invoice number SW-BAN/DN/18-19/1557 and running is only last 4 digits (1557), can anybody help to given macro code changing that 4digits

Hi I have a scenario where I need to be able to split the amount over multiple rows. Example of current data <tbody> Invoice number Location Quantity Amount 100 A 2 10 101 A 4 30 101 B 1 0 </tbody> What I need to do is against invoice 101 be able to split the total invoice amount...

Afternoon all, Bit of an odd one, and I'm probably over complicating the issue here. Essentially I have a set of data like this: <tbody> Cust No Name Invoice Date Due Amount 12345 ABC 00001 19/03 4000 12345 ABC 00002 20/03 4500 23456 CDE 00004 19/03 3000 34567 DEF 00007 11/02 2000...

I have a question that I'm not sure is even possible. Let's say I am creating a spreadsheet that has budgeting info... Budget owner, vendor paid, date, etc and then at the far right of the spreadsheet I need to list each invoice number and invoice amount (typically 5+ invoices per vendor). This...

I am trying to recreate a multi-page invoice. I have it working as a single page but I think I need to abandon what I have already done use an array to cycle thru the data. Here is my data. <tbody> A B C Customer Invoice Payment 2 John K Company 3060453 $1 3 John K Company 3060453 $7...

hi, i know what i want it to do, but dont know if its viable I have to invoice the customer each week . So for example :- WC 11//2/19 has invoice number 9 is it possible to automate the invoice number (located in cell g1) to change accordingly based on the WC date (located in cell b4)? so...

Hey all, I am new to vba coding and have been trying to figure this one out with no luck. I have an invoice registry workbook that we use to track expenses. I am trying to prevent duplicate invoices from being entered across different sheets. The top of my sheet has formulas that calculate the...

hi guys, i need to write a function that tracks progress of a particular invoice through different sheets. I have a main sheet that should show numerical values of 25, 50, 75, 100. My function works with 2 sheets but if i add on more than that it fails the formula for 2 sheets is...

Hi All I have written a code that i cant get working, Please can someone help? This code is for automating invoice to inventory so that when the invoice has a quantity of a certain item it will subtract from the stock. If i run the code it works on the first line to subtract the correct value...

I have 4 invoices across multiple sheets (new sheet added monthly) and I want to create a master sheet with all part numbers on it. So I don't have to go through the invoices manually and transpose the cost, is there a way to use either IF(OR or INDEX(MATCH to pull the data from any of the...

Hoping someone can help me. I need to create something that can help calculate a "bonus" if certain items are sold on the same invoice with amount greater than $X. Something like this: To qualify employee X needs to sell gallon of milk to qualify priced at least $X, if he can add yogurt...

Hi , I want to write the VBA code which can generate one pdf file with multiple sheet with specific range. I have excel file with 3 sheets: Accounting ,Management and invoice. I want generate pdf file which has data from Accounting from range A2:I43, from Management from range A1:H25 and from...

Sir I have a Table of Invoice records, But I'm trying to get data for individual Invoice number, if I use INDEX or VLOOKUP formula that will get zero value also I need greater than zero products and quantity only. Please help me <tbody> Invoice No: INV/2019/0020 Customer Name...

Hello! In column B I have invoice numbers, but not on every row due to some invoices having multiple items, (row d- irrelevant) and in column C I have the date the invoice was sent. What I'm trying to do it highlight the invoice numbers in column B if there is no date in column C. I would like...

Hello everybody! I have a sheet which looks like an invoice. There is a City value in cell H2. Other data of concern are: Customer in E1, Address in H1, Phone in H3, Total E18, Amount Due in J15. Now the invoice repeats itself in the same sheet. So there are multiple invoices in same sheet...