Search results for query: *

Hello: Here is my problem: I have a pivot table that I want to be able to search for a specific value. The problem is my code takes a long time. Is there any way this can be coded so that it run faster. Here is the code that I have: Sub UniqueItem() 'This routine, uniqueItem, selects the name...

I need a formular that sums up the autofilter results. Can this be done using a formula or I need a macro or both?' I any ideas? I am running Office XP. Thanks... Moses

I have a solution to this one but I want to know if there is a better solution: I have a spreadsheet with this format: Codes Amount 1004 10 1005 20 1005 30 1006 10 1006 15 1008 15 1009 20 As you can see the are duplicates. In onther sheet, I have a series of codes like...

I have user who wants to calculate the number of years and months someone has been employed. This is what I had in mind. we would have a col with Hire Date, Today's and two more columns, one for years and one for months. TO find years, I used this formular: datedif(a2,b2,"Y") and it...

Hello: I have a user who has a form and he wants to be able to search is databse by last name. Let's say he wants to find mmsenda. What he wants is, when he types in mmsenda, the record will come up and not changing the value of this field. Any ideas? Thanks Moses

Hello: I have a use who wants to set defaults in R5. He wants to set the way his preview window looks and the width of the section that has his folders. Any ideas? Thanks in advance for your assistance. Moses

Hello: I have a user who is being asked to save Book1.xls when he tries to copy and paste an Excel object in Word. He opens up an file, by going to File --> Open --> select the file that he wants. In this file, he selects a number of cells and copy them. Opens Word, then go to Edit -->...

Hello: I have a database that has two tables, one tblCurrent and the other tblPrevious. Each of these tables has 10 identical fields. What I need to do is to check if there is anything that has changed from the previous table. So, I need a query that will display a datasheet of those fields...

Hello: My question is, is there a way of changing or editing the default workbook in Excel 2002. This would be the same thing like editing normal.dot in Word. Any ideas? Moses

I have a query that the following fields: Name Call Date ---- --------- mmsenda 2/28/02 mmsenda 5/3/02 mmsenda 6/05/02 john 6/05/02 john 7/05/02 mmsenda 8/05/03 When I create a report and group by name, it prints like this: mmsenda 2/28/02 5/3/02 6/05/02 8/05/03 John 6/05/02 7/05/02 Is...

I have a customer with a word form. What she wants to do is to link some of the fields and have the fields update automatically like in Excel when you link cells. Does anyone know how to get this done? Thanks for your input. mosmas

Here is what I need to accomplish: I have a spreadsheet with the UID numbers like this: UID 2/28/03 3/28/03 5/2/03 5/30/03 6/27/03 8/1/03 7162 0.1 0.8 0.9 0.8 0.8 0.9 On another worksheet, I have just the UIDs: UID 7162 6239 3309 I want lookup the UID and if it finds it, I want to add the...

I have a function in cell A2, let's say =($D$2/$C$2)*$C$2in my spreasheet, which work great.Here is my problem, if I insert an column before column B, my formula changes to =($C$2/$D$2)*$D$2. Is there any way I have the formula stay as =($D$2/$C$2)*$C$2 after insterting a column before the...

I have a user who wants to plot a 3-D graph in Excel with Z, Y amd Z axes. Is this possible? if so, how do we accomplish it? thanks. mosmas

I have a 'Container ID' column with the following information formated as text: 448846-1 448846-2 448846-3 448846-4 448846-5 448846-6 448846-7 448846-8 448846-9 448846-10 448846-11 448846-12 448846-13 448846-14 448846-15 448846-16 When I ran this query: SELECT * FROM [Product Inventory...

Hi: How do you 'stamp'or watermark a pdf doc. using Acrobat 5.0 Thanks. mosmas

Hi: Is there a way of setting the Header and Footer settings globally in Excel (97/200/2002). Specifically, I want to print the file name and the bottom of every spreadsheet that I have print out. Besides setting the Footer settings for each file, can I do it for the whole program, Excel...

Does any know the shortcut keys for "sticky space". This is a space that keeps a person's name or date from falling to two different lines. For example, if I have at the end of my line,26 January, 2001, I don't want these to be seperated, like having 2001 on the second line. Can...

Hello: is there a trick in printing activities in OL XP. When I open a contact, click on the Activities tab --> Print Preview, I am only getting the contact's basic information. Can someone help in printing activities. Thanks. Mosmas

Hello: Does anyone know how to customize the Numbers and Bullets in PowerPoint XP. I want to change the distance between the bullet and the text. I know how to do it in Word, I is this an option in PowerPoint. Thanks. Mosmas