I would like to import a pdf file into an Excel cell, kind of like a hyperlink, but I want to be able to see the pdf page in Excel, instead of just seeing...

How do I count data from one workbook to another? Thanks, Burt

I am using Excel 2007 and am trying to reference defined name ranges in a sumproduct formula. When I use the names the formula returns #N/A but when I...

Hi! Can someone help me apply a criteria to an MSQuery? I want to select same dd/mm records but for any year and can't figure out which operator to use and...

Hi there I am new to the community, but I hope to ask questions here often! I have one problem with Excel that has stumped me for sometime now. Every time I...

In one speadsheet only I select 1 cell and the 3 cells below it are also selected. Makes it hard to do anything.

I want col. "E" to count how often col "C" =24hrs for each of the 12 months A B C D ...

Hi, I have a sell which is in currency form A1= £200 I also have a cell showing a percentage B2= 2.24% I need a formula in Cell B3 that calculate 2.24% of...

Not sure if this is possible or not. Excel 2003. No VBA experience. B4:IS4 has daily production output numbers. I am using a formula like...

I have 4 rages of cells that if any cell in these ranges changes I would like to change the Background and Foreground colors. However I only want to change...

I have a number which was inputted as a date but came out as a number (1080022) I need to convert back to a date but can't figure out how to change it (...

i saw this post sometime ago and cut it out for future use. yesterday i was trying to test it out and the lookup solution doesn't work if B1 is blank. it...

Dear All, I am in filtered mode and a column cells contains formulae. while remain in filtered mode and copying all those filtered cell contains formulae and...

I am creating a simple pivot table with one field of values, numbers to be summed, and a second field, occasional two letter alpha codes which are...

I've tried the "GoTo" function and the "change column width" to unhide Column A, but that's not working. Any other suggestions?

Is there a way to conditional format a cell that does not have a formula. It does not matter what the formula is as long as it does not have one. I allow users...

I want to enter the Acces date with all respects in Excel Spread sheet.

I want cell A1 to be a drop down list that the user can select one from the list. In the list I want the following East Midlands Midlands Sussex How do I do...

Hi, I am preparing a template where there are few sheets having functionality of grouping and ungrouping of rows. I am using below code for protecting and is...

Hi, I have a table below. A B C D 1 East Midlands 90% 20% 2 ...