I need a User Defined Function that check if a number or string is 8 digits long and ends in "0000". If it meets the two creteria, then it should drop those...

How do I put a command so that i could select row 1 to row 8000 in a table that have more than 24000 row? The purpose is that I want to be able to select a...

I have a workbook containing a number of worksheets, some of which contain weekly data extracted from a database and which are regularly updated, and others...

Hi, Does anyone know how to adjust the width of some cells without altering the width of the entirm column? e.g. Cells A1-A20 need to be width 15, but...

I have a worksheet that looks something like this: A B C 1 $100 $50 $0 2 $150 $150 $75 3 $300 $200 $100 4 $200 $100 $0 5 $800 $700 $200 The...

Hi: I have a spreadsheet that is protected. In that spreadsheet, I also have three macros with corresponding buttons to run three different report (plus a...

I have a column D that has 2400 rows and is already populated with numeric values. I need to modify all the content of the D cells by adding the same alpha...

I am trying to chart two different statistics on one chart. One statistic ranges from 0 to 10, the other is typically over 10000. Because of the wide...

I want a formula that can count only text that are different but only one of similar texts, example: -nsk are 2 but the formula must count 1, -nsb is 1 then...

I am plotting two points on a primary and secondary Y axis using the cluster chart. One data series completely obscures the other. I've been playing with...

Good Day, Is there a way to get to a Combo Box without using the mouse? The user wants to enter data, but use the tab or enter key to move through the sheet...

Hello, I'm looking for an easy/automated way to take care of the following: I have single columns of varying size (meaning number of values in the column)...

I want to add the Mail Recipient button to the toolbar. I went to add buttons, customize and dragged it up to the toolbar. At that point it appears on the...

I'm working on a weigh loss chart where it will figure out the percentage lost each week. This is the formula I was given to...

I am trying to import a report from an accounting software to Excel 2003 and the field is 2P in SQL but when it gets to Excel it has the value of ..5833333+....

My husband is preparing a time sheet for his red cross duty hours but he can't change the time results i.e. 03:30 to show 03.5 can anyone help

Hello I have command button . what I want to do is; hide or unhide the sheet. If I select the button it should unhide the sheet, but if I select the...

Hi, I know that the 'MAX' formula can be used to look into a range and pick out the most recent date. Is it possible to use this formula to pick out the...

I create documents every day for about 100 users and I am trying to figure out how to modify a column. The column populates like this ToJo-8:05: or...

please help i have a petty cash workbook file where there is a new sheet generated via a macro for each day. the new sheet is generated by copying today's...