pricing

I'm updating a workbook someone else created a couple years ago and there are two incidences of worksheets that are identical except that Sheet 1 has the Item, Description and pricing info and Sheet 2 has Item and Description but links back to the first one for pricing info. The main sheet...

Hi I am trying to get a Vlookup funktion to work in a pricing worksheet. The sheet is going to be a template, so the customer account number will change with every use. For each item, i need to lookup a discount value in a pricing file.. The file is named as the account no, ex. "3720.xlsm"...

at least for me, probably not for most of you. Pricing of widgets will be volume based 1-24 $5 24-50 - $10 51-100 - $150 But not only that it will be based on term of commitment so one year pricing would be 1-24 if 1 year = $25 1-24 if 2 year = $10 1-24 if 3 year = $5 Can you give me some...

Need help... I have 2 workbooks One used internally for analyzing costing/pricing data (COSTING FILE TEMPLATE - NEW) and another workbook that is sent out to vendors for pricing/costing (VENDOR PRICING TEMPLATE). We have over 300 vendors that submit pricing that we have to transfer to our...

Good Morning Team, A new challenge, I have a quote template where we add enter prices into the Sheet1 unit price column. Sheet2 contains a pricing database with our total products list with costs. Can someone help me with code to look at "Part Number" & "Unit Price" from Sheet1 and find/update...

I am using a drop down combo box. The user selects an item from the combo box to which I concatenate the word Prices which in turn becomes an array name. If I explicitly name the array (_6600_Prices) my pricing array returns pricing as expected. Here is example of code that works...

Hi everyone, I'm creating a pricing workbook that will have worksheets added and removed based upon the number of locations I'm pricing out. For example, if I have 2 locations, I'll have my initial sheet, and then a VBA button will create another pricing sheet for the 2nd location. If I have 10...

I'm working on a purchase order form and I'm having some difficulties formulating the price column. Basically, the price changes based on the quantity of garments and the amount of stitches per garment. There is a price chart within the excel workbook with the x-axis reflecting the number of...

Hi, I am working on a Price Calculator. I need to highlight rows in the below table based on the value of a particular cell $D$6 <tbody> Pricing Tiers Multiplier Low unit price Mid unit price High unit price Mid price sale Total Level 1 Pricing AMF Cost x 2.5 to 3 times $22.85 $25.13 $27.42...

Hello, I am looking to create a pivot table based on massive raw data extracts to create client billing. My goal, is to be able to create a pivot table that in column A, I list out the Fund Family, Pricing Vendor and create subtotals daily based on the individual securities each portfolio is...

Hi Im quite new to this site, loving it already. This question might have been asked numerous times already, just dont know what to search for. I require assistance in creating tiers. This is based on tally system. Apologies if it is not clear enough. Not sure how to ask this correctly...

Hello, I have a master list that includes crates and individual piece pricing. When this was originally setup, it was all manual. There are thousands of items and pricing changes do occur. I have received updated pricing for crates, but not individual pieces. I need help creating a formula...

Hello, I am struggling with a progressive pricing problem and hoping you can help. I have a unit quantity range and a price I need to calculate. So for instance, in column B6:B10, I have the unit quantities. In column C6:C10, I have the price per unit. Unit Quantity (column B)...

I would like to program a macro (actually include in current marco) to do the following. The following code searches a master file looking for associated prices. However there is a possibility that A1 doesn't contain the number looked for. This gives me the #NA error in the cell. I would like...

Hello - I have designed a spreadsheet to calculate cost savings based on the difference between old pricing for transaction volume of downloads and new pricing. Each month, a vendor reports total number of downloads generated from their software platform, which are billable. The downloads are...

Hi board members I am trying to create a formula whereby if I enter a user number in a reference cell, 100 for example, Excel uses the below tiered pricing to calculate a monthly fee. 100 users should return a result of £13,340.00 9 @ £150 15 @ £150 50 @ £135 26 @ £115 User Tier 1-9...

Hi, Can someone help with a formula - If an amended price is present it will calculate product weight value with new price, if not it will use current pricing. Thanks for your help. <tbody> New Pricing Current Pricing Amended Code Amended Price Product Weight Actual Code Price/kg Actual...

I have to admit i thought thered be an easy solution to this but i have struggled. I have created a pricing chart for a venue that I hire out for parties. If i have created data where down the left hand side, the data is days of the week, and across the top I have parts of the day, (ie am...

Hi Everyone, I am working on a document trying to compile monthly purchases of parts for the year. The biggest obstacle I am facing is that the pricing for different parts changes at different points throughout the year. Currently I have one table listing each part with the effective and...

Hello, I am attempting to write a formula for distributed/cumulative tiered pricing and am not able to get the formula correctly. 1 - 30 units = $90/unit 31 - 60 units = $75/unit 61 - 100 units = $60/unit More than 100 units = $55/unit Examples of expected calculations are: 55 Units...