Hitting F2 followed by Enter changes the results of a formula in my worksheet. Hitting these 2 keys repeatedly, toggles between 2 results. It's like this: F2...

I am trying to find out a way to hide the procedures a macro goes through. In other words, I want the macro to run without the user seeing the screen flicker...

How do I populate 1 cell, say cell F45, with 25 SKU's with descriptions. Then, go back to cell F45, click on the down arrow to show all 25 SKUs, select one of...

User has an issue whenever she tries to type the word "an". For some reason the n keeps disappearing. Autocomplete is turned on and we tried turning it off to...

I want to calculate what seems like an easy formula. I'm developing a sheet that calculates driving time at a given speed. Column A is the hours driven...

Hi! I'm trying to find a formula to extract a total within each quarter without including the year, thus avoiding on a yearly basis updating the year within...

I would like to make a rotating schedule for our vbs. It would be for 3 hours a day. Each day being the same schedule. Time start would be 6:00 p.m. End...

Hi, This is what I would like to achieve, There will be sheet full of address details and in that I want to highlight the cells with some colour if the...

Hello, Need some assistance on the following: =IF(LEFT(D103,10)=LEFT(E103,10),"1","") D103 is a link to a MS Project file cell containing a date and time -...

Using XL 2000 How can I (1) reference a custom footer to a cell in the speadsheet? I would like to have in Left Footer - "prepared on" and in the center...

I am trying to create a spreadsheet for tracking items by barcode. For what ever reason, any number containing more than 15 numbers, excel changes all numbers...

When working in Excel is it possible to do either of the following things: 1) Have a template update date and time every time you open it, but then freeze...

Can I export Excel INTO Quikbooks? If so, how? I know Excel very well, but not Quikbooks. Thanks!

I have an application that requores that I use COUNTA over a column range that varies from spreadsheet to spreadsheet. Is there any way that I can incorporate...

Is it possible to add new XML Element, using Excel 2003?

Excel 2000 ... looking for Font List that will reflect corresponding Wingding symbols vs alphanumeric cell entry ... Thanks ... Kha

Dear All I have posted this question before but does anyone know of a workaround to access VBA running the above combination on a PC? Alt+F11 doesn't work...

Hi, I've got a column of data that has multiple values entered into the cells (derived from another formula) eg cell A2 has List Item 1 List Item 2 List Item...

I am using Office XP which inclued Excel 2002; my problem is my row/column formating will occasionally change without any input from me. I have several cells...

I have an excell spreadsheet that is used as an schedule. it was built using office 2003 and I could send it to the plotter using some modified changes. We...