multiple sheets in vba

  1. C

    VBA macro that copies data from different sheets regardless of the sheet name

    I pull reports of various employees that list the number of meetings and the types of meetings they had during a pay period. When I pull the report, excel gives every employee their own worksheet. For example: Sheet1 - John Doe, 3 evaluation meetings, 1 commercial meeting Sheet2 - Jane Smith...
  2. H

    Comparing Data from multiple spread-sheets and fish out wanted data into a separate spread-sheet organized per tab

    I have multiple tabs of data (named AB, BC, CD, EF, FG, GH, HI, IJ, JK, KL, LM, MN, NO, OP, PQ, QR, RS, ST, TU, UV, VW, WX, XY, YZ, Z00, Z01, Z02, Z03) in my "critical numbers spread-sheet" with wanted numbers per application identified in each tab but columns and rows are inconsistent. I have...
  3. H

    summarizing data from multiple tabs in Excel

    I have 28 tabs of data (named AB, BC, CD, EF, FG, GH, HI, IJ, JK, KL, LM, MN, NO, OP, PQ, QR, RS, ST, TU, UV, VW, WX, XY, YZ, Z00, Z01, Z02, Z03) in my spread-sheet with varying data (columns and rows are inconsistent) in each tab. I need a summary tab with count of each column per tab(only...
  4. H

    How to create multiple worksheets from a list of cell values based on PO number

    <tbody> Order PO number Art number Amount 123 1345 1 17 123 1345 2 18 123 1345 3 8 456 6547 4 8 456 6547 1 9 789 4564 3 11 </tbody> Hello, I have got a range of cells which I would like to split to multiple worksheet when a PO number changes (column...
  5. K

    VBA - Copy Row to New Sheet if Specific Name Appears in 1 of 10 Rows

    Hello, I'm working off an excel file used to track overall and individual performance scores on jobs (for a moving company). Right now, everything is entered/copied into the multiple sheets manually, which is unnecessary, but I do not know anything about macros. The Master sheet will look...
  6. C

    VBA - Hide columns based on data in another sheet

    Hello, I'm intermediate with Excel formula but not very experienced with VBA. Any guidance on the below would be much appreciated! I've built a spreadsheet that will help my colleagues add/remove product codes that are used by a client. I need this because there is a specific set of product...
  7. R

    set print area for multiple sheet at the same time

    I have a file that contains 25 worksheets w/ all same formatting. Now, I need to set the print area to A1:N58 for sheets("firstone") and set the print area to A1:N40 for sheets("secondone"). I only know how to do this for 1 worksheet (activesheet) at a time. Below is what i used...
  8. G

    Subtracting Dynamic Ranges

    Hi, I am currently working on a VBA code for share analysis and I have found a very useful spreadsheet that takes stock data from yahoo finance based on your ticker list and start and end dates that you set. When you click 'get bulk quotes' command it retrieves date, open, high, low, close...
  9. C

    code question

    Hello to all!! I've got the code below Sub CopyUnique() Dim s1 As Worksheet, s2 As Worksheet Set s1 = Sheets("mypage") Set s2 = Sheets("george") s1.Range("A3:L500").Copy s2.Range("A1") s2.Range("A3:L500") .RemoveDuplicates Columns:=1, Header:=xlNo End Sub It works great...
  10. A

    Add new row and Loop range data from previous sheet - vba excel

    I'm looking for the right code where Sheet2 will add a new row and populate the Column B cell of the new row with data from a range on Sheet1. I need this to occur every time I add new item to the range on Sheet1. So if I have: Sheet1: <code style="margin: 0px; padding: 0px; border: 0px...
  11. A

    Run this macro on all sheets except those I'd like to exclude

    Hello, I am trying to get this macro to run in every sheet in the workbook except for the sheets I'd like to exclude. I've spent all day reading similar questions but havne't been able to get any of the code to work. Any help is appreciated. (Sorry it when i tagged it as code it was cutting...
  12. N

    Copy/Paste Range of Data from Multiple Workbooks/Worksheets to Master Workbook/Worksheets with Conditions

    Greetings, I've been searching and searching for a solution. I've been able some threads that address parts of what I need, but I'm such a VBA novice, I don't know how to put them all together. I'm hoping someone can help me create the code to get this done ... Excel 2003 Windows v8 --WHAT I...
  13. V

    calling modules in order on each sheet

    Hi, im having trouble running a set of modules in order on a sheet then when thats done loop the seem sequence through all the sheets in the file so far ive got Sub Run_all() Dim sh As Worksheet For Each sh In ThisWorkbook.Worksheets sh.activate Call macro_1 Call macro_2...
  14. J

    VBA with a named range across multiple sheets

    Hi all- Got what I hope is a fairly simple vba question. I am working with a 7 sheet workbook, and each sheet includes (among other things) about 10 input cells. I have used the name manager to define the entire range of those input cells (across all sheets) as "input". I was hoping to write...

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