multiple worksheets

  1. K

    Help copying a specific named sheet from multiple workbooks onto one sheet in another workbook?

    I have a number of excel files that have two different named sheets (let's call them "x" and "y" for simplicity); so file1 has two sheets "x" and "y"; file2 has two sheets also named "x" and "y". I want to combine all of the worksheets named "x" onto a master file with a similar name such as "x"...
  2. V

    VBA Macro to paste values from a list in multiple separate worksheets

    I have the an "Input" spreadsheet with a list of unique values. Then I have a series of worksheets that are identical templates. I want to past each unique value from the list on the "Input" sheet into the same cell within each of he separate worksheet templates. Ideally the macro / code...
  3. R

    Copy row to another worksheet if value met

    Hello all this is my first post and also learning vba. I was hoping to get some help solving this issue. I am trying to copy and paste rows with a true value of "open" in column A to a specified worksheet("Open Disc") from all available worksheets. When pasting all true values, I would like...
  4. A

    Name Range across multiple (200+) sheets

    Hi, I have an excel workbook with 200+sheets of data tables. I need to create a named range for each table. That is for each table, I go in and highlight a range - say A22:S50 and then name it Table1, Table2 in the name box or I can do this for name manager. Is there a way to automate this...
  5. C

    Create database and league table based on products from multiple worksheets

    I have a document with worksheets named WK01 to WK52. Each week I want to paste a series of data in to these worksheets. The layout and format will be exactly the same each time. Only the data will change. In column E of the week worksheets there will be a name of a product, column F the...
  6. N

    Pivot Table - Show Details VBA - Multi Row and Column

    Hello, I need assistance, please! I have an excel document that has multiple worksheets. On one of the worksheets, I have multiple pivot tables that are manually created, based on the data being used. The primary use for this document is to take a "Big Data" file and provide the "customer"...
  7. S

    Move Rows To a Specific Worksheet Based on Entry in a Cell

    Hello - I've searched the forum, but not found anything that specifically addresses my issue. I have a task list workbook that contains 4 sheets: Master, Today, Assigned and Done. All tasks are entered in Master, and I want to have the row deleted from Master and moved to the next available...
  8. C

    Importing Data to Excel Workbook

    Hi, I am working on a project and I am trying to import data fromone excel workbook (possibly converted to a .txt file) to another and wouldlike to use vba to do it. The data imported to the second excel workbook wouldneed to be inputted on various worksheets and various cells, which are not...
  9. J

    Copying a Sheet and Incrementing a Forumla On the New Sheets

    I have tried searching through the forums to hopefully find an answer before posting, but I could not find anything. So please direct me to another thread if I simply failed to find it. Sheet1 This sheet has data in cells B3 – B52 Ex. B3 = 750 E B4 = 750 F … B42 = 610 B … B52 = (Blank, Future...
  10. L

    Pivot table, countif, filter problem

    Hi Guys I have two worksheets with customer data in them, I had created a pivot table for one of the sheets and then was doing a =COUNTIF(TCF!C:C,"*"&A22&"*") to match the data on the other worksheet it would provide a 1 if it was there and 0 if not.:eeek: Is there a simple way around this, I...
  11. K

    Macro to copy data from multiple worksheets and paste into a single worksheet (within same workbook)

    I'm working on a workbook to collect several individual worksheets worth of data into two main worksheets. The data is always changing and the amount of populated rows changes as well. What I need: Delete all rows under row 5 (starting at row 6) in worksheet "Active - TOTAL" Delete all rows...
  12. T

    How to find data on multiple sheets dependant on a value in a different shet

    I have a multiple sheet workbook that has 7 dates on a row with values listed under those dates in up to 7 rows. I also have a collection sheet with a moth of dates in a column. I want to search all 53 sheets for a date on the collection worksheet. When a date is found, I need to copy the data...
  13. C

    VBA sheet selection based on user selection

    I have a project that has a dropdown list for user selection based on the item selected, I want to be able to write user data to a different tab of the destination workbook. For example if user selects "Banana" from the list I want the submit button to go to "Workbook2" then set Worksheet to...
  14. T

    Create List of All Missing Values from 3 Dynamic Worksheets with Criteria

    Hello, First, all of you have been a huge help over the years. This is my first time posting, so I hope this is not incorrect in any manner. I appreciate any assistance. I am creating a VBA automation step for peers that have to manually enter in contract information for each of our...
  15. N

    Multiple worksheets with same form layout - into one list of rows worksheet.

    Hi All, Is there anyway with excel to compile loads of data from multiple work sheets into one worksheet? I have loads of worksheets that have the exact same layout on each one. I then want a way to pull each work sheet to a new row on one worksheet. Can anyone help me with this please? Nathan
  16. B

    An Elusive Table with chosen data from multiple worksheets

    Have a workbook with 70 different worksheets, all the worksheets are the same "Form", all these forms have a "comments" section (cells A35:G36), and a cell F32 which if an X is placed in it, indicates a failed inspection. Trying to add a table to the main page in essence a summary of failed...
  17. V

    Looping or Autofill to Final Row in VBA

    I have worked several days to get my macro to work but itwill not fill down the data to the FinalRow of a referenced worksheet. Background: a person opens a workbook (wbPPM) and goes to a variable worksheet(shtReq) where the person kicks off a macro. The macro open another workbook(wbQC) with...
  18. K

    Sumproduct or Sumifs Across Multiple Sheets

    Hi, I've read so many threads and can't seem to find examples with similar structure to mine. Need help, please. I'm trying to sum data across multiple worksheets into a summary where it must match text from the row & the year from the columns and sum the amounts across all worksheets. Showing...
  19. D

    Using VBA to create a dynamic chart with data from multiple sheets

    Hi, I am new to VBA and I want to create a dynamic line chart with a drop down for student name(name of the worksheets), to display one student at a time. The chart will plot total score over time by booklet number (1 – 18, 19 – 30). The chart range is A7 to Z column. The dates(x-axis) are in A...
  20. L

    Specify Minimum Row Height And Autofit Row Size for ALL worksheets

    Hello experts, I have a workbook with the same kind of data in about 30 different worksheet tabs. I want to make all of the rows with data in each worksheet be reformatted with a row height of 30, unless the content is larger than 30 then it needs the entire row to be autofitted. I have code...

Watch MrExcel Video

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