Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by computerman29651

  1. computerman29651

    Copy Data from One Column to Another

    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.
  2. computerman29651

    Copy Data from One Column to Another

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

    Copy Data from One Column to Another

    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.
  4. computerman29651

    Copy Data from One Column to Another

    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...
  5. computerman29651

    Delete Entire Row

    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...
  6. computerman29651

    Delete Row

    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...
  7. computerman29651

    How to pull data from different fields onto the same line

    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...
  8. computerman29651

    How to pull data from different fields onto the same line

    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...
  9. computerman29651

    Macro in Excel

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

    Macro in Excel

    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
  11. computerman29651

    Crystal Formula

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

    Crystal Formula

    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...
  13. computerman29651

    Report Printing

    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...
  14. computerman29651

    Length of Comments

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

    MS Publisher 2003

    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?
See more

Part and Inventory Search

Back
Top