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...
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...
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...
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...
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...
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...
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...
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...
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?
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
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...
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...
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...
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...
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...
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...
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...
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
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.