**-1**

votes

**0**answers

17 views

### HyperLink to Another WorkBook based on a cell value [on hold]

I have two Workbooks. WorkBookA.Sheet1 and WorkBookB.Sheet1
In WorkBookA.Sheet1 in cell S1 I have the value of US1000.
I would like to hyperlink to the cell containing the Value of US1000 found ...

**5**

votes

**3**answers

4k views

### Colour coding blocks of rows using conditional formatting

My macros have been taken away; never to be used again! I'm gutted. I now need to use formatting to help me highlight the different users and their data. Doing this manually is a chore.
Using Excel ...

**0**

votes

**0**answers

15 views

### Selecting random entries from lists in Excel with VBA

In Column A, I have n number of names.
In Column B, I have n number of Order numbers for each name.
In one cell I will be inputting the number of orders I want to pick randomly.
Once I input the ...

**-2**

votes

**1**answer

52 views

### Countif formula

I have dates in one column and names in the next column.
I want the formula to count the individuals as per the date. For example, on 10/1/2014, I want how many times the name Kiran is populated in ...

**0**

votes

**1**answer

26 views

### How to constant 0 in the range when the number is not inputed

In cell A1 I have number entered as 10. If I delete the number 10 from the cell A1 I want 0 to be constant in the cell A1 automatically instead of manual entry of 0?

**0**

votes

**1**answer

23 views

### In excel shared workbook can you insert data and not replace on conflict?

I have 2 users that asked for a shared excel workbook a while back.
Now after the holidays they complain that the workbook creates conflicts and that this issue never happened before. The file just ...

**2**

votes

**1**answer

817 views

### Why is Excel 2007 backwards?

I opened up Excel 2007 and this is what I see:
Where the row headings are on the right and the columns are backwards...
Does anyone know what is going on and how to fix it?

**0**

votes

**0**answers

9 views

### How to perform calculations based on multiple conditions involving current cell cell color and the value or color of other cells [on hold]

I have a color coded spreadsheet for rental properties that I downloaded from a software program. The spreadsheet basically has 3 colors, green means the property is booked, black means it is ...

**2**

votes

**5**answers

11k views

### How to stop Excel from formating the 16 digit account number in a way to avoid making the last digit zero?

I have large number of bank account numbers of different banks. Some banks account number start with zero and some have 16 digits. When I paste the data in Excel the leading zeros will be removed and ...

**1**

vote

**1**answer

3k views

### probable cause of excel files getting corrupted

how to find out the probable cause of corruption of excel files...here i m not saying of a single file...files are getting corrupted one after the other...can
1)using windows 8 with excel 2007 and ...

**3**

votes

**3**answers

14k views

### Microsoft-excel newlines and tab

Current I use "CONCATENATE" to join string in Excel, but I want insert character newlines and tab in string joined by "CONCATENATE".
Example:
I've string below when I completed join string.
"Today ...

**0**

votes

**3**answers

23 views

### Excel pivot and chart - hiding field from the chart

Hi have this pivot table
the pivot table is basically as follows
Project1 - 01/01/2010 | some data
Project2 - 01/06/2010 | some data
Project3 - 01/05/2010 | some data
Project4 - 01/04/2010 | some ...

**0**

votes

**1**answer

10k views

### Select Multiple Items from Excel Data Validation List

How can I set up the ability to chose more than one option for a data validation list and list them in one cell? So I have a validation list of A B C D. I want to chose A C D and have those three ...

**0**

votes

**1**answer

17 views

### Filter a pivot table based on the values in specific columns

I have a pivot table where there are multiple column labels:
group
subgroup
subsubgroup
status
The last label, status, has only two possible values, ACTIVE and DORMANT. I need to show only those ...

**0**

votes

**1**answer

14 views

### Excel formatting: how to format time periods?

I would like to format a time period like:
10:00 - 16:00
How do I?
And can I do it without dates?

**9**

votes

**2**answers

7k views

### Keyboard shortcut to switch between sheets in Excel

Does Excel 2007 have a keyboard shortcut that switchs between worksheets?

**0**

votes

**1**answer

9 views

### Conditional formatting, one Column based on another

Cells in column A will contain dates. There will be dates in column B as well. I need the cells in column B to turn red if the date is after that of column A.

**0**

votes

**0**answers

14 views

