sheets

  1. D

    Find duplicates across sheets

    I have searched Excel Questions and have not found an answer to my question. I have a spreadsheet with five sheets, I need to see if there are duplicates in column A on three of those sheets. (I am comparing sheet 1 with sheet 2 and sheet 1 with sheet 3.) By the way, column A is social...
  2. B

    Opening a Message based on file name

    Hi Gang, I have a excel sheet that opens with a message box. The sheet is a template and is used to create other sheets with different variables. My question is this how do I have this box open whilst the sheets name is "Auto Blank feed sheet" and not open when the sheet has a different name...
  3. W

    Copy sheet with same row values to another sheet

    Hi, I'm a newbie when it comes to excel, to be honest all I know was the basic stuff, I just learned the word macro earlier this day from my boss, currently reading some of it. I was tasked to sort/clean output of data to our sheets, I would like to ask on how to copy the rows with the same...
  4. C

    Get cell value from another sheet in same workbook

    I have multiple sheets in the same workbook and would like to get a cell value from a specific sheet and specific cell. How would this be accomplished
  5. H

    Macro to copy all sheets from source workb

    I have a source workbook with several sheets. I would like to copy each sheet with the data into the destination workbook and to create sheets if these do not exist I am looking for code to do this Your assistance is most appreciated I have also posted on...
  6. T

    Copy and rename sheet VBA

    Any please help me on Excel VBA code that will open and new workbook and copy all the 2nd sheets from multiple workbook there whilst auto renaming the copied sheets based on the previous workbook name. :(
  7. F

    Saving PDF to specific folder

    Hi I've built a code that searches through a list (rngWB) of excel workbooks and produces them as PDFs. The code works well, but insists on saving the individual PDFs to my Documents folder. I want them to be save to a folder in my documents, but that is further named by the contents of a...
  8. Q

    Reference Multiple Sheet Names on one sheet

    Hi All, I have about 15 sheets in one workbook, which are named using numbers eg. 12345, 54321, 65432....etc. I'd like to reference/link the names of all these sheets on to one main summary sheet. This is different from referencing the sheet name within that same sheet. Is there some way to...
  9. R

    Sum cells in different sheets - do not update relative location if cell moves

    Background: I am trying to build a rough what-if tool for team resource planning. I have separate sheets for different projects. I have a summary sheet that has totals. I can sum cells for a given resource across the sheets to show all planned work by person for a given time period, however if...
  10. L

    grouping sheets and inserting a picture/shape

    Hi I wanted group several sheets and then insert a picture or shape in one sheet and hoping it will appear on all grouped sheets but when I group sheets, insert picture or shapes options are grayed out. Is that by design? Thank you.
  11. V

    VBA macro to save different sheets as seperate excel file changes my cell format?

    Hello, I'm currently generating sheets based off 3 templates For the most part (not all but almost the exact same range for all templates) J21 to J50 is set as accounting When I generate my sheets, all the ones created still have J21 to J50 format set to accounting Then I use this script to...
  12. P

    Date order on multiple sheets

    Hi Please help, I have the code below where I have multiple sheets rows from A:Q and the source is B which is the date what I want from oldest to latest, B1 is the header so it should start from B2. I am gettng an error on the 'Next' Private Sub CommandButton2_Click() Dim wksht As Worksheet...
  13. M

    VALUE error when using a range of sheets in formula

    I am trying to use a formula to SUM the values from a the same range of cells on multiple sheets and could do with some help please A formula that works is: =IF(C8="","",SUMIFS('Month (1)'!D$8:D$400,'Month (1)'!B$8:B$400,C8))+SUMIFS('Month (1)'!G$8:G$400,'Month (1)'!E$8:E$400,C8)...
  14. V

    Detect if worksheet exist, and if it does ignore the rest of the script

    I need my script to detect if worksheet(s) exist based on some critera and if 1 or more does, ignore the entire script. I want to add this part at the start of a current script I'm using. If any sheets already exist, it is causing me trouble... Of course this might not be the ideal way to...
  15. K

    Find last row value from multiple sheets and copy those values to another sheet

    ok got this far and the masg box shows last row values but having trouble on figuring out how to put those values in Sh5 column O , so it finds the last row in sheets 1 -4 , just want to paste the last row value into 4 cells starting at O1= lastrow hS1, O2=lastrow Sh2,O3= lastrow Sh3 and O4=...
  16. M

    Auto Lock Workbook Complete

    Hello, I am new to this form and excel . i have one question I want to lock my workbook complete after specific date or time. Workbook Have 3 sheets all three sheets i want to lock down after some specific time. my sheet1 have formulas so i already lock few cells which have formulas...
  17. 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...
  18. 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.
  19. 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.
  20. 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...

Some videos you may like

This Week's Hot Topics

Top