# Tagged Questions

**-2**

votes

**0**answers

6 views

### If Statement between 2 worksheets

On Sheet two titled "Talents" cell b5 I need an if statement that does the following:
if cell b5 on sheet 1 titled coremembers has an x in the cell then cell b5 on sheet 2 titled talents is equal to ...

**0**

votes

**1**answer

9 views

### I want a shortcut in Excel to cells I have Hyperlinked

I've built a Series of Cells which wnen concateneted = HyperLink to a remote server. Excel Wk Sheet 2010 (File name changes Daily with date function or Date User inputs)
On the same Sheet I want to ...

**1**

vote

**1**answer

32 views

### VBA change Script on multiple tables

Via this forum I found a way to refresh autofilters in a table automatically after the data in a excel worksheet has changed, using this VBA script:
Private Sub Worksheet_Change(ByVal Target As ...

**0**

votes

**2**answers

477 views

### Excel: DD/MM/YYYY stored as text…need to convert to Date format

I have a slight problem. It would be easier to post an image but I can't because I don't have 10 reputation. Anyway I have a column with the heading "Birth Date", and dates entered in DD/MM/YYYY ...

**0**

votes

**1**answer

33 views

### Transpose data by checking similar cell data

I have a Excel sheet like below..
Color Size Qty
Red L 182
Red M 223
Red S 155
Red XS 30
Blue L 700
Blue M 845
Blue S 665
Blue ...

**-1**

votes

**1**answer

603 views

### How do I remove multiple page breaks between rows in excel 2010?

Multiple page breaks appeared between each row and column on an excel 2010 spreadsheet. How can they be removed?

**1**

vote

**0**answers

44 views

### Excel opens previous revision of file for a specific user

I have a user that opens an Excel file on the network and gets an older revision of the file. Everone else can open the file fine. this user received a new computer and new version of Excel (2010) ...

**1**

vote

**1**answer

67 views

### Excel_macro_pivot table_analyzing data

I have two problems with my data in Excel.
I have this table, so for every day in the year I have got 24 values, thatÂ´s 365 columns.
I need to write a macro, that transform the data vertically, ...

**0**

votes

**3**answers

3k views

### Microsoft Excel Formula - Highlight a cell based on text input in another

I have a table with a column B6 - B24. This contains company names.
Another column G6 - G24 with notes.
I would like a formula that would highlight a company name(column B) if the text "call off" ...

**0**

votes

**1**answer

67 views

### I want to calculate difference between higher date and lower date in excel where the dates are in two different rows having one common factor

Example:
Row A Row B
Col A: - AMS Alert 1-sep12 1-sep12
Col B: - AMS Alert 4-sep12 4-sep12
Now I want to calculate turn around time for task AMS Alert where I ...

**1**

vote

**3**answers

2k views

### How do I prefix a text to an Excel column? - all numbers are in rows

For example, if the number is 123456, I want it to become RNE123456.

**1**

vote

**2**answers

1k views

### How to report an excel bug to microsoft [closed]

Can some one give me a direct link to submit a bug on MS Excel 2010?