### Scores results needs updating as you type in the answer- excel lookup or similar [on hold]

I have a two tables the first is a table where results get typed into
Table Name Rounds
1 2 3 4 5 6 7 8 9 10
bonus Round played ...

**1**

vote

**1**answer

7k views

### Linking dropdown lists

I would want to link a drop-down list to the values of an adjacent cell. Let say, we have two cells A2 and B2. A2 is a drop-down list with values: Agric, school, sme and housing, while B2, which is ...

**0**

votes

**1**answer

23 views

### Double click on one cell to change text bold and font color of another cell on the same row

I have some code written that was given to me by another user, Twisty (who I seam unable to reply to in the page that was used), which is amazing and what I needed. However, I need it to do a little ...

**0**

votes

**0**answers

13 views

### Excel 2007 freezes hangs when I enter an email address

I don't know how this started. But anytime I enter an email address, excel freezes. It never responds no matter what option I choose.
I have tried it with one cell and nothing else. I have tried it in ...

**11**

votes

**3**answers

53k views

### Excel keyboard shortcut to copy/fill down for all cells with non-blank adjacent cells?

I'm looking for a keyboard shortcut that will duplicate the functionality available by double-clicking the "handle" in the bottom-right corner of a cell. Is there something that can do this, without ...

**1**

vote

**1**answer

5k views

### Automatic copy rows with matched column to other worksheet

Now I have a worksheet named sheet1 like the left side of image
I want to automatic copy all rows of sheet1 that have the column C = NO to worksheet sheet2 like the right side of image. And each ...

**1**

vote

**1**answer

24 views

### How to count number of unique buyers in excel? [closed]

I am creating a workbook for sold items of my company. and I have a list of items in column O of one of my sheets.
now I want excel to count the number of total buyers and number of unique buyers.
I ...

**1**

vote

**1**answer

32 views

### How to return a value from a range if cell contains that value

I have a list of Names (First and Surname) in A:A. I also have a range called 'Surnames'. How can I apply a formula so that B:B returns the surname only of A:A if that name is found in the range ...

**0**

votes

**1**answer

3k views

### How to Find and Replace worksheet name in a formula?

I have 100 worksheets with different names saved in a folder. I have another worksheet in another folder where I conduct analysis of data from one of those 100 worksheets. In this analysis worksheet, ...

**0**

votes

**1**answer

5k views

### Any trick to calculating percentages when the base is a negative number

I am trying to calculate percent change when the base number (at time 1) can be a negative and the resulting number is positive (at time 2). My problem is the percent change from -4 to +4. A change ...

**-2**

votes

**0**answers

14 views

### Excel 2007 VBA help requested for counting Yes/No

I hope someone can help me with this problem I have?
I have a text files that contain multiple columns. Two of the columns I have analyse the results of. My issue is that these two columns vary in ...

**1**

vote

**2**answers

20 views

### When I copy table data into excel, it ONLY pastes it into column A! How to fix this?

