The formula that RagDyeR sent is working great, but now the users want to add .1000 to the formula and I'm not sure how to do this. The formula as it is...

2007 on Vista Haven't used excel much lately, so, forgive me please, I am a bit rusty I've got a list of data which I will be importing into my crm...

Just upgraded to Office 2007 and I can't seem to get Spellcheck to work in Excel. I have downloaded data from Access which is mostly text. Thanks,

I have 2 columns that I only have to input 2 characters in each column. ie 3d, ad. Is there a way to format the cells so that when the 2nd character is...

Is there a way to enter the week of the year and get the date of the year? week 2 would return January 6, 2008 week 10 would return March 2, 2008 Thanks for...

Hello, I need to sort two colums - one is a date - example 3/20/2008 04/5/2008 5/07/2008 and then another column of numbers -...

how to make quickly a bubble chart with 3 dimension. e.g. value (size of 1 bubble), meters (horizontal) and potention (vertical). And this for a database of...

I have a dynamic range which i use Range("A3").End(xlDown).Offset(-1, 0).Select to find the last cell with data in. Then i use ActiveCell.Resize(1,...

If A1=Date Reported, B2=Date Resolved, B3=Resolution Period What formular should I use to: 1) calculate the resolution period in days, excluding weekends and...

Is there a command to update data from one sheet to another when both sheets are located in two different places? I have a workbook that needs to be updated...

Does this community have a survey that I can take? -- raulmott

Hello, I have the following data (sample): Code , Code Description, Charges , Counter 1 ABC $20.00 1 ABC ...

I rewrote this post because I did not get any responces from the initial post and figured it was worth one more...

I have recently set up a time sheet for myself at work. At my last place you could click on a button called 'Annual Leave' or 'Bank Holiday' and the cells...

Hi.. I have data in 2 sheets which i want it to be displayed in the third sheet. Please suggest me how to proceed with this... ------**------ Example...

I'm trying to clean up .pdf data that was exported to Excel. The columns are a mess so I'm working left to right. I was hoping to create a macro that would...

I am working on a "charge sheet" for hospital use. So far, I have a pretty simple sheet that looks like this A B C ...