Search results

Sorry, your requirements are not clear to me. Where do you want the 'list' to reside ? Apply to what cell ? The selected cell ? How is the Macro to be triggered ? Why don't you want to use validation ?

Oooo ! doing it yourself or supervising ? I have a friend who extended and got a 'moben' kitchen, 168 items on 'their' project managers snagging list, basically half had to be torn out, second time went VERY smoothly. Good luck !

Well, here you are Brian. I sort of cheated on both the solutions, the UDF above is still the best, I feel, as it makes no assumptions othar than code is allowed to run. I included two solutions, one that uses 1 helper column and one that does not. The second is a mother of all array formulas...

ADO is I believe the preferred weapon of choice, it's the most upto date and though DAO is still supported it is said that ADO is more resilient (don't quite know how that word applies, it either works or it doesn't). The issue is whether MS will continue to support DAO indefinitely, given MS...

Brian, you show me yours and I'll show you mine :D

to ... copy data FROM Access TO Excel using Excel OR copy data FROM Access TO Excel using Excel Yep that's a toughie :eek:

I could well be wrong though (it's not unusual !) post your version and we'll explore that option, having said that if we were allowed a hidden column I could do it with an array formula

Seeing as you were unclear about whether the extract numbers would be text or numbers I have done a solution based on numbers. It does appear to work with text but this has not been fully tested, I can not guarantee that this will continue to work on a large table. You were also unclear on how...

Okay, your extract number was a UDF using a vbscript object. You should not use UDF's on large sheets unless there is no alternative (they are bottlenecks and slow your spreadsheet down, especially when, like this, you are calling an external object. Native functions are ALWAYS faster). The...

Well I can write a UDF if necessary but what am I looking up given what criteria ???

All:- This almost makes sense but I just can't see what tanha is talking about. Can anyone else pick this up as I'm getting nowhere ?

Then you'd want =IF(A1>60,0,(60-A1)/30)

You are correct, the rules were set by the poster. ;) But financially it makes no sense as the timliness of (say) a loan repayment would have financial implications which can be calculated as a rate of return modified by this factor. The calculated factor above has but little resemblance to the...

Logic ? Explain it to me then, what makes 60 (i.e. double the time) worth 0 ? This is purely arbitrary. If normal is 100% and 0 is 200% then 60 should be 50%, 90 33% etc.

What attached ? EDIT: Ah I see it now ! :)

This is not a logical formula you are looking for here as if I take 90 days then is my timeliness -50% ? Is 'normal' time ALWAYS 30 days ? Will 0 days always be 200%, 30 days 100% and 60 days 0% ? If so then =(60-A1)/30 where A1 is your number of days

This is still less than clear. On "Max of Property" sheet (what is that supposed to mean ?) You enter Herat for row 6 an then enter "22", by this am I supposed to infer you want SPSS/AFG/HRT/FA00022 looking up on sheet "Inventory" ? then you want the quantity available for SPSS/AFG/HRT/FA00022...

Please give sample data for tests

And what about Herat and Kabul ? i.e. these are entered into your totals sheet but from where and how are they populated ? Edit: Without seeing some data I can't help, you have data, you know what it should look like and therefore if you give it me you will know if the answer is correct. (It...

Okay, First, don't send private messages requesting help on a current thread. What are your "two columns" ? are they not A & B ? What range do they actually cover ? I'll look at your attachement and see if it clears this up. Why do you have two headers ? What is "extract number" ? Where does...