multiple sheets

  1. J

    VBA that copies multiple sheets into new workbook

    Hello All, I have the VBA script that will copy the active sheet into a new workbook and email it, but I can't figure out to copy multiple sheets into a new workbook and email it. I have tried a few things and I have got the sheets to copy into a new work book, but than it won't send the book...
  2. NFIREPROTECTION

    Multiple Workbooks Merging into 1 Spreadsheet

    Good Morning All, My company is working on upgrading their system for tracking their change orders. We have it currently being tracked on paper and then input into a spreadsheet. We need all the data that goes into the tabs RS, DW, and GM TO automatically input into the Sheet1 spreadsheet...
  3. C

    macro to copy and paste a range to multiple ws in workbook

    trying to debug a former teammates macro (novice user myself). object is to copy a small range, formatting and all and post in the same location in multiple worksheets that match certain criteria. in this case, moving July end of month (range g6:k8) to daily breakdown worksheets (all of July...
  4. R

    VBA - Copy Row Data to Separate Sheet when Multiple Criteria is Met

    I am building a VBA to generate a report but have never built a VBA before. User enters: Date From (B3) Date to (D3) Employee (F3) *Enters "All Employees" if wishing to include all employee data They hit the "Submit" VBA button and...the data populates beginning in A12 of the active sheet...
  5. P

    Moving unknown sheets to new workbook

    I want to move multiple sheets to new workbook. Currently, I am using the code posted below and it works just fine. However, its limited. Is there a way, Where I can count the sheets in the workbook first, then run the code to generate new worksheets and move only newly generated sheets to new...
  6. J

    multiple sheet IFERROR formula - help required

    Hi, I have a spreadsheet with multiple sheets within. (Sheet A, Sheet B, Sheet C etc). For each row in sheet C, I want it to search Sheets A and B for cells containing parts of text, then show the text from that cell in the corresponding cell. The formula I have currently is...
  7. Leonvl

    Run Macro on various other sheets

    I want to run a script when leaving a worksheet. When I put the following code the code runs in the current sheet and not in the targeted sheets. What's wrong...? Sub Workbook_Deactivate() Dim ws As Worksheet Dim x As Long Application.ScreenUpdating = False...
  8. J

    Input Box to search and copy from multiple sheets

    Hello, I currently have a macro set up that triggers an Input Box to input a range of dates. Once entered, it scans through the reference sheet and copies and pastes a specified range of cells from any rows containing a date within the input range. I've been trying to edit this macro to...
  9. B

    Problem printing multiple sheets to one PDF file

    Using Excel 2007 in Windows 10, but had the same problem in Vista. Have a workbook with about 50 sheets, half are data sheets, half are charts based on the data. To print only the charts, I hide all data sheets, right-click on a chart sheet and select all sheets. In print preview, I see 68...
  10. 1

    Most Recent Date of Entry - Multiple Sheets and Books

    I am attempting to create an Excel file that will allow my supervisors to view the last date an employee entered activities into their excel file. A workbook is set up for each employee with column K holding employee numbers and column a holding the dates. There is a different sheet for each...
  11. S

    Setting up a sheet offset?

    I am trying to set up a workbook for a daily log sheet, one sheet for every day of the month. Into a cell, I want to enter a value, which would be a meter reading, then have the value from the same cell in the previous sheet subtracted from it and entered in an adjacent cell. This gives me the...
  12. B

    INDEX MATCH Across Multiple Sheets

    This has been posted a few times before but the answer has never been definitive nor has it been dynamic to work in a multitude of situations. Sheets: DataSheetA DatasheetB DataSheetC DataSheetD Starting Point: $C$10:$C$999 =INDEX(DataSheetA:DataSheetD:$E$10:$E$999, MATCH($C10...
  13. K

    Creating Summary Page from Multiple Worksheets by using a filter with Reference from Summary Page

    I have one workbook with a summary sheet, an 5 to 7 input sheets (asset register) that I want to be able to select a dropdown on the summary sheet for say the branch and the workbook automatically filters all the input sheets by branch entries (all branches are included per asset category per...
  14. V

    Copy, paste Autofilter range without headings to another sheet. not working

    I'm happy with the way the code works (thanks Skywriter), I have worked out how to append the filtered data to an existing sheet if it already exists, but I just cant seem to do it without the heading row. I have followed the code in the multiple posts on the subject but keep getting a...
  15. T

    VBA Y Axis Adjustment - VBA only works on 1 sheet?

    Hi! I've pieced together some VBA from the internet to adjust the Y axis based on the calculated results of specific cells. The VBA works wonderfully for the chart on the first tab. The problem is, when I copy and paste the VBA to the next sheet, adjust the cell references and the chart name...
  16. C

    VBA Code to Search for a Cell reference within multiple sheets

    Hi there, I am currently working to have a spreadsheet that has a macro that can search for a set cell value in multiple other sheets, then jump to that found cell.# For example, cell $G$15. A user can enter a six digit code in here, then click a macro button. The macro will search for the...
  17. S

    VBA Script - Search multiple sheets for duplicates and paste onto new sheet

    Good Afternoon, I have searched a few things before creating this post so I apologize in advance if this was already done. The ones I have seen perform somewhat of what I'm trying to do, but not to the exact and my VBA/Formatting/Pivot knowledge is very very minimal. What I'm trying to do is...
  18. U

    AverageIF across tables on Multiple sheets; perferably with a reference to specific names

    I have been tasked with creating a large workbook to track productivity for a department across all of the weekday for the year. It must also include a sheet for the year-to-date average production for each member of the department. The way this was done last year by using a new worksheet...
  19. K

    Summarising row data into a separate column

    Hi, I am trying to take string data from multiple sheets that is listed in the same row each time, and summarise it in a column (or row), while removing any gaps. There may be a quite obvious fix, but I have found no solution. So I have data that looks like this: Sheet 1 <tbody> A B C D E...
  20. eq52515

    Copy, Search and paste from two different sheets

    I have the following problem: I would like to copy a cell in sheet one, switch to sheet two and search for the value that was copied; once found, then move over 8 columns and copy the value of that cell, switch back to sheet one, move over 8 columns and paste that value. And do this for as many...

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