I have two worksheet on the same workbook called sheet1 and sheet2. I want data entered on sheet1 to automatically show on sheet2. Example. "Sheet1" ...

This has more to do with formatting a text string, but how do i format a column that already has data in it using "=TEXT(A1,"@")"? This is the only way i...

I have two distinctly different workbooks. I am trying to grab information from one workbook and enter it into another. I need the workbook B to look for...

Hi all, I used an example to explain my problem I have data (plant/car) in column A in sheet 1, I want to have specific data in sheet2 (only car) without...

USERS CODE 1 MONTHLY CODE 2 3 PTMS CODE 3 ANNUAL 1 1 197 2 667 3 1597 2 1 167 ...

I have column that contain names both first and last name. I want to break this to different column that will seperate First name on its own column and last...

I have an excel sheet that has lists of categories and several selections for each. I use a Filter to select only the rows with a "X" in column J. I want the...

The cells in a SUM formula all include formulas that provide the cells with negative numbers, positive numbers and blank cells. Need to have the respective...

I need to retrieve a character value from a given position within a text string, how would I do that? For example, I want to pull the value of the 4th...

Hi I have a 2 column table I want to use as a lookup table; one column showing all the company's employee names (last then first in one cell but no middle...

One of my conditional formatting rules is as follows: If value of the cell is between 4.5 and 5.0 then format the cell "green". The problem is the formula...

I dont know if this can be done but how can I do this.... let's say in cell A1 I have the value "John" cell B1 I have the value "Smith" Can I write a formula...

I am needing to get a function to do the following: Look down a column(A) for any blank cell, then for that blank cell look in the cell to the right in...

=IF(ISERROR(FORECAST(COLUMN(),$AF4:AH4,(COLUMN($AF1:AH1)))),"",FORECAST(COLUMN(),$AF4:AH4,(COLUMN($AF1:AH1)))) I have this formula in my worksheet but a...

I have made a document full of macros and protected the cells to prevent anyone writing over the formulae. I need to use the group function for some of the...

I have a workbook with multiple sheets. On one sheet, I have a cell where I manually change the contents from 1 to 12 (corresponding to months of the year)....

Is it possible to get access to data appearing on the auto filter dropdown lists which show at the top of the filtered range? Would it be possible to control...

I need to add 2 weeks to a date and round it up to the last day of the month. G11: 6/15/2009 Add 2 weeks, but round to 6/30/2009 If I add 14 days to...

can vlookup be used to find multiple matches in a table on sheet 2 for a single index number on sheet 1?

I have three columns, A, B and C, I need a quick analysis / IF statement to determine: If A is between B and C,"A IS GOOD" If A is below B, "INCREASE A" If A...