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

This Week's Hot Topics

  • separating multiple Proper names (uppercase letters) from a list
    I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
  • 'for' Loop
    Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
  • Open specific pdf in folder with vba
    Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
  • What is wrong with this For Loop code?
    I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
  • Data to match
    Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
  • Shifting Columns
    Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

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