vba multiple sheets

  1. C

    Using VBA to Copy Rows In 2 Worksheets into multiple worksheets Based on One Cells Criteria

    First off, I'm a VBA newbie (Covid cancelled my class! :( ) For work, I have a two Summary worksheet workbook that has a Pending and Completed tab. My boss wants this also divided into separate tabs by brand while still maintaining the information in the summary tabs so this is a copy not a...
  2. A

    Creating Multiple Sheets if they do not Exist

    Hi, I am relatively new to VBA and so far I love it. I am trying to write a macro that will create sheets and fill data into them. I would like for my macro to create the sheets if they do not exist or, if they do exist, then move onto the next steps. So far I have this code.. For i = 1...
  3. R

    Macro to hide rows on multiple sheets

    Hi everyone I'm new to VBA (which is to say I have no idea what I'm doing). I'm trying to create a macro that will hide empty rows on various worksheets when the workbook is opened. I have a similar piece of code that I've used successfully in another workbook: Private Sub Workbook_Open() Dim...
  4. J

    Making the code run on multiple sheets

    I'm currently updating a rotation plan, and we've opted to go for one sheet pr week, a total of 52 sheets + 2, since our 9 week rotation plan does not add up in 52 weeks. Thus, I have sheest 1-54, a base-sheet containing static information, and a information page. On each of the sheets I have...

This Week's Hot Topics

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