**0**

votes

**0**answers

6 views

### How to Run macro in excel instance “2” from excel instance “1”

Lets say i have already opened Workbook 1 in Excel instance 1 and Workbook 2 in excel instance 2
And i have macro called "AAA" in instance 1 and "ASD" in instance 2
i want to call "ASD" in instance 2 ...

**0**

votes

**1**answer

17 views

### Excel macro to save workbook on another session of excel

Im trying to make a macro in one session of excel that saves a particular workbook in another session of excel.
Lets say i have Workbook1 and Workbook2 and i have opened them in different excel ...

**1**

vote

**3**answers

39 views

### IF formula returns wrong value

https://www.dropbox.com/s/v6nd2z4icftmnvf/example1.xlsx
We have Excel 2007 (German) and vista ultimate.
I am trying Excel by building a roster but have run into a problem with the following formula.
...

**1**

vote

**1**answer

14 views

### Comment in fixed line in Excel gets truncated when I scroll down

I have an Excel sheet with a fixed header (first row is fixed) and some of the cells in this header contain comments. When I don't scroll down and hover over the cell, the comment is fully visible, ...

**0**

votes

**1**answer

18 views

### Nvidia How to display particular workbook of Excel file on TV and no matter what i do on the computer the TV displays the workbook

Basically i have a computer and a TV.I want to display particular workbook of excel file on the TV ( monitor 2 ) and when i work on my computer monitor ( Monitor 1 ) nothing happens on Monitor 2.I ...

**0**

votes

**1**answer

16 views

### Excel: Find a specific cell and paste the value from a control cell into it

I have two columns one containing the room number, e.g. B-CL102, the other containing a varying integer.
I want to enter a different, manually determined, integer in a third column.
Whether by macro ...

**0**

votes

**1**answer

12 views

### Can I use excel to read barcodes and take me to a specific cell?

I work for a community group that holds an annual fund raiser for charity over a weekend. I am an excel user and am wanting to set it up so that I can assign a barcode on a card to a specific person. ...

**1**

vote

**0**answers

17 views

### Getting Excel to “update” or “follow” a linked Access table?

I'm using Excel and Access 2007. I'm having an issue at work and my current knowledge of Access and Excel isn't enough. I have an Access database that has certain data in it. I have an Excel ...

**1**

vote

**0**answers

18 views

### Align column of numbers, negative numbers, decimals and percentages in Excel

My list of numbers contains the following:
48.8
4.19
(0.36)
4.52%
and I want them all to align by decimal. As far as I can tell it is not possible in a single step and the best I can do is paste ...

**1**

vote

**1**answer

21 views

### VBA + Polymorphism: Override worksheet functions from 3rd party

my company makes extensive use of a data provider using a (closed source) VBA plugin. In principal, every query follows follows a certain structure:
Fill one cell with a formula, where arguments to ...

**2**

votes

**1**answer

21 views

### Create a linear trend line in Excel graphs with logarithmic scale

I I have an Excel scatter chart with x and y values.
I set the logarithmic scale in x-axis and y-axis.
When I add a linear trend line to the graph, the line is not linear but appears like a curve.
...

**0**

votes

**0**answers

22 views

### Macro to copy values to new sheet and prompt user where they want to save

I'm looking to create a macro in Excel 2007 which will do the following:
copy the formatting and values from a sheet called 'report',
insert this into a new workbook, naming the file with the value ...

**0**

votes

**1**answer

13 views

### Adding a Custom List to Cells in Excel 2007

I have gone through the tutorial on how to create a custom list, but it doesn't say how to add it to the cell.
What I want to do is to add a listbox to a cell:
i.e.
Cell A1 has a drop down button ...

**0**

votes

**1**answer

21 views

### Excel: how to link cell from one sheet to another

could you please, help me?
i would like to find out how to do this:
i have a sheet 1: with columns: number, name, color.
i would like on sheet 2 to have 3 cells, where after entering the number, two ...

**0**

votes

**1**answer

23 views

### How do you add text to the end of a cell in Excel

I am wanting to add the same text to the end of about 10,000 cells, but I don't want to go through and manually type it in on every cell.
So basically, I want to:
A1 A5
text =A1+"file"
...

**0**

votes

**0**answers

10 views

### Excel 2007 : paste from clipboard to visible rows only

What I want to do is to copy multiple lines from a .txt file and paste it into an excel sheet that have hidden rows. Each line on my text file is correlated to the same visible row on the excel sheet.
...

**0**

votes

**2**answers

26 views

### Excel: Random select within table that meets two criteria

