Replies

You could try a Index/Match type of command. It would look something like
=index(‘[Personel Info.xls]sheet1!A$1$D$200,match(a2,Personel Info.xls]sheet1!A$1$A$200,),match(“User Name”,Personel Info.xls]sheet1!A$1$D$1,)
The A2 cell is the Personnel Number you want to search for and “User Name” is the exact name of the coloumn that you want to find. This checks down col A to find a match for your Personnel Number and returns a row number, then searchs row 1 (or where ever your rows are located) and returns a coloumn number. The Index command then looks at the row and coloumn and returns the value in the cell the rest of the command is pointing too.
If I haven’t explained myself well enough and you find it confusing let me know and I’ll attach an example…I’m running late right now and don’t have time to put one together, but it is easier than what I’ve made it out to be.

HTH
Stats

Okay…so maybe I’m a little bias, I’ve used MS-Query (“Get External Data”) quite a bit and I have little experience with macros. Using the Query allows you to pull off the data any way you want using as many parameters as you want. I think it would be very useful if you are trying to get different data at different times, for example, you can use query to get all of the people over a certain age, with more than x in savings and a loan balance less than y.
If you need to pull the same data once or twice a month to update your records the Query will work well for that too. Each time you run the query (you can set it up to run every time the workbook is opened or just when you tell it to) it will copy adjacent coloumns containing formulas you require.
I’m sure the folks who are proficient at macros will say the same thing about their tools of choice but I find the Query to be very easy and quick to work with.

Stats

Hit the Start button…Programs…Admin Tools…Local Security Policy. In the tree that appears on the left double click Local Policy…User Rights Assignment. Near the bottom of the screen on the right you’ll see “Shut Down System” double click that.
You’ll see that all groups have permission to shut down the system, just remove the checkmark from the group that you do not want to be able to shut the system down.
Remeber if some users belong to more than one group they will still be able to shut down.
Good Luck
Stats

Thanks Hans,
Ive only just begun to learning about macros and I can’t thank you (and Legare, and Jan…….et al) enough for all the help you give us VB challenged folks.
Thanks Again
Stats

Thanks Legare!!
For my application your macro is going to work great, one quick question…Is there a way for the macro to print out a user defined number of copies? I tried ‘Worksheets(“Sheet2”).PrintOut Copies:=Sheet1!$b$5’ where the user has already entered into B5 the number of copies they want, but that didn’t work. Any ideas?
Thanks again for your help.
Stats

I too am having a similar problem. I have a server running Windows 2000 Server (with NTFS) and a user who was using Win 98 had a shared printer and another user running Win2K would print to that printer. Everything was fine until we upgraded the first user to 2000 Pro. Now when the second user tries to print he is asked for a password. He has to go into Netwrok Neighborhood, double click on the first user and enter her name and password in order for him to print. This works fine until he shuts his computer down. After startup he has to do this all over again.
P.S. After a the upgrade I reinstalled the driver onto both users and the server.
Thing darn things are certainly filled with magic aren’t they.
Stats

Thank you very much! Worked perfectly…I won’t tip my hat to you because you might see the bald spot from where I was pulling my hair out.

Stats

If you ever find yourself in Montreal (Quebec, Canada) the smoked meat sandwiches on rye (with a bit of hot mustard) are not to be missed. Sure there is pastrami or corned beef all over but they do it best . It’s been a couple of years since I’ve been there but I make a point of stopping for one whenever I’m near there.

Stats

Thank you very for your advise although it does raise the $64,000 question; which is better Windows 2000 Professional or XP?

Stats

The computer has Windows 95, it’s a three years old and it’s been acting up for about the last three months. She doesn’t know the processor or speed.
When she first asked about this I assumed (we all know where assuming gets us) that she would have Windows 98 at least, would you suggest going to Windows 2000 or XP first and see if that fixes things?

Good Day All,
First time I’ve checked this board, what a great idea!
Another unique recipe is throwing the turkey in a brine for 24 hours before cooking.
Brine:
1 cup salt
1 cup brown sugar
2 oranges, quartered
2 lemons, quartered
6 sprigs thyme
4 sprigs rosemary

To make the brining solution, dissolve the salt and sugar in 2 gallons of cold water in a non-reactive container (such as a clean bucket or large stockpot, or a clean, heavy-duty, plastic garbage bag.) Add the oranges, lemons, thyme, and rosemary.

I got this recipe off of foodtv.com and it is fantastic!!
Our Canadian Thanksgiving is in two weeks and this is what I’m cookin’.

Stats

Hello Cyberdance,
Could I trouble you to tell me how to password protect Outlook to prevent it from being opened by people other than the owner.
I appreciate any help you can give.
Stats

Good Afternoon Legare,
After trying all of the suggestions, I have found, for my needs, your example works best (as if there was a doubt). The other examples ran into a problem with duplicate subparts and your solution worked perfectly.
Thank you very much for your help (AGAIN!!).
Stats

Thank you very much to every body who took the time to help. You have given me a fair a mount of homework to see which works best. I’ll try all of the ideas out with the full version of my spread sheet to see which works best.
Thanks again for all of the valuable input.
Stats

Good Day Legare,
I’m sorry I should have been more clear, attached is a partial list of exactly what MS Query outputs. I have included three main Part Numbers in col A but there are over 500. What I’m trying to accomplish is to use this as a “database” and on another workbook have the user enter the part number they want and have Excel return all of the sub parts that go into making the main part.
I guess I should have put in the attachement in the first place.
I appreciate your help.