sheet names

first, I'm sorry for another index-match question, I have noticed a lot of these topic here. But I can't find one that helps me. Possible that I just suck a searching. But I've learned a lot from this site. Working on the Dutch version of 365 Question one: My excel file consists of a...

Hi all, So I am with a small challenge today. I have been working in some file I am not figuring out hot to solve this. So my problem: I have a Monthly Excel file, with some sheets. This sheets names (all days in the month) are the dates, as example: 01.01.2021, 02.01,2021.... etc... What...

Hi Is it possible to create a formula which reads subsequent Sheet names? So if I had data in Sheet 1, for example, I'd like cell A1 to read the name of Sheet 2 (which would be called 'Chocolate') cell A2 to read the name of Sheet 3 (which would be called 'Crisps') I know you can use...

Hi, I'm trying to extract some data from an old workbook which is locked (and the password is unknown and I cannot crack it). I have managed to type in the location of data in the old workbook into a new workbook to extract it (=[OldSheetName.xls]OldSheetName!A1 and fill down), which works...

Hi all. Thank you for any help with this. New to the forum and stumped with this - not sure if it's best done with a SUM formula or with VBA instead. I have a workbook with sheet (tab) names like so: AAA00001, AAA00002, AAA0000A, BBB0000X, BBB00003, etc., etc. On each of these sheets, I have...

Hi again everyone, Got another problem i would love some help with, and after having so much success here recently i wanted to challenge you all again. I am currently writing a macro to scan through multiple files looking for the sheet name which matches a cell reference in another workbook...

VBA to find and list all sheets with specific text, and place the sheet names in range to be used as loop. I need help to make a few macros please. The first Macro “FindSheets” is to find and list all the sheet names which have a specific word/text/phrase. Let’s say “BOWCHICAWOWWOW”. Then...

I am working on a spreadsheet that has a master sheet named weekly chart and a lot of other sheets named by dates. On the weekly chart sheet I have dates that I change each time I send the spreadsheet out. When I change these dates I want it to change all the sheet names on the remaining...

I am having trouble figuring out a VBA code to name all the sheets in my worksheet dates. I want to be able to change the dates in my main worksheet and automatically rename each sheet based off the dates I have entered. Please help!!

Hi, I'm trying to writea code that doesn't require stepping into vba to effect the outcome of themacro. Currently, I have acode that toggles the visibility of an array of sheets if the target cellmatches certain conditions (blue or dark blue fill). This code works great.However, I want to...

Hi, I'm havingconsiderable trouble writing a macro to do the following: 1) Select aparticular sheet in the workbook 2) Select a cell inthat worksheet 3) Check using a forloop if sheets exists and then insert data into a table if true The sheets I'mchecking for existence (whether they are...

Ok, so I have been browsing the site for several days and haven't found anything that really addressed my situation so decided to make an account and ask my question. Also I'm not sure if my entire post title is visible so I'll go into as much detail as necessary below to explain my situation...

I have the following code '--------------------------------------------------------------------------------------------------------- 'Create sheets for all agents in column E V2.0 '-------------------------------------------------------------------------------------------------------- Dim...

Hi All, I saw the earlier post of tying a sheet name to a Cell but I am creating a Macro that will take data and split it into 7 separate workbooks then take the data that is split and create new sheets that will sum up the data and add pivot tables to the data. This will all be done...

Hi everyone, I have a worksheet in which I am inserting a variable number of new sheets monthly. I need the inserted sheets to always start with Sheet1, Sheet2 etc for further code to work (if you inserted Sheet1 and deleted it, newly generated sheets would start numbering with Sheet2 unless...

Can anyone help me with an elegant solution for pointing at a spreadsheet name automatically? I have a few sheets called 1999, 2000, 2001 and so on and I would like to point to them from an ID list instead of writing the sheet's name Main sheet...

I get an excel workbook everyweek that has 7 sheets on it. The person that sends the file puts the name of the sheet and the date range (i.e. OutPatient 01-01-2011 - 01-08-2011) when I import this into access it creates a table based on the sheet name. I want to append the data so I need to...

Hi! I am desperate to find a solution for my Workbook, for which I need to create a macro. My problem is that i don't really have much experience with macros. I really hope you can help me! That's the situation: I am creating a summary sheet for a document with over 100 sheets with the...

Hi, I have a spreadsheet with around 200 sheets in, each sheet has a name containing a policy number and there is normally another small part such as 01-000. I have the following code: Sub FindPolicy() Dim SearchData As String SearchData = InputBox("Enter policy number here") If SearchData...

Good morning, I need a macro to combine multiple sheets into one combined sheet. I need it to only combine the Tabs that have "Debit Balance" in the name and move it into a sheet called "Debit Balance Summary" I am using Excel 2003. The active rows varies on all sheets but the columns remain...