Search results for query: *

I created 2 worksheets. In the worksheet labeled address it has 3 cells that link to web address (i.e. CNN, JCREW). In the worksheet labeled Summary it has 3 cells that reference the cells in the address worksheet. This issue I have is that I want users to be able to click on the cells...

Hi All, Trying to convert 1.95 to months and days in excel. 1.95 = 23 months. Is there a formula I can use in excel? Cheers Thank You!

Hi All, I created a 9 box grid in excel. I want to count the cells that contain text in the box that run diagonally across the box. http://files.engineering.com/getfile.aspx?folder=3482f7d0-8493-464b-8739-fb38f5fcbca1&file=Worksheet.xlsx

Hi All, I need some help. I have a workbook with 3 worksheet. Two of the worksheet contains a table of information. The common column between the two worksheets is name. I would like to be able to search on the name column in both worksheets and return the row of information that is associated...

Hi All, I'm not an expert on VBA so I found this could this code online to split a word mail merge document & assign the filename based on a merge field name. It works perfectly except it adds extra lines of space in the merged documents. A 2 page document is now 5 pages because of the extra...

Hi All, I need some assistance. I have a table that contains the following information: Name Rating John High Jill Medium Kim High Mary Distinguish Clara...

I have a mail merge document where I have 2 sections in my form letter. There is a letter section appearing at the top and then I have data that needs to seen in a table format. Can this be accomplished through a mail merge by creating a table macro? So for every new record, a new record...

I've created a mail merge between our Oracle database and Word 2000. I need to place the merged data into a table. So that each record of information is surround by gridlines similiar to a table. Can this be accomplished without VB script because I'm not too familiar with it. I'd like lines...

I create several bar graphs in Crystal but the size of the chart comes across so small when I print it. Is there any way to make the chart fit the page. Thanks

I have a spreadsheet of information where I count the number of sales for each consumer product (i.e. TV, DVD etc.) in several countries. US JP AU FR KR TV 5 3 7 2 0 VCR 7 3 0 1 9 DVD 8 6 4 5...

Is there anyway to retrieve a .pst folder once it's been removed?

I've got a report where I'm trying to display the field where there is a checked box and if there isn't I want to print the words "No responsible employee identified" Each app has several employees working on it but only one is responsible for the entire app. The responsible employee has a...

There are two things I'm trying to accomplish. 1.Automate saving via a mail merge. 2.Ensure each document is saved automatically with a specified filename in specific location I have a mail merge set up between word and an Oracle database and it works fine. After I run my mail merge I will end...

Current Excel Spreadsheet App No Group1 Group2 Group3 1569A90 US FR 1569A91 FR US UK 1569A92 UK...

I'm tryiing to exclude cases where a certain criteria only exists. For example: Each application has several cases in it. Application number: APP100 contains the following cases: State Type NY PCT NJ PSP PA NP OR Application number: APP101 contains the following: State...

I have a word document that is 50 pages. I want to create an excel sheet where I place a hyperlink to a specific page in the word document rather than to the entire file. Can this be done?

I have the user place the letter X in each word table cell. I need to keep track of the number of x's the placed in each cell. I tried to use the count function =count(a1:a14,"x")and =countif(a1:a14,"x") and =count(above,"x") but none worked. What's wrong with my formula?

I'm trying to do two things: Turn on the tracking changes option and protect 2 section of my form when it is saved. Any suggestions, thanks.

I need to protect 75 word documents. I don't want to open each document one at a time. Is there a way to protect all the word documents at once. Thanks

My report is made up of 16 different subreports because each column (there are 16 columns) has a different criteria. It takes a very very very long time for the report to generate. Is there anyway I can improve the report performance? Would changing each column, that is each subreport, to a...