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!

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

Search results for query: *

  • Users: TOTCOM11
  • Content: Threads
  • Order by date
  1. TOTCOM11

    ARE CASE STATEMENTS POSSIBLE TO POPULATE A CELL IN EXCEL???

    I have 3 items in a drop down in cell F9, BONE, TRIM, AND TIME. I am trying to get cell J22 to populate based on a lookup (which I currently have working) on different columns depending on what is in cell F9. I know how to do this using an IF Statement, but it can get very confusing to code...
  2. TOTCOM11

    Populating a cell in Excel based on another cell's information

    OK, let me do my best here to describe what I'm trying to do. I understand VBA coding in Access but not much in Excel. For what I'm trying to do on a whole Excel is a better venue for me to use. I have two worksheets in Excel and they are labeled as such: "Employee Evaluation Form" "Product...
  3. TOTCOM11

    Graphing Two Lines Simultaneously in Excel

    OK, here's my scenario: I have a list of products that I want to graph. I only want to graph one product at a time. Each product has two categories, QA Audits % and Yields. QA Audits and Yields are collected daily. Ultimately I would like to graph the product with the date being the X-Axis...
  4. TOTCOM11

    Using a cell to reference a particular worksheet in a workbook

    In MS Excel 2003, I have 10 worksheets plus one worksheet which I call an overview sheet. Each worksheet is labeled "Summary 1", "Summary 2", Summary 3", etc... On the overview sheet I have a bunch of cells that reference other cells on these sheets. I have a single cell in cell B11 that I...
  5. TOTCOM11

    Ranking columns based on two sets of numbers

    Here is my scenario: I am using an Excel Spreadsheet (Excel 2003). I have 10 columns with two rows each. For conversation sake I will call these rows Row 2 and Row 3. The columns are B-K. I want to insert a third row (which I already have done; Row 4) which ranks each column. Rows 2 and 3...
  6. TOTCOM11

    Counting number of cells with certain conditional formatting

    Using Excel, I am trying to store the number of times a certain condtional format happens into a cell. For example, let's say I'm looking at cells A1 through A10 and B1 through B10. I want to look at all of these cells and count the number of times there are bold formatting, and store that...
  7. TOTCOM11

    Counting number of cells with certain conditional formatting

    I am trying to store the number of times a certain condtional format happens into a cell. For example, let's say I'm looking at cells A1 through A10 and B1 through B10. I want to look at all of these cells and count the number of times there are bold formatting, and store that number in A12...
  8. TOTCOM11

    Conditional Formatting

    Is there a way to use IF THEN statements to execute formatting? Such as IF(C1=C2, fill cell with yellow, do nothing) or IF(C1=C2, make text in cell bold, do nothing). Basically I want to be able to format a cell depending on what a value in another cell is. Is this possible without using VBA...
  9. TOTCOM11

    Format a new external hard drive in NTFS preformatted in FAT32

    I just bought a Seagate 200GB external hard drive and I found out it has been pre-formatted in FAT32 format. I tried using XP utilities to try to format the hard drive to NTFS format, but it isn't working. The OS sees the drive, but it won't give me an option to format it. Any suggestions?
  10. TOTCOM11

    What is the easiest way to make an arrow?

    Hello Everyone, All I want to do is make an arrow that points to the southeast (bottom right hand corner). What is the easist way to do this since I don't see a template in Photoshop CS anywhere. Thanks, TOTCOM11
  11. TOTCOM11

    Easy Question of the Day: Make a Straight Dotted Line :)

    As the subject line says, this has GOT to be one of the easiest questions ever asked on this forum. ALL I want to accomplish is to make a straight dotted line from point A to point B, and I have no clue how to do it. I am using Photoshop CS, so if you could reference that version of Photoshop...
  12. TOTCOM11

    Delete Rows which have '*' in Column A

    I am importing a datasheet from a statistical software package into Excel. When I do this I get an astrisk in a cell which I no longer need. I want to write a macro which will delete any rows that have an astrisk in Column A. I'm so used to writing VBA for Access, that I don't know how to...
  13. TOTCOM11

    Loading Images in a Report Using Text Fields

    I have a product database that I have just successfully figured out how to link picture locations which are stored in text fields to image controls in a form. Now I am trying to do the same thing only in a report. If you are interested in how I came to my resolution for my form you can go to...
  14. TOTCOM11

    Displaying JPEGs in a form using directories stored in text fields

    I have a product database and would like to have up to three jpegs display for each product (each record). I am currently using Access Object Frames to display the jpegs from three text fields: Pic1, Pic2, and Pic3 (one for each possible picture). Some records may only display 1 or 2...
  15. TOTCOM11

    Storing Image Files via Text Box

    Hello, I am trying to store image files in my database. I have a maximum of three images that I would like to be seen. This is a product database so some products will have as many as three images, and some may have as few as one. The query which is the control source for my form has three...
  16. TOTCOM11

    Problems pasting a picture from MS Word into Adobe Photoshop CS

    I am fairly new to working with Photoshop CS. I am trying to paste a picture form a Microsoft Word document into a new document in Photoshop CS. When I do so, the picture pastes fine except that the image is very pixelated. What am I doing wrong? I know previous versions did not have this...
  17. TOTCOM11

    Invalid Argument Error When Pasting a Picture into a OLE Object Field

    I have a table with two fields. The first field is called "PictureID" and the second is called "Picture". I am trying to paste pictures into the field "Picture" from Adobe Photoshop. "Picture" is an OLE Object field and "PictureID" is an integer. I have been successful until now when I get...
  18. TOTCOM11

    Appending Pictures [OLE Objects] from one table to another (2nd Try)

    Does anyone know if it is possible to append pictures from one table to another (OLE Objects)? I'm having a few difficulties and could use a pointer or two. Thanks, Chris
  19. TOTCOM11

    Appending Pictures [OLE Objects] from one table to another

    I have two tables. One called tblPictureIndex and one called tblPictures. TblPictureIndex has the fields ProductID (Primary Key), PicID1, PicID2, PicID3, PICTURE1, PICTURE2, PICTURE3. TblPictures has the fields PictureID (Primary Key) and Picture. PICTURE1, PICTURE2, PICTURE3 and Picture are...
  20. TOTCOM11

    Cannot bring back "Welcome" screen

    I graduated from college in May and every since then I have not been able to bring back the Welcome screen that has icons for each person who has a signon for the computer. At school we had to have Novell installed on our PCs in order to log onto the school network. I uninstalled Novell and...

Part and Inventory Search

Back
Top