Search results for query: *

My VLOOKUP function seems to be giving me the results from the prior row. Here's what I have... 4 columns: Column A is my abbreviated states lookup value Column B is where I want my results displayed Columns C&D are my table array where I want the results to pull from column C So, here's my...

My company wants me to create a template for our corporate styles, mainly just setting it up for all employees to use the same font and paragraph style, etc. This needs to be done in Word and Outlook; I think I was able to accomplish this in Word using the normal.dot, however I'm still having...

This is a BIG and time consuming question, so any suggestions would be greatly appreciated. I've tried 2 different ways with my layout and calculations but neither way works for me, so I'm looking for suggestions on the following: Worksheet 1: purpose is to enter the monthy sales per customer...

I think I'm missing a very simple step but I'm just not seeing it... On Input sheet I have this: Column B Column C Row 13 | Combined Full Time | Row 14 | Combined Part Time | Row 15 | Total Combined | =SUM(C13:C14) skip a few rows Row 19 | EMR Full...

I had entered a column of states as the 2 letter abbreviated text. Is there a way to change that abbreviated text to actually spell out each state correctly?

We had a consultant produce an excel spreadsheet to help drive our 5 year financial. In one of the cells he uses this formula {=TABLE(,B7)} What does this mean? To give a bit more explaination, B7 = $1,568 Then where the above mentioned formula resides are the following info: $1,568 (D4)...

I've created this document that has multiple areas of numbering with 1. 2. 3, etc. and a. b. c. etc. I was able to restart numbering through numerous sections of my document, but for some reason there's this one section that refuses for me to right click and select "restart numbering". In this...

I'm at a loss with my query and don't know what to do; any suggestions would be greatly appreciated. Here's what I have: 1 table that consists of employee info, columns are Employee | Rate1 | Rate2 | Rate1 and Rate2 differentiates the salary after raises (hourly rates). Another table...

I have a formula question and would appreciate some assistance on this. I have a spreadsheet that tracks our company stocks. In particularly 1 column that has the number of stocks owned (number), and the other column how the stock was issued (text). I would like to have the cell F150 give me...

I am a beginner at FP so any help on this would be greatly apprecaited. This is for a simply "Intranet" setup through a network. I am trying to insert a database result from an excel spreadsheet into FP. I went through the wizard steps and it all seemed successful, but when I try saving the...

I have this idea to email specific records to a default email address, but I'm very new at this concept of using access to email records, so I will try and describe inasmuch detail as I can about my form to be emailed. I have a form called Investors and I use one tab to track basic Investor...

I have one access database that resides on a win 2k3 Domain Controller. 4 of my users are able to open the file with no problems. One user can not open the file, it says that the file may potentially be a virus. After that pop up you can click ok and the ACCESS begins to open then another...

I have a form that I would like to have the following capabilities: 1) Start out with no memo field on a tab, but the option (add button?) to add a new field for comments, possibly a popup field to enter the comments. 2) Once the comment is finished being typed, the user will click Save and...

I have 2 worksheets, worksheet A is a pivot table of how many hours each employee spent on projects, worksheet B is a 2-column worksheet with each employee's name and pay per hour. The spelling of each employee's name on both worksheets are exact. Is there a way for excel to... 1) perform a...

Hi, this is probably a very easy question with an easy solution, but I can't seem to get my calculations to work. I have a database spreadsheet that lists Customer, Project, Name of Employee, Date worked, Work Duration and Department. I want to create a pivot table that lets me know how many...

I have a worksheet that I would like to include a command button, which once clicked will clear only the unprotected cells on the worksheet. The unprotected cells are A9:I14, A16:I23 and A25:I28, and only column A have data validation, all others don't have any formula. Can this be done, and...

I have created a timesheet in Excel, and I would like for the spreadsheet to pull project numbers from an Access Databse. At first, I tried using the data validation function in Excel, but then I had to export the Access Data onto another spreadsheet for excel to query the project #s, and if...

I don't know if this is possible for Access to do, but I have 2 columns of data, one is the project #, the other is the project description. I know in MS Excel I am able to concatenate 2 columns of data into one, and I was curious if the same could be done in Access, and if so, how. Please let...

I have a computer with Windows XP that is on a network, which acts as our server where we store company documents, so that everyone can have access to the documents and does not require a password to access the shared drive. However, there are a few confidential folders that I would like to...

Recently I've been having a lot of virus emails sent with attachments. My NAV has quarantined the attachments which isn't a problem, however I would like to set up a rule to automatically filter these emails with certain keywords into my deleted folder. I was able to set up what I needed...