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...
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 <> ""...
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...
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 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.