1. D

    How to get 1 vba code to run on all sheets in my workbook when active?

    Hi, Please can someone help me? I would like to run my code via a double click on the activesheet in my workbook. I know I can put the code in the sheets individually to run but because I have 20 plus sheets I was wondering if there was a way of having just 1 code in a workbook event instead...
  2. S

    Sum from sheets name based on another cell valu

    Hi I have Key & sheet names in Sheet1 & key(with Concatenate) need to vlookup with Key in another sheets & get the Sheet Name & sum the column values.
  3. S

    VBA to copy sheets & rename to workbookname

    Hello Team, we have requirement, where in i have the excel files in the folder, where i need to move in to one workbook with sheets names as workbooks names in the folder.
  4. A

    Code merge data of multiple sheets in one sheet

    hello i need help to find code merge data from 3 sheets in one sheet i have 3 sheets every sheet contains data in table with headers begins from b4: h10 i would code to merge data from theses sheets to sheet4 also when happens every change automatically changes in sheet4 i...
  5. B

    formula to get the value of the same cell but in different sheets

    Hello, I have a workbook with plenty of sheets named 'name 1', name 2', name 3,... One sheet is supposed to be an overview of the inputs from all those different sheets. So for example I want the value of cell B2 of all the sheets 'name....) in the overview sheet. Is this possible without a...
  6. V

    Rename part of multiple sheets if it meets my critera

    I already have a script that does most of the mumbo jumbo of what I need, however at the very end of that script, I want to add the part to rename part of some of my sheets to something else I have multiple template sheets and a master sheet within a workbook, those need to remain untouched...
  7. spacecaptainsuperguy

    very hidden sheets add-in

    Hi everyone, I used to have an excel add-in that had a form that allowed me to select multiple sheets from within that spreadsheet and select whether to hide, unhide or make very hidden the selected sheets. I recently upgraded my machine and office and that old add-in no longer works. I've...
  8. S

    [VBA] Only run macro in certain column

    Hello, I have what is probably a simple question - I have this code I grabbed from elsewhere, I want it to only run in column A on all sheets (rather than on all columns as it does now): Sub DeleteRows() Dim WS As Worksheet On Error Resume Next For Each WS In Sheets With WS.UsedRange...
  9. F

    VBA: Insert formula with variable number of sheets

    Not sure how to get the right syntax here to represent a variable number of sheets. Sub TryThis1() Range("G2").Formula = "=AVERAGE('1:4'!E2)" End Sub The 4 in the formula is the variable part. Whatever number is in Sheets("CtrlPnl").Range("H12") is the total number of sheets. In this...
  10. W

    Find and Replace

    Hi all, I have created a macro which reads column B and then creates separate sheets based on the values-text found on that Column. I obviously get an error while new sheets are created. The 1st one is when text is over 31 characters. This is resolved. The 2nd one is when i have the 7 sin...
  11. T

    Rows not moving in sync with data from Master Sheet

    Hello, I have had an excel person working on combining sheets without our company, so one master sheet would be used to automatically transfer data to 6-7 other sheets. The issue, as we add data, the linked sheets update, the row going across does not stay consistent all the way across...
  12. V

    Delete all sheets that meets my critera without prompt

    I'm looking for a script to delete any sheets that meets the following critera and without promtp: If sheets contains the text: "PrixMax" "6po" "Quote" Then deleted them Sheet name can be "PrixMax-250", "6po-Viny", "Quote-101018" Along with those sheets, my workbook contains a "Master" sheets...
  13. spencer_time

    Use variable within excel function

    Hello, I have some test code that I can't get to work correctly. I am trying to figure out if it's possible to use a variable within an excel function, and if so, the proper way to do that. The following is what I currently have, it is not working: Sub embedVarFunc() Dim rng As Range...
  14. K

    Timesheets and Userform

    Hi All, I built our weekly/daily time sheets some years ago in Excel using mostly formulas to do the calculations. This worked great, but since I started to learn more about vba and userforms I am busy streamlining it to use userform inputs and vba to send the information to the relevant...
  15. V

    In need a VBA script to create sheets from 3 different template sheets and more...

    Hello all, first time here! I'm not proeficient much with VBA, hopefully someone can help me. I need a VBA script to create a dynamic amount of sheets at once based on 12 different cells value, from 3 different template sheets (I need to keep those 3 templates formula intact) and based on some...
  16. V

    Complex function

    Good afternoon Dear All, Firtsly i would like to apologize if my question contains any misunderstandings. I have a workbook where there are many sheets with many informations but i want to take a specific value from all those sheets. Imagine that there are lists of products per category in...
  17. R

    Pivot Table from Multiple Sheets

    Hello there, Can we create pivot table from multiple sheets? I have 5 sheets in a workbook and their column orders are identical. I need to create one pivot table using all 5 sheets as source data. I can't combine the 5 sheets into 1 due to the volume of data. Thank you!
  18. J

    Compare Sheets

    Hi, Can somebody please help me to modify the code below instead of changing the sheets name to compare in the code every time want to compare sheets instead to prompt for the sheets names to compare. Code: Dim sh1 As Worksheet, sh2 As Worksheet, c As Range, f As Range, mydiffs As Long Dim...
  19. H

    Excel file opening in sheets mobile not updating

    Ok I found the solution I'm just posting hoping that if someone else has the same problem they find this. I have an excel file that I use on my mobile (which opens it in sheets) that was refusing to update to the new version. I had verified that the updated version synced to from my...
  20. M

    Code sometimes not working on Workbook_SheetChange

    I am trying to make it so if the user copies & pastes anything in my workbook, it will only do a Paste Values. I found an answer to a post on Stack Exchange from a few ago that recommending putting the following code in the Workbook_SheetChange sub. Private Sub Workbook_SheetChange(ByVal Sh...

Some videos you may like

This Week's Hot Topics