Control+D disable 3

[smiley0q0]

Is there any possible way to disable the control+D function in an excel spreadsheet?

heres what's going on...
got an employee that has a list of about [bold]20,000[\bold] invoice numbers, she gets a nice big stack put on her desk every month and what she does is a control+f to find the invoice then inputs the amount, then repeats process over and over and over and over again and again... yes, it's a very tedious monotonous process... anyway.. sometimes she gets fat fingers and hits the control+D without knowing and now there are 2 of the same invoice numbers and don't know which one she replaced over. or sometimes the amount is copied down, which if there wasn't anything there in the first place it wouldn't be so bad because she would eventually get to that invoice and put in the correct amount, but if she had already put an amount in there, she's screwed and the total is off and she has to try and figure out where and whats wrong...

wow... that was pretty long-winded and detailed.. sorry about that, but i just thought if i get the process of what shes doing, and we can't disable the control+D, then other ideas might surface...

thank you for all your help.

Smiley,

 

[Bowers74]

Have you ever considered using the Data->Form.. Tool in Excel?

Check it out, I think it would work perfect for what she is doing.

Select the top cell of the table and go to Data->Form...

Enjoy!



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[Adnane]

Didn't know it existed in Excel!

A very well deserved star Mike.


Adnane

http://www.microsoft.com/northafrica

 

[smiley0q0]

hey Mike,

Thanks for the quick response, I had never heard of this before.

just have a question about this form though...
as i'm testing it out before i go explain it to her...
I go to the criteria and type in the invoice she is looking for, hit enter... if it's below where i am at, it finds it just fine, but if the invoice number is above where my last one was, it won't find it, i have to hit "find previous" (alt+p) in order for it to find it. so if its above, have to hit alt+p, if its after hit alt+n...

any way other way to do this with as little keystrokes as possible? with invoice numbers like "3P9441M5", it would be hard to tell which is above or below where you are...


thanks,

smiley

 

[Bowers74]

Come on Smiley,

That's about as easy as it gets! ;-)



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[smiley0q0]

yeah, it is...

but the gal that does it only has a few brain cells to spare, i was just makeing sure i had covered everything before i go try to incorporate a "new concept" in her daily routine.

i do thank you for introducing me to this form thing, it looks like it can be a powerful tool in the right hands/fingers

k, looks like this is the best route to take. going over there now to introduce her to her new best friend.

thanks again mike.

Smiley

 

[Bowers74]

Glad I could help out!

Let's hope she gets the hang of it.

Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[DaleWatson123321]

Smiley,

Another option...

I've developed a file for you to consider.

After prompting for the Invoice Number, the data is filtered, so only the ONE record shows, and it takes the user to the input field.

If you email me, I'll send the file by return email.

Hope this can prove useful (perhaps a better alternative). At least it'll be interesting to compare the difference.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[smiley0q0]

Dale, just a quick question on your code... does it search the whole sheet or just one particular column?

by the way, your code looks fantastic and works beautifully.

runs like a champ.

smiley

 

[smiley0q0]

a star for you Dale.

thank you for your work on this.

Smiley.

 

[smiley0q0]

Dale,

somethings going on with hotmail right now... so i thought i'd post my response in here... and i guess publicly thank you.

This worksheet is perfect. Thank you for all of your hard work. I have tested and retested it to see if there is anything I would change, but came up with nothing, everything works perfectly. She is going to love this. If I could give you another star I would.

Thank you very much.

Mike, no offense, your idea was great and she did understand it and was able to work with it, but Dales worksheet is a little more of what she is used to seeing. but thank you for introducing the form to me, i will keep it in mind for other projects.

Smiley