My formula SUM(firstsheet:lastsheet) returns a #VALUE! error Why?

i am trying to recreate a record sheeti currently have a copy of but am having trouble doing so. like how do u have text go under each other in the same cell...

Another office phoned me about a problem they are having with excel. They had a large list of dates about 4600 columns long that were all displayed as one long...

OK, I created an Energy Balace Chart to help me eat healthier and track my daily progress. Everything works as designed except for my Grand Total column which...

I am trying to create a box plot in excel. My book says to go to tools and Data Analysis Plus. I have already added data analysis, but I have no Data analysis...

Hi- I've seen other people ask similar questions, but haven't seen an answer. I recorded a macro, and it has run fine dozens of times, but all of a sudden...

My goal is to set up a situation so that with a cell is merely touched/selected; it adds some values for reconciliation. My example has many complex...

I have created a form which the user adds data to, on a button click procedure I want the data to be check and then added to a spreadsheet. I dont know how I...

Can anyone help please. Column a has numbers 1 thru 311 Column b has the names of colours to match the numbers. What I need to do is to sort the names of...

WHEN i try to enter data nothing happen. Except at the botton of the screen where program messages are the word END is there. can someone tell me how to fix...

I need to make a graph with the Drug Concentration (mM) and the Percentage of Growth. I don't know how to make it!

I just installed this and tried to open the Financial Manager. A window pops up saying: "The macros in this project is disabled. Please refer to the online...

I have a stylesheet that contains "knowledges". The list looks something like: Knowledges: Accounting 14 Anthropology 25 Archeology 48 Art 35 Astronomy...

I'm new working with excel. When i open up the program I have the 3 worksheets, everyhting looks normal, except I can not enter any data at all. Most of the...

Hey All, I was wondering if anyone knew a way to have a drop down box that was populated by images instead of straight text. Anyone out there have...

Help please! Why am I getting a Runtime error 9 subscript out of range error on this statement? Workbooks("filename.xls").Worksheets("Sheet1").Select Many TIAs

I cant find a way to look up if a string of text exist within a cell and reply with TRUE or FALSE, such as "if "text" exist somewhere within "cell" then...

The Idea is that all players play once with each other & the scores are tabled showing which the best partnership/ players are - I'm stuffed !

I'm using an excel document and I want to use the Edit-Find feature to locate names within the document. I know the names are there because I've put them in...