copy based on condition

  1. B

    Search Range for Value, Copy Whole Row if Found

    Hi, I'm very new to VBA and have tried to solve this (have read many threads here) in the last couple of days but have not been able. I hope you fine folks are willing to point out where I'm going wrong. Context: I've got a spreadsheet with items in rows 5-713 down column B(merged up to cell...
  2. L

    VBA Macro to insert worksheet name and copy it down column

    Hi, The following macro copies two columns from every sheet in the workbook and pastes them into column B and C of the sheet named Journal entry. I would like to add to column A of the Journal entry worksheet the worksheet name for which the columns are being copied. Once I have the worksheet...
  3. G

    Unsure of which formula to use and then probably how to use it

    Forgive me as my question may be quite basic but I am trying to automatically create a new list off a master list in excel... I have a master list of prospects names and addresses from may towns and cities in a single sheet in excel and I am wanting to copy these to a new spreadsheet within...

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