worksheets in workbook

  1. S

    Looping through worksheets not working

    I have the code below and seems pretty standard but it only runs for 1 worksheet and doesnt loop through them all. Cant figure out whats worng Sub formatdata2() Dim keepcolumn As Variant Dim fnd As Variant Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets 'Cells(1, 1).Select...
  2. D

    Using VBA to search over multiple sheets and paste data into new one

    Hello, Im new in VBA, and im searching for a script that would search in multiple sheets within one woorkbook, for specific text (specified in script itself) and paste it in a new sheet. for a descritpion: - multiple sheets (search in all of them) - skip new reference sheet + few others...
  3. L

    Sum across multiple worksheet

    Hi, I have multiple workbooks that all have 7 worksheets within them with varing names. I want to sum the same range across all worksheets but how do I select these 7 worksheets without defining the worksheets name? There is only ever 7 worksheets. This has stumped me and I am yet to find an...
  4. J

    For Each not looping through worksheets

    Hi! I am trying to consolidate data from multiple workbooks into one sheet in workbook. For some reason, I cannot get excel to loop through those every sheet the workbook and copy the data. I am including my code below. Any suggestions would be appreciated! Sub BOCIndex() Workbooks.Open...
  5. M

    Search Entire Workbook

    Hiya, I have created a workbook with multiple worksheets of data. I'm trying to understand macros and formulas but I am not very good! I want to create a master page which has a search box that will search all of the worksheets for any text that is entered and display the results. is this...
  6. P

    Consolidate multiple worksheets into a new sheet

    In Excel 2013, I have a workbook where i want to combine multiple sheets into one worksheet. I have the same headers in each sheet. I would like to create a sheet called Consolidate and merge the data from the other sheets into this sheet. I consolidate the sheets every three days. When I do, I...
  7. E

    VBA code to copy contents from newly added worksheets to an already existing worksheets on the same workbook

    Hi guys, I have a macro code that opens up excel files and adds them up to an existing workbook (that is already open) with already 19 worksheets (worksheet names as follows: “result”, “1”, “2”, “3”,.. until “18”). Now after adding the new worksheets (18 total as well with varying sheet names...
  8. J

    Vlookup Macro - Need help in running Vlookup for Multiple Columns in different worksheets from Master Excel File

    Hi.. I have a master excel file (Table 1) which has all the required details based on an unique ID. Need help in creating a code which could help me in running vlookup against multiple columns in a fresh excel file (Table 2) which has the same unique IDs. There are multiple worksheets as...
  9. R

    Macro for Pasting Formula/Formatting across multiple named worksheets

    Hi guys, I've started a new role that requires me to fix the mess my predecessor created. My current assignment is to fix the formulas and formatting for over a thousand worksheets, spread across multiple workbooks. Each workbook represents a country e.g. 'England' and each worksheet in said...
  10. Prevost

    Looping through all WS in WB not working using For

    Hi There. My code below is supposed to highlight all the rows of the cells in a specified range (in column B) that begin with a letter. I am trying to loop through all the worksheets in the workbook and am using the FOR counter from 2 to the end of the WS. However, it only works on the active...

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