multiple worksheets

  1. L

    Copy Subtotals from Source Workbook to Current Workbook

    Hello helpful peeps! Here is what I have: Workbook1 = Consolidation Sheet1 = Annuity Sheet2 = Annuity Adj (will be hidden) Workbook2 = Variable Name Sheet1 = Remit (Variable rows) Sheet2 = Adjust (Variable rows) I have current code that sets up the Annuity and Annuity Adj worksheets in the...
  2. M

    Lookup across worksheets with variable rightmost cell in each not working

    Hi, I am using a formula as follows to pull out the rightmost result in the second row in the column range F to Z: =LOOKUP(2,1/('ABC1'!F2:Z2<>""),'ABC1'!F2:Z2) This works as expected, but I have a number of worksheets, and I'm looking to pull out the rightmost result in the second row in the...
  3. O

    Summary sheet of multiple sheets

    Hi, I am working with making a template in excel for writing hours at my workplace. In sheet one named “Oppsumering” I want to have a summary from the other sheets I add. Each sheet represents one week and contains the hours from different tasks. The sheet named “Uke—” is the layout for where...
  4. M

    Using SUMIFS across monthly worksheets

    I have a summary page with people's names and I am summing up their sales from a given month (worksheet Jan, Feb, Mar, etc.). In those months there are one or more sales recorded in a row. But for some reason starting in the month of May and only on a few select people it no longer gives a sum...
  5. 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"...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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"...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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
  20. 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...

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