sheets

  1. R

    Multiple matches from multiple sheets if criteria is true for multiple sheets

    Hi, I have two spreadsheets with the same columns names with similar data. i am try to find the difference between each sheet vs the other based on if a certain value is the same on each sheet in a another column. See below my example sheets for reference to what i am trying to achieve and the...
  2. D

    How do I move code from sheets to modules?

    At the moment, all my code is stored in two sheets and I want organise my code a little better by moving some of it into modules. I don't know how to move it to modules and have it still work, for instance, have the command button still run the code when it is clicked. How do I do this?
  3. Z

    Copying a range of cells from one sheet to another not working

    Hi! I'm trying to copy a range of cells to a second sheet and then delete the row from the first sheet. It seems like it should be pretty simple but the code is throwing an unknown error and highlighting the line "Sheets("Sheet1").Range(cell1, cell2).Copy" Any ideas why this would be happening...
  4. G

    VBA to insert values into multiple sheets, with range variable

    Hello I have a workbook with 8 sheets (sheet1 to sheet8) in cell A1 on sheet I have a variable number eg 3 i want this number to be used as a column identifier eg 3 = column C, 4 = column D etc So i then want select sheets 2 to 5 and select range C8 to M8 and enter the value "0" in that...
  5. V

    Macro to group rows and columns based upon each Row/column for multiple sheets in workbook

    Hi VBA champs..need help in designing "Macro to group rows and columns based upon each Row/column value in corresponding cell value for multiple sheets in workbook " 1. Each row should group independently for particular cell value say(0) in column "B" of same worksheet and ungroup for "1"...
  6. H

    Percent (%) displaying on linked sheet on one PC but not on another

    I have a workbook, where I have several sheets that links to items on sheet 1 Sheet1 contains values as well as percentages The values and percentages are displayed correctly on the linked sheets on My PC, but the percentages are displayed as values on the linked sheets when copied on to...
  7. H

    macro to convert negative values with Brackets

    I have values and percentages in Col D:J on sheets 16 to 25 I would like a macro to convert the negative numbers only eg -125, -128,965 etc in these columns and on these sheets with a bracket eg (125), (125,965) etc Your assistance in this regard is most appreciated
  8. A

    Excel found unreadable content

    I have a workbook with three sheets. It was created on computer A. If copied to Computer B and C, an attempt to open results in message: Excel found unreadable content. Do you want to recover the contents of the workbook. If I answer Yes, the workbook opens normally. If I then save it on...
  9. A

    Sorting multiples sheets

    I have multiple sheets with student score data in cells C1:AP9 No headers sort from left to right using row 9. Largest to smallest I tried using a macro with no luck. Any ideas or a VBA??? Thanks
  10. H

    Copy part of sheets to new workbook

    Hi all, Tried to find a solution for this but it seems I'll be the first to attempt it. I have a workbook containing several sheets, there are 7 permanent sheets that I have renamed as Sheet01 to Sheet07 and a growing number of other sheets. A macro allows the users to create a new set...
  11. A

    Excel VBA Copy & Paste Format & Values to new Workbook without Protection

    Hello, I am new to the group, thanks for letting me join. We have a tool we use for estimating that I have been automating with VBA. When we win a project I need to take some of the sheets and copy them to a new workbook for a handoff document to project managers. The trick is that I would...
  12. M

    How do you protect a sheets or cells or columns in a workbook, instead of the whole workbook?

    Hi, I have a few sheets in a workbook, which have macro`s, formula`s. When someone wants to input information they can do in the main sheets, where there are no formula`s, only input information. How can I lock or password protect the sheet or stop keying in the sheet, protecting the cells...
  13. C

    How to rename a newly copied sheet using a userform?

    Looking to have a masterworkbook that when I go to a job, i can add sheets and rename them as I go since all sites name gear different. I have a set of template sheets hidden within the wookbook that I draw from, but I was hoping to have a userform with a simple text box pop up, type in the new...
  14. K

    Very Hidden Password Protect Worksheets

    To start, I have no idea how to write or run macros. I know that I want to have 37 of the 39 sheets in a file I made to be VeryHidden so they are as protected as possible when the workbook is opened, with a prompt to enter a password to reveal the sheets. I've seen macros that I guess have...
  15. K

    VBA to hide sheets when save button is pressed

    Is there a VBA or macro that can hide certain sheets when the save button is pressed? Thank you
  16. T

    control your sheets data filter with one sheet

    i have 4 sheets each sheet has a Filters with data i want to combine this sheets in one Worksheet so i can control & modified them easy without getting to them Exemple like in the picture
  17. T

    control your sheets data filter with one sheet

    Hello Kings of excel i have 4 sheets each sheet has a Filters with data i want to combine this sheets in one Worksheet so i can control & modified them easy without getting to them Exemple like in the picture
  18. A

    Run-Time error 424 - Export to PDF Sheets - Array

    Hi all I am very new to VB and its mostly thanks to forums like this and a bit of internet searching. I have a Run-time error 424 - Object required issue Let me explain what I'm doing: I have a commandButton that actions SaveAs PDF The one button has to only export 2 specific sheets to PDF...
  19. T

    filter the content of an excel sheets from another sheet in the same workbook

    I would like to filter the contents of Excel sheets In another sheet I have 5 cells I want each cell is connected by its sheet so i can filtre them without getting back to other sheets
  20. R

    Macro for sheets

    Hi there, I am looking for a macro that I can use o unhide sheets in a workbook. I want to have three button in sheet1 for sheets 2, 3, an 4. Sheets 2, 3, and 4 will be hidden and depending n which button we click on in sheet1, they unhide. Also, when closing the workbook, I do not want to...

Some videos you may like

This Week's Hot Topics

Top