prices

Good morning all, I was under the impression that if I recorded a macro using excel it would also record actions made in other Office programs, am I wrong? I have seven different price bands which each have specific customers assigned to them. Currently I have to open up seven separate e-mail...

I have a spreadsheet with two columns. One has prices from a website, one has the prices from my vendor. The vendor prices column has text in it that defines the quantity. For example, 9.99 / Case , of 15.99/bag. I need to compare the website price to the vendor price, but exclude the text...

<small style="box-sizing: border-box; -webkit-font-smoothing: antialiased; font-size: 11.04px; text-transform: uppercase; display: block; color: rgb(105, 109, 111); font-family: 'Helvetica Neue', roboto, Arial, sans-serif; -webkit-tap-highlight-color: transparent !important; outline: 0px...

<small style="box-sizing: border-box; -webkit-font-smoothing: antialiased; font-size: 11.04px; text-transform: uppercase; display: block; color: rgb(105, 109, 111); font-family: 'Helvetica Neue', roboto, Arial, sans-serif; -webkit-tap-highlight-color: transparent !important; outline: 0px...

The title of this question was poorly written. I apologize. I have a column with part numbers in it. Column I. It has the same 120 or so part numbers repeaded over and over and over again. I have another column (Column J) with prices in it. Many of these prices for each part are the same...

Thank you for your time. I have a table that shows a Date, a Part Number, and a Price. It's a cumulative table. So there are part numbers that have multiple different prices. Column D shows the date. Column I shows the part number. Column J shows the price. I would like to create a pivot...

Hi, sorry if the following excel question is basic but any help would be greatly appreciated. I am currently working on a spreadsheet that comes daily, which contains prices in two rows. So i currently have an if function (=if(a1=b1,"stalepriced'',dailypriced") that if the price in column a...

Hi I have a workbook with macros. If a user opens the workbook and does not enable macros, then a sheet named "Macros disabled" will be shown and nothing more. If they do enable macros, then I have a macro that hides the "Macros disabled" sheet and shows three other sheets called "Information"...

Hi, I have this code that prompts a message if a user tries to add a new sheet in a workbook. I have three sheets that is allowed to be in the workbook called "Information", "Prices", "Copied Prices" in that order. If a user is working in sheet "Prices" and decides to try and add a new sheet...

Hi there, some help please. I have tried searching for an answer but I can't seem to find the right search terms to return the answer I need. I have two tables, for example: Price List <tbody> Product ID Price 10001 $1.30 10002 $5.10 10003 $0.85 10004 $0.99 10005 $2.00 10006 $9.99...

As you can imagine, I just started programming with VBA, and I've decided to tackle a problem with dates... With limited success up to now. I'm using MAC Excel 2011. I have a table with three columns, the 1st column has dates, the second and third, prices. For a given year, I'm trying to...

Hey Guys. I have a problem, not sure if it's even possible. But the case is, that see the picture. If I mark one box from Sec.1 and one from Sec.2, I want checkbox on the sec.3 to feel which one of thoose I used and specify a price depending on which checkboxes that is checked. So let's say...

I have found out, thanks to you wonderful people, how to use SumProduct formulas. Now I have a new question. What would be the best way to use the sumproduct formula for tiered pricing, if you have several different sets of tiers. For instance what if you have 5 customers and each of them has...

Hi, Hope somebody can help with the below formula, the 1st, 3rd and 4th columns we fill in. I have set up formula's to work out the next 3. I'm try to work out the list price, starting at the cost but incorparating the discount and making a 22% margin. The first table works final until you...

HI - I am trying to work out using the proper function(s) to achieve my desired result, but I am severely stumped. I need a spreadsheet that allows a user to make 3 decisions and have the result of those 3 decisions returned so that a formula can reference that amount to help me determine...

Hello, How do you multiply a column and have the results reappear in the nextcolumn? E3:E3631*1.3 = F3:F3631, is the code I tried.

Hello, Can anyone provide an excel function that pulls the price of a given stock at a given date? Thanks!:)