Hi All, I Have a workbook where each tab is a different months report. Would like a print button on a menu that lets the user click and choose from the...

Hi all I am looking for a method where when you click on the cell it inputs a value or a symbol. It is for a spreadsheet which stores survey details. A user...

I have rows of data that are taking up two rows (when looking at the row number). For example, the first row of data has cells that are twice as high as a row,...

Hi. I have a spreadsheet with 7000 rows. I want to take cells from two of the rows and transpose the data into columns. No problem, I can do that. But I can...

Hello, I have 5 workbooks, each with one sheet, that contain purchasing information. The 5 workbooks are not in the same format since each type of purchase...

I'm comparing 2 values by saying =c1=c2 and it gives me a result of 1 or 0 instead of true or false. How did this happen? tia, Dave

I am trying to put a text background on a worksheet. How do I do this?

does anyone know how to set up excel in the way tat it will remember wat u hv keyed n will appear next time u type in th key word.. e.g type once singapore.....

Trying again: I created a Pivot Table in an Excel file sent to me by a co-worker. She sends a updated file each month with the same layout, and I use the...

Hello Gurus and newsgroup users. Your kind assistance please. For some time now I have been using Chip Pearsons code to return a list of file names within a...

While i m login through user login and try to open any old excel file its shawn that file not found and file not open, while i m open a new excel document its...

Okay i am going to try to best explain what i want to do, and ANY help that anyone might have will be AWESOME... Okay I my main worksheet serves as a form for...

Got a problem with opening existing files. They open without error but no cells are visable. Only the grey background. A new workbook will open fine. They...

I use excel to generate a report with multiple worksheets. What I need to do is have all the worksheet have the same header without having to "setup" each...

Ladies and Gentlemen: Why does this formula not work properly? =WORKDAY(A7,5+(MOD(A7,6)(10.5/24))) A7 cell contains a dd/mm/yy hh:mm format Basically if...

I need the data in my combo to be taken from the column headings in my spreadsheet, ie from a row. However i don't seem to be able to do this as it appears...

I have created a worksheet in Excel. It is very basic. I have added drop down lines and things such as that. I am looking to get more in depth. What I want...

I would like to be able to search a range of numbers to identify those amounts that total a given amount. There could even be multiple combinations that would...

I have a list of product ID's, problem is, the list has duplicates in it. I would like to have the list reduced so that each product number is listed only...

Can you write functions that will be available for whatever worksheet you happen to open. We have a date format from our AS/400 system and it gives us a...