Here is an example of my data:
Name: Office: Years:
John Smith Canada 1
Bob Smith Canada 1
Jake Smith Canada 1
Sarah Smith Canada 1
On another sheet I want ...

**-2**

votes

**1**answer

32 views

### sum the values in a column and add the sum to the filename of a workbook

Hello I have been able to create new worksheets based on unique values in a column. In addition to this, i want to sum up the values in a column and include this sum in the filename of each ...

**0**

votes

**1**answer

28 views

### Excel: Copying web table or saner way of merging cells?

I have an issue where copying information from a table in a web page to Excel doesn't copy the headers cleanly. The headers look something like this:
# Line Part Part Description List
...

**0**

votes

**0**answers

23 views

### Dynamic Excel page with many referances

I want to build a dynamic spreadsheet. I have a blank template for entering weekly information about different locations. Once this information is inputted it is saved as a new sheet and titled for ...

**0**

votes

**1**answer

25 views

### Copying VLOOKUP formula in multiple sheets, where sheet number automatically changes

I have created a progress card in Excel (there are 50 such sheets, one each for 50 students). There is one tabulation sheet also with the names of the 50 students. So, when numeric marks are entered ...

**0**

votes

**0**answers

25 views

### Go to first non-negative cell in a row and divide by another cell

I'm looking to have Excel calculate the financial payback period for me.
In words, I'm trying to count and return the first non-negative number in a row and divide that value by a corresponding cell.
...

**0**

votes

**1**answer

21 views

### Excel date format transposing numbers

How to stop excel changing date format?
I type in 05/11/2014 as in fifth November and it displays 11 May 2014 in the cell
Yet in the cell content line at the top of the sheet it still displays ...

**0**

votes

**0**answers

31 views

### Excel 2010 Compile Data from Multiple Worksheets into Summary Spreadsheet

I've compile a structural steel and architectural finishes material take off for an industrial building.
I simply tallied the quantity of each length of each shape on a sheet corresponding to each ...

**0**

votes

**1**answer

15 views

### Adding a Hyperlink in Excel 2007 With Domain in Different Cell

I want to add a hyperlink in a cell, but getting the domain from a different cell.
For example:
A1 = localhost
B3 = http://(A1)/test.htm
So I can change A1 to point to an IP address.
Is this ...

**1**

vote

**1**answer

51 views

### How to convert dd.mm.yyyy date format to yyyy-mm-dd in Excel 2007?

My customer entered date in dd.mm.yyyy format. As I want insert all the data in mysql database, I want the date in yyyy-mm-dd format.
I tried to format using Excel custom date format and built-in ...

**0**

votes

**1**answer

38 views

### Excel cells- show displayed text instead of value in Data Validation list

I read this topic: Excel cells - show text different to the actual value?, and now I'm trying to use it as a Data Validation list in Excel.
But when I choose for the list those cells, when I choose ...

**0**

votes

**1**answer

23 views

### excel text to specific cell

so i have this problem i want to get a specific cell from text i mean that
i have made a table 1,2,3... A,B,C,....
i made a vlookup to search for specific letter in number so if i press 1 in a A3 it ...

**0**

votes

**0**answers

7 views

### Excel group files not opening

The OS is Windows XP 2003 server and the program is Microsoft Office Standard 2007 (Excel). This computer recently upgraded from Office 2003 to Office 2007.
Upon clicking any .xls or .xlsx book file ...

**0**

votes

**1**answer

34 views

### Excel - Counting unique values with multiple criterias

I have a large scale data set and I am looking for a way to count the number of unique values:
Day -ID, Location-ID, Truck-ID
1, 18, 1
1, 19, 1
...

**0**

votes

**1**answer

19 views

### Replace two numbers in a column with 99

I have Selling Price which is not in proper format as its converted from Dollar to our local currency.
So the amount in the column are ending with random number. I want to change last two numbers to ...

**2**

votes

**1**answer

46 views

### How to create a stacked bar chart that displays data in monthly intervals?

I have a table with dates and prices, and I want to create a bar chart, which shows me total amount spent in months. Table looks like this:
30.5.2014 700,80 CZK
6.6.2014 1 000,30 CZK
20.6.2014 ...

**0**

votes

**2**answers

48 views

### How do I categorize a list?

I'm looking to categorize/sort a list by matching certain strings. I previously couldn't find a solution so hopefully this way is easier.
Example list:
[A]
The apple is the pomaceous fruit of the ...

**0**

votes

**0**answers

30 views

### Excel Table Copy Wrong Formula with Newly Inserted Rows?

