worksheet name

I need to average a set of figures across multiple worksheets. In searching the net, I found a way to do this: =AVERAGE('Sheet1:Sheet10'!K5) This will average the contents of the K5 cell across the consecutive range of worksheets between Sheet1 and Sheet10. I am using sales data on worksheets...

None of my searches on the forum seemed to directly address my problem. Seems simple enough. I'm hoping it's just a syntax error, but can't seem to wrap my head around what I'm missing. In cell $A$1, I have a data validation, pull down menu with a listing of worksheets names contained within...

Hi, I have a excel sheet with names in range (A2:A11). 1. I'm looking for a vb script that creates a new excel sheet on my desktop. 2. The worksheets in the workbook should be named from the range i have in the excel. 3. Its not defined that i have 10 names in the range each time, so the...

Hi I'm creating a new sheet with my solver and I created a button to assign a name to the worksheet. If the new name already exists, I get a warning message, the macro fails and a new sheet called eg Sheet 1 is created. How can I write a "If" to warn the user he entered a name that...

Hi Forum members, Thanks for all the useful information I've used over the years. I'd like to know if there's a way to insert into a sheet the name of the worksheet that a cell formula refers to, and not the name of the worksheet the cell sits in. I've looked at many postings on inserting...

I am using the VLOOKUP function in a worksheet named REC-ISS in a workbook named EE-Cardex.xls. However, the Table Array to be referred is B22:P33 in different worksheets, in another workbook named MPR-Jun10.xls. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office"...

Hi Guys, I have already had some great help on this forum, but once again I am stuck and am hoping someone can help me. I have a spreadsheet with multiple worksheet names, I want to copy some data across from e.g. the last 5 worksheet to the first 5 worksheets. The complication is that the...

Is there a way I can grab multiple sheets that contain the same name (in this case "*Dec*") and copy into a new workbook? This is what I have so far but it copies the sheets into separate workbooks. Please help! Dim i As Integer Application.DisplayAlerts = False For i = Worksheets.Count...

Hello Everyone, I've been searching through the forums and have not found anything that will answer my question. I think the answer is probably fairly simply, but I have not been able to determine it on my own. I have not written in VB in years and this is the first time I have ever written...

Hi all you peoiple with real skills, I want to name a worksheet with todays date and have tried the following code only to get an error message saying "Object variable or With Block Variable not set". I am using Excel 2007 Dim WS As Worksheet Sheets("Goods Received").Select 'and...

I have a worksheet with 1208 is the name on its tab. I can do =1208!a1 on any other cell in the workbook except 1208!a1 and get an value. However, worksheets("1208").range("a1").select refuses to select that cell I thought maybe I'm messing some other portion of the code up so I tried...