If I use the following link:
http://web.utk.edu/~dhouston/excel/exam1.pdf
to copy the table and paste it into excel, it will only paste the values into one long column in Column A (and each row has ...

**1**

vote

**1**answer

42 views

### excel vba userform/button coding

I have created a workbook in Excel. To navigate I have inserted a userform. I have code which takes me to a spreadsheet once a button is clicked on the userform.
Now I would like a button on the ...

**0**

votes

**1**answer

2k views

### Show or hide rows in an excel sheet subject to the value of a particular cell (excel 2007 & Windows 7)

I have made a spreadsheet to specify decoration selections from a range of standard options.
There are five separate ranges so this is the first selection then within each range there are additional ...

**0**

votes

**0**answers

26 views

### Excel error – command sending fails

Everytime I double click .xls file I get error window: "There was a problem sending the command to the program". There is no problem if I open the file by “File-Open” command..
I tried to copy and ...

**1**

vote

**1**answer

19 views

### Hide a number in excel 2007 spreadsheet

I am using excel for a mileage log. I want to be able to hide the "Daily Accumulated Odometer" number if there were no kilometers put on that day but still need that number to add to the next time i ...

**6**

votes

**3**answers

17k views

### Setting up a column of “enum”-fields in Excel

I'd like to setup a column in excel with several fixed possible values (like 'in-progress', 'done', 'canceled').
I'd like to set it up so the only possible values in these column are from the fixed ...

**0**

votes

**1**answer

3k views

### How do I get Excel to pull data from multiple workbooks from exact dates based on an entered date

I am running windows-7 and using Excel 2007 Enterprise.
I am a truck driver and need to catalog my pay based on a changing day to day system. I am paid per mile, per stop, per hour, or per flat rate ...

**5**

votes

**2**answers

4k views

### Importing multiline cells from csv file into excel

I have a csv file (comma delimited and quoted).
When csv file is opened directly from explorer excel correctly interprets the cells that are mutliline, but it messes up the character encoding (utf-8).
...

**-1**

votes

**0**answers

37 views

### Identifying and highlighting non-matching text across 2 columns

Hope you can help a first time poster (self taught at Excel).
I am working in Excel 2007 and have data in 2 columns (approx. 70000 rows) which contains details of 500 current & historical: ...

**0**

votes

**0**answers

15 views

### How to have excel 2007 userform stay on top of all other windows

The title says it all really. I have a modeless form generated in excel 2007 that'd ideally stay on top of all other windows (not just excel).
I know other applications can set this, but I'm unsure ...

**0**

votes

**3**answers

24k views

### Excel 2007 formulas not autofilling when I drag down

If you write a formula like:
=sumproduct((something=$A1)*(somethin=$B1))
Giving a result of 8. Usually the references and results change as you drag it down into other cells. Well,the references ...

**4**

votes

**2**answers

3k views

### Excel - Get rid of extra space in cell when using Text Wrap

When I type a long sentence (or more than one sentence) into more than one cell in a row, and apply the Text Wrap option to these cells, the cells have an extra blank line on the bottom of them. There ...

**3**

votes

**3**answers

8k views

### How can I insert the quoted price of gold from kitco.com into my excel spreadsheet?

kitco.com provides a realtime price quote for gold and other metals. I have a spreadsheet which makes calculations based on the price of gold and would like for this realtime value to automatically be ...

**2**

votes

**1**answer

23k views

### Excel: filter a column by more than two values

I have a worksheet with a column, user_ID, that contains a large number of user IDs
I'd like to filter it down to about a dozen IDs, but using Filter -> Custom Filter only allows me to filter by 2 ...

**2**

votes

**2**answers

4k views

### How can I refresh a document I have open in Excel in read-only mode?

I have an Excel document that is stored on a SharePoint Server, which I always have open on my computer in read-only mode because I need to refer to it.
Every so often, in order to get the latest ...

**0**

votes

**1**answer

4k views

### Copy/move values matching a pattern to another column

I have a worksheet where we need to move all the values matching a pattern to different columns.
For example, we have a B column with values that are one or more letters followed by one or more ...

**2**

votes

**4**answers

61 views

### Using COUNTIF in Excel to count number of “Greater than” values in an array of values

So here is my situation. I'm a principal creating a tracker for my teachers to use to track student growth on assessments. In the current tracker it is set up like this:
% of ...

**2**

votes

**2**answers

73 views

### Add button to copy Excel rows

I want to add a button on a row in a spreadsheet that copies the contents from one cell to another if and when I click the button. I already have found the code to do this, however, I want to be able ...

**0**

votes

**1**answer

2k views

### Excel - Displaying a value in a cell dependent on another cell having text

I have an excel file with 2 sheets. The first sheet is a user input sheet with cells that are properly formatted for us. The second sheet pulls the raw data into table format so that we can inport ...

**0**

votes

**0**answers

26 views

### Sharepoint Excel file synchronization

I recently found a problem with Sharepoint and Excel with concurrent changes:
Person A created an Excel file with, let say, 2k inputs and uploaded it to Sharepoint with website
Person B did not open ...

**0**

votes

**1**answer

39 views

### Drag a forumla, so that it increases by 17 each time

I have the following formula on the second sheet of my workbook. On my 'output' page, I want to display every 17th cell of the first sheet. However when I drag the formula down, it goes up in 2's. Any ...

**8**

votes

**4**answers

12k views

### Why does Excel 2007 changes the text “HSA”to “HAS”?

Working on Excel 2007 I am trying to populate a cell with the text HSA. However, when pressing enter, the text changes automatically to HAS.
I assume there is a kind of auto spelling correction here, ...