I want my file to use vlookup and pull data from the current worksheet but I also want to copy the formula to subsequent columns which represent dates (week...

I am trying to add a footer that shows when the last time the document was saved. Is there a way to do this?

Does =GetPivotData work in a reliable way????? I have an Access table of data relating to the current working days of the week (Mon to whatever day of the...

Hi, Sorry for posting this one again, but I had 2 questions in my last post and only one was answered. I thought my other question might be getting...

I have a worksheet that one of my sales people set up to track the materials for a job they are doing. They have seperated the various stages by highlighting...

I am trying to cap a cell that I use for discounts. eg the cell could read 35%, but I only want a max of 30% on some products I am using a cell to input a...

Hello, I have seen this done with conditional formatting, where the top ten values in a column are highlighted, But for the life of me I can not come up with...

Help please! I have a worksheet "receiving data" column1 state; column 2 city county name; column 3 gross (blank); column 4 tax(blank). I have a "data...

I copied some information from 2 sets of bank statements--"Bank Checks" and "Direct Deposits" (in Explorer web page form)--into a series of Excel...

How do I convert an entire column of text only email addresses to hyperlinks pointing to the same email address? Any help greatly appreciated

I was reading a post from Hope that was asking about password protecting individual worksheets in a spreadsheet to allow sales reps to only access their own...

Hello friends, I believe that the solution to my problem lies in the writing of an array formula; but since my creativity with writing array formula is very...

I have a user who would like t be able to select more that one from a drop down list. Is there a way to do this? I told her to create two cells and select one...

When I type a formula in the "true" value, the formula is displayed and not the result of the formula. Please advise how to ensure that the numerical result is...

Hi, Here's my situation: I have a workbook in which I'd like to reference a cell in another worksheet, but would like to increment the reference as I move...

how do I place the name of a sheet into a cell (on the same sheet...)?

I am trying to get the sytax right on a function that gets a value from a pivot table: =GETPIVOTDATA((cell("contents",a5))!B9,"Total Student Capacity") I...

Hi, Is there a way to have an if statement based on data type. Here is the equation I am using. =IF($F10="",E11,E11+F10) As you can see I can not add E11...

hi to all While feeding our production reports we can punch starting time & ending time ( Clock time ) of the activity & we want the time duration to...