sheets

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...

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...

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...

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...

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

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...

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. :(

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...

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...

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...

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.

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...

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...

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)...

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...

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=...

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...

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...

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.

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.