I love the group by date function...I rely on it! but i often find it is greyed-out and not avialable to use for a variable, despite it being date data. Any...

In Print Preview / Page Setup, I set to fit in 1 page wide by 1 page tall. The worksheet is scaled correctly but the shapes did not scale down. I have set...

I have a list of invoices with the amount of each. I know how much a customer paid. He didn't give me the invoices he wanted to pay for. Given that I have...

Excel XP I have 2 columns First in A1 formatted to yellow fill if the value is "yes" and grey if value is "no" I have that done. No Problem Cell B1 is...

Hi How can I create a drop down list which is on a separate worksheet but in the same file? The name of the worksheet is Idaunits. And I want the drop down...

Can I import a large (794,000 rows) Excel 2007 file into Access 2003?

Further to the answer below, I need the following in one formula! Thank you for looking. If Cell A1(Text) = X or Y or Z and Cell B1 is Mon or Tue or Wed or...

Need to Look at a Military time entry and then compare with a Low and High entry then Average with other cells -- NedG

The subroutine did not run as I received the Macro Disabled message. I clicked OK, and next time I opened the workbook, I didn't get the Macro Warning, but...

is it possible to open a second workbook when i open another workbook

If Cell A1(Text) = X or Y or Z then multiply Cell C1(Number) with D1(£) into F1(£Total) but if Cell A1 = V then multiply C1 & E1(£) into F1(£Total)

como lo hago

i need help with excel 2003. i cannot scroll above A34. no scroll lock or hide or freeze please help!! -- iris

All, Is there any way to capture this data and consolidate the headers in Excel 2007. I would like to go from...

Hello, I have been working with the "Get External Data" Feature of excel and it works great for scraping HTML Tables from websites and linking to them in...

On the first tab of my spreadsheet, I'd like to calculate the weighted average of data on my 2nd tab. The 2nd tab is setup using "Row()" formulas, and has...

11.19.09 can the character limit on an excel cell be increased? there is a standard set up limit of 255 characters. that is too little amount. is there a...

I have this formula below that deals with finding calendar year. I need a formula that does the same thing but for Fiscal Year (7/1/09 - 6/30/10)....

Is there a piece of code someone could give me to make all my fonts in a workbook the same? this workbook has about 20 sheets and i don't want to go in and...