keyss

  1. K

    sales table question

    Hi, I am after formulas for 2 cells in a spreadsheet. Column A is a Cost price (derived from a report) Column B is for a Sell Price Column C is for the GP% I want to be able to enter an amount into Column B that will give Column C the GP%. Also the reverse so that I change the figure...
  2. K

    help with GP% formula relating to more than one cell

    Hi I need to know, if possible, I can do this please. I have 4 columns that relate to a sales formula; D = Retail Price (fixed value derived from report) F = Contract Price (fixed value only derived from report) H = Cost Price (fixed value derived from report) I = GP% (has formula as below)...
  3. K

    autofill column as far as table is long

    Hi guys, I have a table of data, I've added a new column in 1st position (column A), new value in cell A:2. I want a code to run the value down the column to the end of the length of the table. Relevant part of code: Columns("A:A").Select Selection.Insert Shift:=xlToRight...
  4. K

    deleting rows based on value of cells in column

    So hi, First off, thank you to NoSparks who helped me previously, was a great help & deserves a 'callout.' Issue I need help with. I'm trying to delete rows from a table based on a value contained of cells in a particular column. I can do it manually however using the recorded macro, it...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top