margin

Hi All, I've found a macro online that I am using to save a fixed range to PDF, with the name generated by cells within the sheet. However when I try to run the macro it returns this: <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px 'Helvetica Neue'}p.p2 {margin...

Hi, I have one table with project costs (many different elements with names and net costs) and second table with margin fee (i.e. 10%). How can I combine to add another column to the first table and calculate margin using value from second table (10%). Till now I used to add temporary column...

I am using two separate formula's to work out margin on a product but getting different answers. Cost price is £302.50 To add 8.5% I am using =A4*(1+B4) where A4 is £302.50 and B4 is 8.5% - this gives me a sale price of £328.21 I then want to sanity check this by using the actual figures and...

hi i have a spreadsheet with several thousand rows. i know how to find dupes (through conditional formatting) - but i don't know how to filter to only show the dupes is there a way someone can share with me? thanks so much =) <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font...

Hello, I would LOVE some help with this one if anyone can please...I would be most grateful! So... I have a product and it has two costs: the cost of the physical goods themselves and then the cost of advertising, which is a cost-per-acquisition, or CPA. I also know that I want to make a 25%...

Dear developers, I have created a VBA application to process commissions and would like your feedback on how I can improve the performance on calculations on 20,000 rows of data. For instance, to calculate product margin I have used application.WorsheetFunction.SumIfs. Below is an image of my...

Hi everyone, Quite difficult to explain with my english skills! :( In G4 I need a vlookup formula that: vlookup column G (Margin) if cells in column E are matching if the date is the most recent vs column B While in H4: vlookup column G (Margin) if cells in column E are matching if cells...

Hi Excelforum, My task is to make a graph over the time 2002 - 2018 consisting of five departments (A-E) of our company. I want to graph sales (omsättning), result and margin % in the same graph. Is that even possible? Any tips? See photo: https://ibb.co/iDWSeS D

Hi, I am attempting to construct a profit margin calculator and am having some difficulty achieving the desired result. I have a basic profit calculator; profit(a4) = saleprice(a1) - cost(a2) - minus overhead(a3) and profit margin =(saleprice(a1)/profit(a4))*100 What I am trying to do is...

4 years ago with the help of these forums, we managed to get a formula for us which we've been using ever since in our profit calculation sheet for e-commerce. It was this thread here...

I get the "Run-time error '9': Subscript out of range" error when running my macro from a Button assigned to my macro, but if I run my macro from the ribbon it works fine. (When I debug, it says the problem is with the "LastRow =" line. Don't understand why. Table256 is the only table and only...

I've search a lot on the internet about what I'm trying to achieve but could get an answer. So here it is:A simple calculationCost + margin = Selling price (ie, A1 + B2 = C3) - 100+200=300This is what I want to achieve:I want to able to put two values in any cell and get the answer in the...

I have made a chart with multiple series and with a secondary axis. When I try to remove the margins on either side of the plot area by selecting "On tick marks" in the "Axis Options" area, only the left side of the graph removes the margin. Is there a way to get the margin on the right to go away?

I’m trying to do something that seems as it would be fairly simple, but can’t figure out how to do it. The challenge can be abstracted to a two row spreadsheet: A B C D E F G H I J A B C Row 1 is constants, A, B, C….J Row 2 is only three columns and the cell values are equal to the cell...

Would it be possible to combine the following two macros into a single macro? Thanks in advance. Sub DelRows() Application.ScreenUpdating = False Dim LastRow As Long LastRow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row Range("A1:A" &...

I am trying to make a sports prediction quiz. I would like the scoring to be <tbody> Margin Points Draw 40 Winner 20 Exact 10 1 9 2 8 3 7 4 6 5 5 6 4 7 3 8 2 9 1 </tbody> The selection will be pick, winner, or draw and the points margin of...

Hi I am trying to find a formula to calculate the cost of an item from the selling price and the % margin. For example: I buy a bottle of wine for £5.50 and sell it in my wine bar for £27.50 which I have calculated as a 400% markup where Price = A1 and Markup =B1 the formula is =A1+(A1*B1)...

I am looking for a template to create a score prediction quiz with a leaderboard feature the scoring will be as follows 40 points – Correct draw predicted. 20 points – Correct Winning Team predicted 10 points – Exact Margin of victory 9 points – Margin of victory within 1 point 8...

Hello All, I am looking for help to fix a macro, or build a new one. Goal: To create a looping macro which will copy/paste a column of store numbers into into a single cell in another sheet (on a 1 by 1 basis) and then paste 2 sets of returned results into the original sheet. The two sheets...

Hello everyone, So far I know that I can format my table in PowerPoint by going from cell to cell but this takes a while. Does anyone have any tips to apply format to the whole table all at once without looping through cells. Thanks. For lRow = 1 To inTable.Rows.Count For lCol = 1 To...