sheetname

Hi Guys, I am hoping someone can pin point what I am doing wrong here. I am trying to auto generate 31 sheets, each sheet is named numerically from 1-31 My issue is that every 10th sheet gives me a number that is not correct. The sheets end up getting labeled like the following. (sheets...

I always have problems with the ""'s in setting up the following link In my cell ref I have: F4 C:\Users\Owner\Documents\ExcelChest\ F20 MySourceWB.xlsx G20 Testing (My Sheetname) H20 A1 (contains text) This is my current attempt, which IS NOT working...

Hi, In a cell G19 I have the following to get the sheetname: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,20) The format type is General but all the sheetnames will be numbers. This sheetname value is manually entered into column A of a table on another sheet called 'Summary'...

I am trying to figure out how to create a dynamic dropdown of specific sheet names in a cell. Once a sheet name is selected, the data on the selected sheet will be used to populate the active worksheet. I would prefer not to use Data Validation. A user may create any number of sheets with...

trying to fill a range of blank cells with the name of the sheet that they are in. not sure why Range("ActiveSheet.Name") does not work? any help appreciated! Dim rng As Range Set rng = Range("B1:B100") For Each cell In rng If cell.Value <> "" Then cell.Offset(0, -1).Value =...

Hi all, I'm fairly new to VBA and trying to write some basic macros to reduce some drudgery when working with a few of our standard spreadsheets. As part of this I'm trying to create a new sheet which needs to be named based on data in 2 separate cells. The code is pretty basis but I can see...

The following code works OK - this essentially triggers an Essbase Zoom event on cell "A4" on worksheet "2. Retrieve": Declare Function EssVZoomIn Lib "ESSEXCLN.XLL" (ByVal sheetName As Variant, ByVal range As Variant, ByVal selection As Variant, ByVal level As Variant, ByVal across As Variant)...

All, Hope all is well. Cell A2 in Data 06/09/2017 has the date 06/09/2017. This date updates according to the current date or on adhoc basis. Tab Data 06/09/2017 has the data in a table. Tab Trend 06/09/2017 has a pivot table that updated according to the data 06/09/2017 Tomorrow i have to...

I couldn't find anything that seemed like it could help me. This is my problem if you choose to accept. I have a workbook of my products inventory. On the Cover sheet I have an array named Products first column is product code and the second is product description. <tbody> AA AB 1 100...

I have a sheet for each employee for example sheet2 is renamed JIM. In cell Sheet1 A2 I type Jim, in cell B2 I want a formula that will give me the data in cell JIM!B2. I tried =A2!B2 and =hyperlink(A2!B2) nothing works.

Try to explain this the best I can, and hope someone has an answer. I have a "master" sheet. It has formula that refers to particular cells in another sheet. I want to be able to have that formula use different cells depending on if it finds "text" in the sheet name. IE... I copy the master...

Hi Experts, Below is what I've tried to do across multiple worksheets in same workbook (except for Sheet1). The code supposed to insert additional column in each wsheet and put the wsheet name to all rows with data. Then after that need to find strip off the strings "N-" or "AT-" in that first...

I have a macro that calls a sheetname. When the macro runs: Sheets("Macros").Select the macro stops; I get : Run-time error '57121': Application-defined or object-defined error I checked for leading or lagging spaces in the sheetname. I tried renaming the sheet. I have the exact same...

I am trying to iterate through all my sheets (except a few) and for each sheet paste row by row data into the 'dashboard' sheet. I think I am close but code is a little stuck Sub Dashboard() 'dashboard population script follows Application.ScreenUpdating = False Dim ws As Worksheet...

Hi there, I have the following code which works perfectly to combine and stack multiple sheet column data (35 sheets) into one Master sheet. What I also need is for the name of each sheet to be copied down column A against each data block coming from a sheet. Below, it brings two columns of...

I want the user to input their own sheet name in cell E2. From there, the macro must be able to grab the value of the input into the code. Can anybody help me. Thank you in advance! this is the part that I'm stuck at :( Dim x As Workbook x.Sheets(Range(E2)).Rows(i).Columns("D")

I am trying to press a button on main sheet that looks across all my sheets and finds the last value in Col I and When that value is greater than 20 I want to copy that sheet name and paste into my main sheet I think I'm close but no error but nothing is being pasted... Dim...

Hello, I'd like to have a macro that can be applied to several different sheets in a few different workbooks. It should just add to sheet names the date in mmmdd format with a dash in front. That is, a sheet named "Risk" would become "Risk-Apr20" today. thanks!

Formula or VBA to match a Sheet name to a particular cell and if it matches do a SUMIF on the worksheet than matches it.<ins class="adsbygoogle" data-ad-client="ca-pub-2974935598394359" data-ad-slot="8003857391" data-adsbygoogle-status="done" style="text-decoration: none; display: inline-block...

Hi I am trying to create a formula to Match values in row 8 all of which are dates in this format - Jul-14, I have worksheets that are named by these dates too eg Jul-14, I want excel to see if there is a worksheet named what is in cell AA$8 and then if so, perform a SUMIF on that worksheet...