Search results

Almost exactly what you are looking for http://www.excelfox.com/forum/f13/lock-cells-after-data-entered-132/

You could loop through each sheet and get the values to be uniquely listed in another range, and then use that as a source. When you say drop-down list, are you referring to the data validation drop-down list in a cell, or a drop-down control?

This should point you in the right direction

This should do Before Sheets.Copy, use something like this (I'm only taking one pivot table in to consideration, you can replicate it for others) Dim strSource1 As String strSource1 = Sheets("Details").PivotTables("PivotTable1").SourceData and just after the Next i...

1. Can you clarify exactly what your question is 2. Please wrap codes with code tags (Code)Your code here(/Code) replace the parenthesis with square brackets []

Excellent. But why didn't you give a look at Haseeb's latest post? I thought that was more straight-forward :)

I just realized that your data also has blank rows. Please remove those. If they are absolutely necessary, then you need to use this Sub MaxDatePivot() Dim pfiPivFldItem As PivotItem Dim dtmDate As Date With Worksheets("Sheet1").PivotTables(1) .PivotCache.Refresh...

Try this Sub MaxDatePivot() Dim pfiPivFldItem As PivotItem Dim dtmDate As Date With Worksheets("Sheet1").PivotTables(1) .PivotCache.Refresh .ClearAllFilters With .RowRange dtmDate = Evaluate("MAX(IF(ISNUMBER(" & .Address(0, 0) & ")," &...

This should help http://www.excelfox.com/forum/f2/vlookup-multiple-sheets-771/

This should give you what you are looking for http://www.excelfox.com/forum/f13/list-all-worksheet-names-using-formula-119/

All you need to do is copy and paste it to the code window of the sheet in which you need this done.

You can use the Shapes collection to hide the chart. So for example If Flag1=0 Then Shapes("NameOfChart1").Visible = False Else Shapes("NameOfChart1").Visible = False End if Having said that activesheet.ChartObjects("NameOfChart").visible=false works perfectly fine

In case you are finding it hard to figure out Narayan's VBA suggestion, this is what he meant Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range For Each rng In Target If Not IsEmpty(rng) Then rng.Value = Application.Proper(rng.Value)...

It denotes a very LARGE number ;) Lookup finds the largest number in the array, if all numbers are smaller than the lookup value itself. For example, =LOOKUP(100^100,{1,2,3,4,5,50},{10,12,14,16,18,20}) will return 20, while =LOOKUP(5,{1,2,3,4,5,50},{10,12,14,16,18,20}) will return 18. HTH

I ran the code, and I am not able to replicate that error. I am assuming it's because outlook got closed. Can anybody else test the code please? You just need to keep Outlook open, open a fresh workbook, and include the Outlook reference library, and run the code

OK, this is part of a solution I gave to another user elsewhere. You will notice that there are a few additional information, over what you need to fetch from your inbox. Moreover, I've also given an option to Select any folder in your inbox. You need to run this from the workbook where you...

By the way, my formula above could be made a little more shorter (assuming you're using an English version of Office) =SUMPRODUCT((TEXT(G7:G14,"MYYYY")="72013")*N(INDIRECT("R"&ROW(H7:H14)&"C"&COLUMN(H7:H14),))) Else, instead of MYYYY, use the appropriate alphabets for non-English

Paste this in the Sheet code module. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 5 Then With Me.UsedRange.Range("A1:B" & Me.UsedRange.Rows.Count) .Value2 = .Value2 End With End If End Sub

Clever one Haseeb. You've given two solutions by just typing down one. Here's the other one =SUMIF(G:G,"<="&A2,H:H)-SUMIF(G:G,"<"&A1,H:H)

Try this =COUNTIF(INDIRECT("'"&A1&"'!F4:F250"),"Pass") where A1 has the name of the sheet

You can create any xlsx file, and save it anywhere on a folder that is accessible to you. Just replace the path I entered above with the entire path and file name of your file

Try this =SUMPRODUCT((MONTH(G7:G14)=7)*(YEAR($G$7:$G$14)=2013)*N(INDIRECT("R"&ROW(H7:H14)&"C"&COLUMN(H7:H14),)))

Peter, I'm sure the developers trying to help you read that already. If there's something more you want to clarify, please do so. Not sure if copying the same post over adds any value.