Excel 2007: I need to have about 6 worksheets, all the same data, but all sorted differently & need to reference them often. How to I link all 6 so that any...

Hi I have a matrix (1000 * 60), and column H is numbered 1 to 1000 irregularly. I want to try copy and extract row for example number700 to sheet2 when i...

Hello All, First of all, my sincere apologies for having the clock on my computer set wrong. I was changing my clock to see if an Excel spreadsheet was...

Hello, I was using Excel Premium Solver with XP without problems. When we moved to the Vista platform, I re-installed the solver, but every time I try to run...

Dear all I have data that is more than 65k in notepad.Now i want to Export this data in excel, But when i Export this data it show the message (DATA...

I need to turn my spreadsheet to print horizantaly instead of vertical.

The control-page up or control-page down keyboard shortcuts do not work when the sheets are protected. How do you move from sheet to sheet within a workbook...

I am trying to operate on a data element in one worksheet that is contained in another worksheet.

Hello, I have a price list which includes Item #, cost, markup %, and price (approx. 300 products). Now, I want to add approx. 100 more products to the...

Is there a way to access the drawing tools option in excel 2007 for an excel 2003 template? All other functions work for the template-data enters and is...

Any way to encrypt simple ascii text in excel? I'd like to encrypt a large collection of war&peace length novels in excel if possible. You cant be too safe...

Need to generate a random number of either 0 or 1 but completely rounded, no decimal points just a whole number. thanks

I’m trying to summarise the number of NETWORKDAYS spent on projects by month. The data I have is as follows: (dates are in UK format) A ...

Good Day, I am trying to write a formula which would look down a row of cells and give me a count if the number is greater than x and less than Y. Every one...

Starting with $50. Contributing exactly $100 per month every month for 10 months Formula would be? using excel 97'

I use a spreadsheet to keep track of information. each piece of information has a cell next to it with the date it was entered. I want the program to...

i have an xlt. which is a "new customer" model and every new customer's .xls that is created, is saved in the "customers" folder. Every "customer.xls" has a...

Hi I have the following scenario: I have a set of individual sheet that represent sales data for each day (sheet named 1 to 31) I have a consolidation sheet...

=INT(0+(1-0+1)*RAND()) The "(1-0+1)" part makes no sense... how can I express the random formula in shortest form? =INT(0+(2)*RAND())??? I need a 1 or 0,...

I'm trying to take the top ten list of several people and want to find how they rank. For example: X received 2 first place votes, 2 second place votes and 1...