Please, how do I merge columns from two worksheets? Example: Worksheet 1 Worksheet 2 List Data1 List Data2 1 600 ...

The Trim function does not work. I tried reformatting the cell to all text, but it still won't remove the space between the letter and the number. Thanks

Hi there, this error seems simple enough--but it won't go away. THE ERROR: "Compile error in hidden module: TBRun9" The error appears when I open or when I...

Hi! I'm using the excellent code below (grabbed some weeks ago from this forum - thanks to those who wrote it!) and want to add another column of data to...

cell C19 = product code drop down list cells N1:O449 = description of prod associated w/ dropdown list cell E19 = product description column cell I19 = price...

I want to write a formula, say in cell E2 that picks the correct price based on valume Entered in Cell D1. Suppose I have a table set up with volume vs price....

When I have a formula entered in a cell I want the back ground to change to a color. How do I do that with conditional formatting or is there a different...

I have the following table with fields "Name", "State", and "price": Name State price Mary OH 14.94 Mary OH 15.01 Joe WA 12.17 Joe WA 18.95

I am having trouble converting a data type on a file that I received. It is supposed to display the date as mm/dd/yyyy, but it is formatted as a number. When...

Is it possible to have 2 or more hyperlinks in one cell. For example, if I have a 2 number list in a cell, and I want to link one number to a worksheet and the...

I am trying to find out the difference between two dates. I want it in number of years, they are all actually between 1 to 5 years only. Do I need to keep the...

Sorry for all the posts, but i just found this forum, and i have quite a few issued i've been "working around" rather than finding answers to. this forum is...

I am not sure how do nest several functions together. Which would go on the inside first? If I wanted several IF statements together, how would I do that? ...

By VBA, How to know User has selected one or several entire rows orther than some cells? --- Message posted from http://www.ExcelForum.com/

I could not reconcile GETPIVOTDATA with a date format criterion, so I changed the dates (I only need the month) to text, i.e., Nov 03. However, this does not...

I have a workbook that has 6 sets of worksheets - each for a different user. I have protection on each worksheet that limits access to a range of cells. How...

i'm trying to create error bars but i don't seem to have "selected data series" in my format menu. can anyone help?

About a month ago, I was using Excel, and closed the program in the normal manner and everything was fine. I tried to open the program about an hour later (not...

How do I create a non printing watermark in excel? I saw a worksheet with each page watermarked with Page # where # is the corresponding page in that...

Why won't a file (excel 97) from another PC open up and work on my laptop? I take a file from desktop PC to alptop (via a memory card) and double click on it...