macros multiple workbooks

  1. H

    Macros to search cell & copy value next to that cell..paste this value in new excel

    Hi I want to make macros which gives me box to enter value (e.g. "set") and search "set" in whole sheet than paste value(e.g."groups" next to "set" in another sheet in my defined column/Row. Tool should have below option to manually filling 1.Text/number to Search 2. Location to paste (e.g...
  2. D

    Paste on first empty row

    I have searched through as many of the forum posts that i could find but have been unable to find the answer i need. I have a form that will be used for data entry and i want to create a macro that will take specific data from the form and paste into the first empty row of a summary workbook...
  3. A

    copying of a sheet to a new workbook

    I have some code which i use to export a sheet to a new workbook, its a summary reporting sheet. It works fine but im wondering if i can improve this. At the moment the issue is the code has to reference the new workbook to copy the data (fields have more than 255 characters). Excel adds 1 to...
  4. B

    Extracting Specific Values from Separate Workbooks for a Master Workbook

    Hi there, I'm looking for help coding a specific macro multiple workbook task. Here's what I'm trying to do: I have a folder, titled "Analysis". Inside it there is a "MasterList.xls" workbook and a "Data" folder. Inside the "Data" folder are all my source workbooks. The source workbooks are...

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
Top