how to create the reference in one sheet so as to move clicking on the cell of the sheet it could move to another sheet of the excel file

Hello all: I would like to know, which formula do I use to get one less than the max in a list. For E.G. if I have in A1:F1 a list of numbers. How can I get...

I use vlookup to link multiple workbooks, sometimes the value dose not appear unless the source workbook is opened. It is very time consuming to open...

Example, 1st workbook pulls information from a 2nd workbook. So when that 2nd workbook is moved to another drive or folder, the 1st workbook that addresses...

need to know what the & symbol does in a formula? am doing a text formula and watching a tudor video can't understand what it does please write me...

Hello all: I would like to know how to make this calculation. Below is a list of products and types and prices. I would like to know how can I make that...

Hello, This is what I’m trying to do: I have 50+ worksheets within a single workbook. I am trying to gather specific data, by dates, and separate them by...

HELP!! I'm working on a project for my class and they want me to "test whether there is a value in a cell in order to sum it up" Add Invoice total +...

I’m using Excel 2007 for a spreadsheet of tiered rates on a savings account like below: A B C ...

I have a column of dates, and another filled with price. How can I sum up the prices for anything BEFORE a specific date? Help~~~

Can anyone help I trying to get a OR statement to work with and if statement... what I am trying to do is if cell K8 is = 2 and P8 is =1 mark cell j8 with...

my brain is not working today... we use two exams. the first one counts for 30% of their total grade, the second one counts for 70% of their total grade. ...

I am trying to set up conditional formatting on an existing Excel worksheet that has information in cells B1:F1 to B203:F203. What I want to happen is that...

I have a list that is tied to some external data. I want to be able to allow my users to begin typing the last name in the list box and search for the...

I have an inventory worksheet with A-E being descriptive values of an item, F being a column of what is in stock, G a column of how many items we need in...

Please help... This is the best way I can think of writing this out. IF column C has ID of 1234, & column D has a value of 4, give me the value of column...

I am trying to add another criteria to a "IF function" that isn't working. My current IF statement is: ...

First off thanks to everyone for their help over the past 2 weeks, I am almost at the end of the development of the guide I have another help request I am...

Hello After making a worksheet "VeryHidden" in VBE, I tried to protect this VBAProject with a password by going to VBAProjectProperties and select...

I am trying to set up conditional formatting so that it flags me when it is within 3 months & 1 month of a date. For example, I have a list of the dates...