vba macro excel formulas

  1. 0

    Button with Macro that copies and pastes row into new sheet if cell has a certain value

    I need help with my macro. I've got a table of data A1:R35 in sheet "Active" and when the value in column R is 100% and you press this button I want it to copy and paste that whole row into the next available row in sheet "Completed". Here is my current Macro: Private Sub...
  2. W

    VBA Macro to sum a variable range and put the result in the specified column

    Hello, I am creating a macro that would calculate the sum from the column(TOTAL_DLR_AM) of the table(calculation) and paste the calculated sum in the next table(Approvals Summary) in the column(Sum). However i try but i am only able to calculate the sum but not able to paste the calculated sum...
  3. J

    VBA Macro code required for condtional IF statement

    In my excel sheet I have Demand, collection and balance rows. I have some value in I3 of balance row the value of I3 is depend upon the value of U1, if the value of i3 is less then U1 then, i3 = T1 and after that value of U1 should be U1-T1 & i3 should be zero. example - I have value 40 in my...
  4. G

    Need VBA help to copy/paste data

    I have 3 sets of data on a single Excel worksheet. The first set of data represents a copy/paste from an outside source that shows customer sales totals. The second set of data represents the same totals, except from yesterday. The third set of data is the 2nd set stacked on top of the 1st...

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