Search results

That's pretty much the definition of Autofilter, only records matching the criteria will show.

So you are just gonna ignore the questions I left you ?

No, I am confident you can do this by formula. Admittedly, I'll cheat, but then that's how I get the results :)

We're nearly there, "apple it" ? Why using "if" what does "if" give you ? if what ? How about just getting all those values dragged down on to sheet 2 i.e. A1 > A1, A5 > A2, A9 > A3 etc.

Can you give us an example of what the row numbers are and what column ? e.g. C6, C10, C14, C18 ... etc. What do you mean you want to "look at them" ??? add, average, max, min, what ??? You really should not use merged cells. In 99.9% of cases you can get away with centre across selection...

Sounds like a script is running when you start excel, try holding down shift whilst you start excel and see if it goes away. If it does you DO have a script and will need to loacte it to either correct it or remove it. It could be in your excel start-up area or in you personal workbook.

You can also specify which rows to import, say rows 320 - 41,000 or more typically you can serialy import large files 65k rows at a time.

No !

try index and match

What is "Cell("C8")" supposed to be ? I'd say you should use "Serial = Range("C8").value" and if you want the number printed out incrementing each time you will have to update it in the loop with "Range("C8").value = Serial" As an aside; don't use integers, use longs. Integers are not...

hmmm ! how 'bout that for a sense of community ...

The people on this board give of their free time to answer questions. We have other lives that must take priority, jobs to got to, families to spend time with, vacations to take, food to eat, bodies that need care and sleep ( :) ) etc. etc. Demanding answers to questions is NOT likely to get...

Application.username but it ain't foolproof.

No, I mean you don't need it as a column so we could get rid of it. I could still find the max. (Why don't you have a date aquired column instead). I'm saying this SHOULD be done in Access (or ANO DB), even if you don't have Access and want to use Excel.

So in summary you want the largest ending digits for any given type and location ? What if there are none for that location or type ? This does mean you will need an additional perameter. Seeing as it's done in a UDF I could rewrite the UDF to have say :- UMHMaxOfProperty_Type(Location, Type...

For your property number :- How may final digits do you ever expect to have ? Why is it not a consistent format ? Does it always/Will it always - have an FA before the number ? Why would you change a location code to have a number in it ?

Please stop with the Mr. bit okay ? it's just unmarkedhelicopter or UMH I'll have a look at the file and get back when I can.

It's do-able care to post some data and we'll see what can be done and without any code too.

You mean if one combo-box selection affected the list in another combo-box ? Like Countries and Cities ? box 1 has all the countries and box 2 has all the cities but if you pick (say) Portugal in box 1, then only Portuguese Cities are available in box 2 ?

I wouldn't put it in personal I'd put it in the actual workbook, specifically the worksheet concerned (so it's only for that worksheet (faster). I wouldn't have it as a function but as a sub. I hate volatile. I'd call it from worksheet change event if the change was from the required sheet and...