Recent content by dwayne94

Skip I think I am understanding the formula, but I need the formula to pull the numbers from the worksheet called DETAILED LIST. How would the formula look as the data is from the worksheet DETAILED LIST and being calulated in worksheet SUMMARY. Would I not have to incorporate the name of...

I was able to cut and paste but I need the worksheets to link up as it was before the spreadsheet was protected. Based on my info below how can I re create the formulas I have the data below from the worksheet DETAIL LIST Technician Name - Debra Moak Week Beginning - 5/18/2009 Region...

I have a spreadsheet that a previous employee did withthe same info, but the employee is no longer with the company. The spreadsheet is write-protected. When i tried to unlock it; it asked for a password. Unfortunately that employee refuses to give up the password. How to break the password...

No, I have not tried using a pivot table. Could I not create formulas to get the totals from one worksheet to another?

Skip, Another question, I have the data below from the worksheet DETAIL LIST Technician Name - Debra Moak Week Beginning - 5/18/2009 Region - SW Georgia Agency - GDC Metro Manager - Jeff Myers Date Event TimeTask DriveTime Total Miles 5/18/2009 Ticket...

I have a spreadsheet in place. I have a coulmn with the field name Event Descirption. I would like to know how do I create a box or a note that will show what type of info will be that particular column. In other words when anyone highlight that coulmn (Event Description)I want a box that...

Another Higgins/SkipVought - I was able to use Data Validation>Settings>List (not Customs) and that allowed me to add the items and see the items in the drop down list. What I would like to do is inj a cell type in DELL PFS and in the next cell have the same drop down list with the items to...

I am a little confused. Maybe this will help me. In my spreadsheet this is how it is set up: M N RCA 1 RCA 2 In cell M I want to type in DELL PFS and in cell N I have the option of picking one of the item from a drop down box: Tools Process Training Late Part Additional Parts...

I need help ASAP! I have two cells as follows: Cell A Cell B Dell PFS Tools Process Training Late Part Additional Parts Required Bandwidth If can write a formula as follows =IF(A1 = "DELL PFS"...

I have about five cells in a spreadsheet where I want to create a fraction. For instance I want to know how to write in a cell in this format 10/10 or 5/10 etc.?

Thanks that worked fine. One more question in addition to IF [SITE STATUS]="ON" Then display "Conflict w/ FA Master | Site Status ON" Otherwise display [FA Status] NewFAStatus: IIf([SITE STATUS]="ON","Conflict w/ FA Master | Site Status ON",[FA Status]) If want to add IF [SITE STATUS]="OFF"...

Is this for the Expression Builder in the query?? This is what I have FA STATUS: IIf([ZZ_DuplicatedFADeleteOutput(971)]![Usid(css)] In ([FA_Master_11i_FB]![SITE_CODE]) = "ON", "No Confllict w/ FA Master | Site Status ON", [FA Status] And [ZZ_DuplicateFAManualDeleteOutput]![Usid(css)] " "))

I have another question for you. In Access I have a query and I am trying to add a field. basically I am trying to write a code for the following scenario. I have a field name called SITE STATUS and it may be ON- OFF- PENDING or NO STATUS. I am trying to write a code in a Access query 1) If...

If Cell A is displaying street directions and I want Cell B to give me a value of true if there is anything in cell A how would I write the formula? So far I have =ISBLANK(A2). When I type that in I want to get back the value "TRUE" If there is nothing in CellA then I want to get the value...

How to create a formula in Excel that will give me certain characters? For instance if I have the city Alpharetta and I want to see the last 6 characters only how would I wirte the formula?