Is there a way to make this happen? The sections that I need to C&P are all the columns are 14 wide and the rows are 40, 41,44 and 65. How do I get these to...

I want to use my spreadsheet to create forms that have the information such as names addresses printed at the top.

I've googled n googled n searched but can not find the answer so I thought I'd ask. Does Excel 97 or later have a "this cell" type reference ability? By this...

Hi, hopefully someone can help me with the following problem. I have a workbook which has 5 worksheets of salesmans figures for the current month. I compare...

I have 2 columns of 80 rows of information that I would like to see "split up" into 3 sets of data across one page. How can I do this? TIA Mac

Is there a way to use a vlookup to look across multiple tabs within an excel file? Example Tab 1 contains sales data from salesmen in State A Salesman ...

If cell figure is less than 287 use a. if cell figure is between 287.01 & 400 use b if cell figure is over 400.01 use c. where a, b, & c are formula, should I...

I am trying to get a monthly payment figure by using the payment formula in excel. It always calculates the payment incorrectly. I try it on my financial...

I put a number into a cell click on the next cell and the first cell reverts to 0. If I format to number with 2 decimal places it will be ok but when I try to...

Hi Guys, Excel 2000. I have Cells B2 thru G2 available to be filled in with either a 1 or 0. Some of the cells are blank. I want to put a formula in cell...

I have my statement working OK, thanks to all. =INDEX($E$1:$E$62933,SMALL(IF($B$1:$B$62933=B62938,ROW($E$1:$E$62933)),$F$2)) When the name is not found in the...

Hello, Lets say for example I have a formula in row a1 and column a1 and some text in a1 and d1. What I would like to know how would I protected which I mean...

Hi everyone, I need help with autofill. The situation is that I have an excel spreadsheet that contain 2 worksheets: sheet1 and sheet2. The sheet1 basically...

I am trying to create an "IF" statement whose value is contingent upon a range of cells. Basically, I have 5 cells with 5 different dates. I also have a cell...

Hello Xcel spreadsheets Copied from User's Network Home Folder to Another Network Folder. copy \\network\home\userA\*x.s \\network\REPGROUP Getting "object...

I am a new user of excel. I'd like to set a column so the entry sets a decimel point for a money entry. I'd like to enter 12345 and have it show up as...

I have a database and i have a command button on the form. on click this opens a report for the specific client on the screen. it was working fine, but now...

Is it possible for letters to have a value ? E.G Imagine a blank cell. If i enter the letter M in it, i want the cell next to it to show the number 8. If i...

Is there a template for a Loan amortization Schedule where I can change the interest rate each time "prime" changes and there is only one payment on June 1st...

Hello, I hope I can explaine this well enough. I am using two worksheets. Worksheet 1 is an imported file, worksheet 2 is where all my calculations are getting...