Hi, I have a workbook that contains three worksheets but i have hidden on worksheet (Sheet2) but i m retrieving data into sheet1 by formula, this workbook...

I created a macro and it works. How can I make sure only a few people can run the macro? I have a file that goes out to 30 people for budgets inputs. I...

I need to remove all the data in a woorksheet whithout removing the formulas in Exel 2007. I want to use the woorksheet for a new year

a

Greetings, My goal is to return a list of worksheet names on a sheet called "Summary". I have 30+ sheets. The first is Named "First" and the last is Named...

How can i remove single space between two values by putting formula ie 2 2 into 22.

Hi I am trying to create a time sheet. Where column A is the date (ddd, dd,mmm,yyyy) in column B I would like it to enter the time 9:15 (hh:mm) if the day...

I have Excel 2002. How do I add A1 + B1 * C1? When I put the formula in, it mulitplied A1 by C1 and added B1. Thanks, Suroor

I have the following columns Va2 177 V3 216.37 V3/rootT3 11.984 Q3 ? V3/rootT3=11.984 which is not in the table I need to retrieve the Q3 from a long...

What is the easiest formula to use when looking for duplicates in a column? Please and thank you.

I have worksheet which has many rows which I have grouped. I have protected the worksheet to allow users to only input data into particular cells. I would...

hi, I have 2 versions of a worksheet - both are very similar and have the same amount of records but there is a chunk of data in one column missing in one...

Hello, I created a table with a range of "A1:I6". In row 1 starting from A1 I have these titles: Team Play Win Draw Lose GF GA GD Points In column...

Hello, Cell A1 = YR (YYYY) A2= Month (M) 1-12 no leading zero A3= Day (D) 1-31 no leading zero A4= Hour (H) 1-24 no leading zero How do I create a date/time...

I have a column of data that contains text values such as "Branch" and "Branch Remote". I need to count the occurrances for each but my Branch count is...

I have the following numbers in column A 1 2 3 -2 -4 5 5 -10 3

I have a worksheet that has 8 tabs. Each row is a work order to do work in a building. Each tab has two or three buildings. I want to be able to calculate...

Hi, I would be gratefull for any help with the following Mon Mon Tues Tues Wd 1 A B A B A 2 dave Harry ...

hello I have 5 columns that I need to concatenate IF there is a value and if the value isnt already in the other cells i.e: A B C D E Concatenated...

Hello, I have columns of information like the one below on one worksheet. Based on certain criteria, I want to copy and paste these columns to another...