Recent content by computerman29651

Skip, I tried to replace the order of the assignment statement, but then I have to put in data that is found in column L. I want the formula to look at column E, and then copy data over from column L. Once again, thank you for all your help.

PHV, I am not sure what you are referring to here.... Have you tried the Find method of the Range object ?

Skip, I appreciate the help. The code you provided, takes what is in column E and replaces what is in column L. I would like it to do the opposite based on the information that is in column E.

I need a formula that will look in column E, find 'CO', and copy over the data that is in column L. If the data in column E does not equal 'CO', then I want to leave it alone. For example. Column E Column L 84 2.0 CO 1.0 55 3.0 CO...

I need a formula that will look for a certain word, and if that word is found, then delete the row. For Example: Column F Read (test) Write Talk (test) Run Walk (test) So, what I need is a formula that if (test) is found, then delete the entire row. If any additional information is needed...

I need a formula that will look for a certain word, and if that word is found, then delete the row. For Example: Column F Read (test) Write Talk (test) Run Walk (test) So, what I need is a formula that if (test) is found, then delete the entire row. If any additional information is needed...

What if the component I need is not at the beginning of the list or at the end of the list, but in the middle? For Example: Product Field Prices Field Apple 2.00 Grapes 1.50 Peaches 1.25 Oranges...

I am using Crystal 10 with Access I am going to do my best to explain what I want to do with a crystal report. I have a field named Product in crystal report, and I want to display the prices from different fields horizontally (side-to-side). For Example: Product Field...

I would like the third character changed to lower-case.

Does anyone know how to create a macro or some other way to change the appearance of text in a cell? For example: Original: 12HGT-T Changed To: 12hGT-T

hilfy, I had to modify the code just a little, but it worked perfectly. Thank you.

I need a crystal formula to calculate the next invoice number. As of right now, I have the following formula: PageNumber + {?Invoice Number} -1 What I need if a Sample ID (1234) continues for three pages with an Invoice Number 2560, I need the next Sample ID to have a Invoice Number 2561...

Is there away to setup crystal reports so that when you print a report, you can automatically print the same report with a watermark added? As of right, the original reports are being printed and then the I am having to go into the crystal report print properties to select the watermark, and...

Is there a formula that changes the length or style of comments on a crystal report? For Example: Comment: IIIIIIIIIIIIIIJJJJJJJJJJJJJJJJJJJJJKKKKKKKKKKKKKKKKK Comment: IIIIIIIIIII JJJJJJJJJJJ KKKKKKKKKKK

I am creating a webpage in MS Publisher 2003. I have a order form that I would like to automatically calculate the total. Will MS Publisher allow me to do this?