coding/macro

  1. L

    Macro code to transpose specific cells in each row depending on text in that rows "Address" column

    Hi all, I am trying to transpose data in column B and column V of my spreadsheet. I need the cells to basically transpose each row of a spreadsheet in those columns (I need column B to transpose to the cells in columns C,D,E,F,G, and I need column V to transpose to the cells in columns...
  2. F

    Pulling Data from Websites

    Good Day, Im not a pro with Excel, and need some help with a spreadsheet collecting Data, I need to build a macro for the following: pulling Rack prices on Gas and Diesel out of Edmonton, and WTI Crude I have excel 2010 currently and want it to go into a spreadsheet daily so i can monitor the...
  3. S

    VBA Code IF AND Statement

    I run a report everyday that puts the the word "NULLIFIED" in either column "L" or "M". I would like to create a macro that would delete the a row that has the word Nullified if nothing else appeared under the columns G, H, I, J, K, L, M, or N in that row, however if there is other data under...
  4. J

    How to have your spreadsheet tabs change different colors automatically

    I have created a spreadsheet of about 80 or so tabs. On each individual spreadheet, in a specific cell, I have a percentage that is populated. In another cell I have the "IF" formula to populate OFF TRACK or ON TRACK based on what the percentage is. I used this formula in the macro view code...
  5. D

    coding for copying,pasting,eliminating "0" rows,formatting

    I hope somebody here can help me with some coding issues. I have been trying to do it via Record Macro but I am stuck. I need to accomplish this report as soon as possible. I have tried to add the code using Mrexcel HTML maker but it didn't work. I also have a workbook but I don't know how to...

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