summary worksheet

  1. S

    Pulling selected rows from multiple worksheets to a destination worksheet

    Hey all! Seriously struggling here. See if you can help this poor soul out! What I am looking for: There are 7 worksheets in this book, 5 of which have same column headings (second to sixth worksheets). I want to pull selected rows from these 5 worksheets into the 7th worksheet (CAP) while...
  2. K

    Summary of all worksheets

    Good day everyone, I am struggling to find the best option to solve my issue. I have an excel file for projects costing with around 30 worksheets corresponding to specific product/project area. When the project is initiated, required sub-parts are chosen in different worksheets, so that each...
  3. V

    Many WorkBooks to Summary WB

    Hello to one in this wonderful forum! I need some help on a Macro. I have a folder with many Excel WorkBooks in it. All the WBs are encrypted by the same password. The data in these WBs are in Sheet1, in the Column C5:C10. The Macro should open each WB in the Folder and copy the data from...
  4. D

    Need to Pull Rows of Data from Several Worksheets to a Master Sheet

    Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I need input on a formula that would be able to pull data from rows on several worksheets. The Master worksheet should be a summary worksheet of the other worksheets that meet a criteria. Also...
  5. A

    Indirect Function Summary Tab Template - Need Help!

    Dear users, I am looking to create a summary worksheet using the indirect function to collect "Prices" from several tabs in the same worksheet. As I have about 40 workbooks to do this for, I want to create a Summary Template I can copy and paste into the other workbooks: As seen in MrExcel #...
  6. D

    Code to pull specific cell values from each worksheet to a summary worksheet

    I have about 1-150 worksheets in a workbook that I need specific cells pulled so I don't have to go to each worksheet to see the value that is there (all the worksheets are exactly the same) I would like to start pulling values from the 5th worksheet to the end of the workbook What I would...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top