I need to share a workbook with several people. The workbook will contain one worksheet where the user will be able to enter certain information....

Hi.., Is there a formula to enable me to copy just the numbers of a cell which also contains letters/characters (example Cell A1: FT’’/@12345’ ) All I...

how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? I am completely new to macro programming. After...

Excel2000 I've been scouring the archives for what I want and all posts seem to advise against it, but I want it!!! I have a workbook where each sheet has a...

We have a file clerk who likes to get on the computers (usually mine) during the lunch hour or after hours, is there anyway to lock my computer or at least...

Hi there, I am developing a spreadsheet that uses data validation and a chooser box to select Y or N and depending upon the result drops a value in the...

Hi,, I’m guessing this is an easy one for you folks in the know, I’ve looked at past posts but still confused..!! I’m using the following function (not...

In Cell A1 I have the which for example is 1-21-06. In Cell B1 I have the Weekday that represents, for this lets say it is number 7. In Cell C1 through C34 I...

How do you add two numbers in a cell without typing the equals operator first? I have a spreadsheet that allows me to add two numbers without typing the...

I'm using a VLOOKUP table with 26,000 six digit coded items. When I use format cells - text, it doesn't take until I actually double click on the "text" cell....

Hello.. I did post this question yesterday and following a fantastic response I thought I had it rapid up.. However the cool formula provided has a slight...

Dear All, I have a column in this Excel defined as Date format, "dd-MMM-yy" type. However, when I open the file, some cells have value...

I hav got the following numbers: A 45 54 12 32 55 78 65 45

vezerid, I can't get your formula to work properly. Should it be applied to a number already with a check digit in it? It didn't work on the following number...

I have a row of cells, for instance A1:BZ1, which can be blank or number. I am able to output the right most cell with the...

I am creating a timesheet (from a tutorial in a mag) and have the clock in time, clock out time and break. Clock in and out are times of the day - fine. The...

Hi How do i call the following code, but not get back any empty cells Set tempRange = Worksheets("Step Chart").Range("ColumnMapping") As it returns all the...

hello, Needing some direction. I have a relatively straight forward list of data within Excel, which is used to create some managment reports. The data is...

I am trying to set up an If, Then statement in which I reference a cell. The cell value can be a negative or positive number. For example: Column A is a...

I need to create a macro that you can input an amount of time into, say, 30 mins. that would pop up a dialog box that would have to be addressed...