sheets

  1. H

    How do you unhide multiple sheets?

    I hid a lot of sheets, now I seem tho have to unhide them one by one. Is there a btter way?
  2. F

    Help Needed Combining Index/Match with Sum across Different Sheets!

    Hi All, this is my first time posting here. I have done a lot of google searching but i haven't found exactly the problem to my issue. I have multiple sheets which i want to add across. the rows and columns are not in the same order, therefore, a simple sum across sheets wont work. I want to...
  3. N

    Consolidate Same Sheet from Multiple Workbooks

    Hi, I have a folder with files where I need one sheet from every file pasted into a master workbook. I have tried this with PowerQuery, but believe there are too many files for it to process. My files are saved at the path: "C:\Users\user1\Desktop\Combine Files" There are approx 100 files...
  4. W

    Pulling info from 2 worksheets

    Hi All, I have a workbook with 3 different sheets - (Sheets1 & 2) are data sheets where I enter in various data which both start on A1 and only go as far as row I, depending on criteria will depend on which sheet I update. On sheet 3 I would like an overall master sheet which pulls the data...
  5. H

    macro to Update Formulas on all Sheets (F9)

    I have written code to update my formulas instead of manually updating using F9 It is not updating all sheets, only the current sheet Sub Refresh_Formula() Dim ws As Worksheet For Each ws In Worksheets ws.Calculate Next ws End Sub It would be appreciated if someone...
  6. A

    Workbook_SheetChange event

    I need pivot tables to refresh automatically once a user enters new source data. I have my workbook set up on monthly tabs and the users can enter data below row 12 on each of these tabs. I have set up the workbook with dashboard/display tabs at the front and the monthly data sheets at the...
  7. W

    copying data from 2 different sheets

    Hi All, I have a workbook with 3 different sheets - (Sheets1 & 2) are data sheets where I enter in various data which both start on A1 and only go as far as row I, depending on criteria will depend on which sheet I update. On sheet 3 I would like an overall master sheet which pulls the data...
  8. masud8956

    Problem refreshing charts in multiple sheets depended on data from specific sheets

    Hi, I have some data involving dates {including =TODAY()} and numbers in Sheet1 and 2. Sheet 2 is hidden from view. in Sheets 3, 4 and 5, I have several charts (Line, Doughnut and bar chart). The line chart is located at Sheet3 getting data from Sheet2 only (hidden sheet). Doughnut chart is...
  9. L

    in PQ can we merge multi sheets in Multi Workbook at same time

    Hi all i have 5 files for 5 regions each files contains From 4 to 10 sheets ( each sheet for Product sales Anaysis ) i merged it by my PQ File file then i use PQ also to Merge it all in one file that is mean i use PQ 5 times for 5 files then i use it again to merge it all in one file can...
  10. A

    Distributing specific information from one sheet onto 4 more sheets depending on values

    Hello everyone, I've been doing some research lately on this forums threads seeing if I can find a solution that is similar to the situation I'm in, but have found that while some come close, they weren't necessarily the fix I was looking for. I have a workbook where I'm forced to distribute...
  11. O

    error message

    i kept getting this message whenever i try to unprotect one of the sheets i was working in excel today. it said this "the password you supplied is not correct. verify that the caps lock key is off and be sure to use the correct capitalization"....but the password i encrypted on are NUMBERS! does...
  12. A

    Copy data from selection of sheets

    Hi I'm trying to collate the data from sheets 2 through 11 onto sheet 1 of a workbook but I'm struggling with the macro. How would I go about cutting and pasting the rows with data from sheets 2 to 11 (without headers) on to the next available row on sheet 1?
  13. C

    Dynamic Data Validation

    Hi All is it possible to do a dynamic validation list using data from multiple sheets. I have a front page and 4 identical sheets, just with different sheets names. I need to be able to have the list of all names in B3:B75 from each sheet in 1 list, also needs to ignore any blanks. Working on...
  14. N

    Macro to Highlight all matches between two sheets

    I'm looking to implement a macro that would first match a name in column A of Sheet1 with a name in column A of Sheet2. It would then go through every column of that row in Sheet 2 and compare it against the row in Sheet1 and highlight all the matches in Yellow. This is what I have so far but it...
  15. D

    Input Box to update multiple sheets/cells

    Hey ya'll, Been tinkering a bit to see if I could get the macro recorded/cobbled together to do the following, and I keep hitting roadblocks in debug: 1.) Select several Sheets, and Ranges in each 2.) Have an Input box pop up, requesting a number 3.) Increasing the selected sheets/ranges by...
  16. Z

    Copy certain cells in a row to another tab if value in column >= date()

    I found a thread that was extremely helpful in copying entire rows when the value in a specified column > 0. However, I only want the values in columns A,B,C,D,G,S instead of the entire row. The code I modified from Fluff's answer looks like: Sub WeeklyReport() Dim rng As Range Dim cell As...
  17. O

    loop through specific sheets and copy entire row into one master sheet if data is in column

    Dear VBA wizards, Can someone please help me – I have been going through this for a while I have about 25 sheets in total in an excel file of which 10 sheets (one tab is called is AGV, one other tab is AGR etc) has some data and I would like to copy the entire row in each of these sheets if...
  18. R

    Prints Sheets and SaveAS Macro

    I want to create a macro that Prints 3 sheets from my workbook and then launches the saveAs window The 3 sheets I am looking to print are "Team 1" "Team 2" & "Team 3" Is this possible to do in one macro since there are windows that will pop up for both printing and save as?
  19. F

    VBA input box help

    On: Sheets("Players") I have a command button, when clicked this runs: Private Sub CommandButton1_Click() Dim Player1 As Variant Player1 = InputBox("Enter Player 1") ActiveSheet.OLEObjects(1).Object.Caption = Player1 ActiveSheet.OLEObjects(1).Object.BackColor = 49152 End Sub On...
  20. S

    Move sheets to another sheet if condition meets

    Hello Team, I have workbooks stored in the folder with the different names, i have to create a master out of those in one workbook. Workbooks stored in the folder contains name starting from Apples_x.xlsx ddd_Apples_Y.xlsx CCC.Apples.xlsx Grapes_dd.xlsx Grapes_PP.xlsx Each workbook contains...

Some videos you may like

This Week's Hot Topics

  • Get External Data (long shot question!)
    This is likely a long shot but I am wondering if it is at all possible for Excel to somehow 'change' the contents of a URL that is being linked to...
  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • Cell Formatting
    Good Morning, I need to format a few different cells in the following manners: A1 has to always add a colon (:) after whatever is typed in by a...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • Workbook_Change stopped working !
    I am working on an app to speed up & automate processing of Credit Cards statements. After data is input from a CSV file, it is presented to the...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
Top