paste value conditional

  1. D

    VBA to Paste values if condition met

    Hi All! I'm looking for VBA code to copy and paste values in the range D37:F54 in the below example, but for only the rows that are not sub-totals (i.e. paste values for accounts that do not start with a "PL") Right now all rows have formulas in them that populate the data from somewhere else in...
  2. A

    Clean up code for loop to edit other excel sheets

    See code below: Sub runallmacros() Dim wbSource As Workbook Dim wsDest As Worksheet Dim row As Integer, os As Integer Set wsDest = ThisWorkbook.Worksheets("File Copier") row = 2 os = 0 With wsDest Do While .Range("K" & row).Value <> ""...
  3. L

    IF x THEN Paste Value?

    I'm currently trying to create an investment portfolio tracker, however I'm having some trouble tracking my data on a day to day basis. Right now I have a section for my portfolio which imports external data for share prices, which then calculates change in value, and my overall portfolio...
  4. R

    A tougher question

    Here is a table. Any help with a macro that would a: scan through the list of rows. Whenever there is a single row with values in the cells which is bounded by a blank row above and below, I would like to enter "1" in address CX and a "1" in address dx <TABLE style="WIDTH: 332pt...

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