Search results for query: *

Hello! I am looking to create a button on my custom bar that once clicked will bring up a list. So, for example, if I hit Button1 then it will bring up a list with List1 and List2 which I will correspond to some macros that I have recorded.

Hi Geoff, The error message is: Unable to get the PivotTables property of the Worksheet class. On debug: ActiveSheet.PivotTables("MonthTable").AddFields RowFields:="Party", _ ColumnFields:="Type"

Hello, I have recorded three macros which create a pivot table one after the other on the sheet "Results". For some reason, sometimes it works and other times it crashes. I think it has something to do with the pivot table name - but I changed these. Here's my code: Sub CreateGrid()...

How can I do the following: If a user enters an age via a userform. I want to search through two columns, D & E. for that value. The best way is to run through both the list and if it equals that value, put a "YES" or "NO" in column F and then autofilter that column. So...

On my userform I have a box where the user has to enter a date in the following format: dd/mm/yy Is there any way to prompt the user to type in the date in that format, i.e. --/--/-- where the user can only type over the "--"?

Amazing! Thank You Geoff!

Would have thought that would work, but no luck Geoff.

Dim inDate As Date, low As Date, high As Date inDate = mydate.Value low = inDate - 1 high = inDate + 1 Selection.AutoFilter Field:=7, Criteria1:=&quot;>=&quot; & low, Operator:=xlAnd _ , Criteria2:=&quot;<=&quot; & high

Geoff, Perfect! Thank you. However, for some reason it seems to convert my date into American style, even though I put it as English. What can I do?

Hello! I am trying to use the autofilter with variables. Here's my code: Selection.AutoFilter Field:=7, Criteria1:=&quot;>=low&quot;, Operator:=xlAnd _ , Criteria2:=&quot;<=high&quot; low and high have values, but I am not sure where to put the &quot;&quot;. I tried taking them out but I get...

I am having many troubles with userforms! My second field on the form is called agedate. This needs to be in the format dd/mm/yyyy and depending on this date entered I want to search the worksheet (column D) for anything that has that date entered including 2 days either side. Is this...

Hi Jedi. Using your code I seem to get run time errors. I have put the code in UserForm_Initialize(). TimPair.Clear For Each r In Range(&quot;A6:A1000&quot;) If Rows(r.Row).EntireRow.Visible = True And Len(r.Value) > 0 Then TimPair.AddItem r.Value End If Next r TimPair is what I...

Thank You! This seems what I need. But for some reason I can't get it working. Where should I put the code? I have named my drop down list TimPairs.

Hello! I have created a userform for the first time and require some help. Firstly, how do I add data to the drop down list? Secondly, based on this selection how would I filter for that data (which is in column A). Thanks You!

Hello, I am new to XML and require some help. I have a txt document which is published to the web and would like to create a search facility. The txt document has about 20 columns. How would I go about doing something like this? And is XML the way to go? Thank You, Navvy

I have the following formula and I am trying to convert it into code using a do...while loop. The formula is: =IF(ISNUMBER(M1),MIN(ABS(LN(M1/N1)),ABS(LN(L1/N1))),ABS(LN(L1/N1)))*R1 I need this to calculate for all cells until the last empty cell is found and put the value in column D. I...

Hello! I am wondering if we can interpolate values given that we have certain values. For example: TODAY: 10 1 WEEK: 13 3 WEEKS: 18 7 WEEKS: 32 Say I wanted to find the value for 6 weeks (or any others), how could I do it? Thank You!

Geoff - one more question, sorry! How would I add another variable, for example I would like it to transfer both &quot;John&quot; and &quot;Tim&quot; records across to sheet1?

This is great! Thank You. One further question, Geoff. How would I move the entire row, which is from columns &quot;A&quot; to &quot;L&quot;?

Hello. I am trying to find a method whereby I can display certain information on one sheet from an entire list on another sheet. So, if I have the following list on &quot;Sheet2&quot; John 1234 abcd Tim 4345 jhgd John 8989 jwek John 4444 ouuu etc, etc The list on &quot;Sheet2&quot; is...