I am trying to create a simple spreadsheet to track costs. I have a total of five columns with different categories, two of which have formulas. I wanted to be able to insert a new row into the ...

**0**

votes

**2**answers

31 views

### Text function in Excel isn't formatting year

I've got a problem with the text function in Excel (2007).
It doesn't format the year, it just states yyyy instead of e.g. 2014.
If I have a cell with 23-7-2014 and use the formula ...

**0**

votes

**0**answers

39 views

### Microsoft Excel 2007 - Auto Update in 1st Sheet based on What updated in 2nd sheet (2nd sheet Update will be in Fixed Column but Random Row)

Actually I'm facing a problem now.
I am using Excel 2007.
And, I have two different sheet of excel file with me.
My 1st sheet is my report.
My 2nd sheet is my customer name.
I hope that when ever ...

**1**

vote

**0**answers

54 views

### vlookup in a cell that contains mid formula

I am trying to create a vlookup in a cell referencing a specific cell so that I can pull the data from my lookup table. Well this cell that I am referencing happens to have a mid formula in it, and ...

**1**

vote

**1**answer

18 views

### How to remove one column of a calculated item in Pivot?

I have two columns. One with data from this year and the other with data from previous year. I now have added a calculated item in Pivot to display the % delta of these two years. Now when doing this ...

**0**

votes

**2**answers

38 views

### Comparing two columns in excel to find non-duplicates

I have two columns of numbers, column A and column B. Column A is where a numbered tag is entered when it leaves and Column B is where the numbered tag is entered when it returns. There are spaces in ...

**0**

votes

**0**answers

26 views

### How to Group and Layout Pivot Table when Values is in the Row Labels Field?

I'm attempting to present large amounts of data in a report using a Pivot Table to allow for dynamic filtering/categorization. The data in the table is of the form:
Year Month Category Region ...

**1**

vote

**2**answers

21 views

### Single formula to search column and return corresponding fields

Am having issues creating a single formula to search the billionaires list by name and autofill the rank, age, net worth, and citizenship field in the search spreadsheet.
This is the formula I have ...

**0**

votes

**0**answers

13 views

### Excel workbook contains a userform which opens up black on 8.1 office 2010

The userform within the worksheet opens black on windows 8.1 office 2010, yet it opens fine on XP with office 2010.
It's a excel 79 to 2003 xls file.
We checked trust centre on 8.1 but no joy, ...

**1**

vote

**0**answers

18 views

### Looking up the same value in a row and returning multipe corresponding values

I am trying to lookup value 1 in the example below and return corresponding column name. When I use index match, it only looks up the first column which corresponds to 1 in the below example, it looks ...

**0**

votes

**1**answer

32 views

### Regional and Language Options >> Customize in windows 7

I can not the find the below path in Windows 7.
Control Panel > Regional and Language Options > select Customize on the Regional Options tab > change the List separator to a pipe "|"
I am trying to ...

**0**

votes

**0**answers

28 views

### EXCEL: I have a column of single-word strings and would like to see if any of these strings are contained in a column of multi-word cells

Example:
In column A I have a list of words "Apple, Banana, Orange, etc." each in their own cell.
In column C I have a column of multi-word strings like C1="I ate an apple", C2="Bananas are gross" ...

**0**

votes

**2**answers

40 views

### Retrieve row number of clicked cell in Excel [closed]

How can I get row number as result of a clicked cell? For example, if I click on cell C9, then I need the function to return 9 as answer.

**-1**

votes

**1**answer

19 views

### Deleting range of cells based on criterea

I have an Excel file with several macros, used for data processing.
The masterfile reads one or more .csv files and copies all data it needs into a tab (lets call it sheet1) within the masterfile. ...

**0**

votes

**0**answers

9 views

### Linking Excel workbooks by headers in tables, using Excel 2007

I can export data via CSV from a large database.
I save this to the desktop as DBaseA then convert to an Excel file with macros and convert to a table. It can get up to BZ wide but no more than 200 ...

**1**

vote

**0**answers

23 views

### Format Excel to Display Second Time Zone in Graph

I need to make my Y axis in a graph show the time in HH:MM (local) format as well as HH:MM +/- offset for another timezone.
Form example:
09:00 EST 06:00 PST
Is there some sort of custom format ...

**0**

votes

**0**answers

21 views

### Certain file types (INDD and XLS) routinely corrupt on our Windows Server share

We have recently moved to a Windows Server 2012 R2 (I think) network share, which our office of ~30 people access via Windows machines on a domain.
Routinely, but sporadically, InDesign INDD and ...