The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
4answers
3k views

Can't edit textbox

I just inserted an ordinary textbox in an Excel sheet. Now for some reason, the text box is not selectable at all. When I hover the mouse over it, the cursor turns to a circle with a sloped line ...
0
votes
0answers
3 views

Trying to Text/snapshot values (VBA Excel 2010)

Ok, so i'm trying to track weekly quantities i have in my spread sheet. So far i've made a macro to copy and paste the info were i need it. But it will only paste it to the spot i chose while ...
0
votes
2answers
2k views

Excel 2010 Legend key color based on text

Background I've an excel template. This template I populate with data by running a program I've written. The excel template has a pivot table on a sheet that get's data from another sheet that I've ...
5
votes
5answers
2k views

How to combine data from two rows, when certain criterion is met

click to enlarge I'm trying to make this Excel document but I want the AdminTimes for the same LastRxNo to be on the same line. So if the LastRxNo is the same, have one line and the AdminTime column ...
1
vote
1answer
27 views

Copying cells to another sheet and inserting rows for the copied cells

I am trying to create a sub that copies information from one form (which has four cells) to another sheet. When it copies the information it also creates a new row. Each form has a maximum of ten ...
1
vote
1answer
20 views

After pasting data, how do you navigate cell contents with keyboard arrow keys in MS Excel?

Using MS Excel 2010 I can copy ASCII plain text from a separate text document and paste the text into a cell (I first enter cell edit mode before pasting with Ctrl+V or Shift+Ins). After pasting, ...
0
votes
1answer
7k 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 changes from -4 to +4. A change ...
0
votes
1answer
15 views

How to transpose two cells data at a time from 2 cells to multiple rows

I have Excel data in the below format: Excel Std Row: A B C D E F G H I J 1st Row Data: 1 1 2 2 4 4 5 5 6 6 Now I need output as below: A B ...
0
votes
1answer
31 views

How to use INDIRECT with a SUMIF formula for a date range

I'm trying to get a SUMIFS formula to dynamically work with multiple tabs in an excel workbook. I have numerous tabs in this workbook, each that contains client data I update daily. In the example ...
0
votes
2answers
12k views

Excel not sorting

For some reason, when I try to sort in a file I downloaded, the sorting fails, even if there are just simple numbers in the cells. Editing is enabled. What is going on? Edit: When I say sort, I mean ...
1
vote
2answers
28 views

Need to count the amount of times -1 appears above a certain cell

I have the following Excel Spreadsheet - Hy Newcastle 042216 -1 Not Matched 1000 Hy Newcastle 042216 6461735 Khanyile;Florence Success 1000 Hy Newcastle ...
1
vote
1answer
4k views

Query parameters in an external connection to sql server

I want to do exactly this:http://dailydoseofexcel.com/archives/2004/12/13/parameters-in-excel-external-data-queries/ but I want to do it in Excel 2010 and also I am querying SQL Server instead of MS ...
0
votes
1answer
5k views

How to customize Paste Value Excel Short Cut

I was reading in this other post how to set up VBA code to paste values in Excel. I understand how to create the VBA code. I would like to set the keyboard shortcut to Ctrl d but Excel pops up an ...
2
votes
5answers
7k views

How can I count unique values in one column based on criteria in two other columns?

I am trying to to count the number of unique entries in column A where Column C says NO and column D says YES. However, I cannot devise a formula to do this based on two different criteria. How could ...
1
vote
1answer
38 views

How to create a preset for printing a workbook in MS Excel

I need to create a Default preset for 1-Click-Printing a workbook in MS Excel. This includes predefining Sorting and Filtering values, Adding text to top and bottom of the printed document, And ...
-2
votes
0answers
29 views

How to track changes in Excel 2010 like Word?

I have a workbook with a tab for each of 12 product lines. Each month the execs for that line make changes to their worksheet(s), depending on new products, different financials, comments or notes, ...
2
votes
1answer
16 views

Excel grab address to start y values series

I have the string $F$50 created by the CONCATENATE function. I also have a scatter plot where the selected data is like this: =SERIES(,data!$A$4:$A$404,data!$F$4:$F$404,1) I want to replace $F$4 in ...
1
vote
1answer
34 views

Excel: Write a 1 or 0 value if condition is met

Sorry if this has already been posted, but I just started today playing with Excel macros and I need a hand. I have a data column with values and I would like that if the conditions were met, the ...
1
vote
1answer
24 views

Is there a way to configure Currency or Accounting dropdown in Number Ribbon?

Is there any way to configure the list of currencies showed in the Ribbon (see screen shot)? My most used currency, $, is not available in the default list and I can't found out how to modify this ...
0
votes
0answers
17 views

Excel 2010 VBA Freezing panes when scrolling down (multiple headers)

I have a large spreadsheet with multiple headers in different rows, and I want to be able to freeze different headers while scrolling down and freeze pane. For example, A B ...
0
votes
0answers
18 views

Copy Top 10 from one workbook to other [on hold]

I have excel workbook as "Report June 21 - June 27" and each containing "ATT" sheet as first sheet. Report June 21 - June 27.xlsm I want to take the Top 10 in B, Q and R column by sorting Q5 by ...
3
votes
1answer
39 views

Can this 5-attribute 2D risk map be built in excel?

So there is this risk map (or heat map otherwise) below (*): What is interesting is that in the a 2D image there the following attributes are mapped: Attribute -------- Drawing component 1. ...
0
votes
1answer
5k views

Call PowerShell script from Excel macro

I'm trying to call a PowerShell script from a macro in Excel. I have seen a number of examples along the lines of: retval = Shell("powershell ""C:\MyTest.ps1""", 1) When I try to use this, ...
0
votes
1answer
41 views

Is there a way to exclude keywords in a VLOOKUP formula?

I have 3 sheets in Excel. In the 1st one there is a column with hotel names and another one with ID. I want to get that ID from the ID column on the 2nd sheet where I have the names as well. The ...
3
votes
2answers
1k views

show more than 8 items in the Data Validation drop down list in Excel

I have added a simple data validation to a cell but it only displays 8 items in the dropdown. Excluding the combobox solution and probably involving some WinAPI is there a way to make the drop ...
0
votes
1answer
5k views

Excel data validation to whole column

I want apply data validation list to a whole column in excel 2010. How can I do that with out copying the validation rule
-1
votes
0answers
17 views

excel 2010 VBA insert column headers [on hold]

I have a piece of VBA code (Excel 2010) that generates tables with 5 columns x 6 rows. There is an option to input the number of tables to be generated, as required e.g. 1 or 6 or 10 etc. basically ...
0
votes
0answers
10 views

Using Hlookup to populate a worksheet from a data sheet

I am trying to develop a worksheet that requires a list of equipment based on an area header. I would like to be able to pull the separate lists based on this area header. Here is sample data I am ...
1
vote
1answer
32 views

Excel 2010 error message when opening .xlsm files

I'm trying to open a .xlsm file in Excel 2010 when I receive the error: "There was a problem sending the command to the program" Once Excel is open, I am able to open the file, but if Excel is ...
0
votes
0answers
52 views

Excel does not update formulas values after filling source cells with values

I do 3 steps: Based on a template, I create a new Excel file through code (it works fine): Shared Sub FillExcel() Dim extension As String = ".xlsx" Dim sourcePath As String = "c:\Temp\libro" & ...
0
votes
0answers
15 views

Prevent my excel file from been opened in an older version of excel

As the title says, I would like to prevent my excel 2010 Pro Plus spreadsheet from been opened by someone using an older version of office. I created a spreadsheet that my colleagues and I update ...
0
votes
2answers
43 views

Populate missing entries from one sheet to another

I have two Sheets in Excel. For this example, Sheet 1 and Sheet 2. Sheet 1: 100 records with Name, Location, Gender Sheet 2: 100 records with Name, Location, Age The sources of the data are not ...
0
votes
0answers
21 views

Is there a way of 'detaching' a column from the rest for the purposes resizing the cells in it?

Here's an example Excel spreadsheet. Basically what it is an chart for time organisation, and I use the left most column for storing some notes (back log items etc). Now I need to to keep the ...
-1
votes
0answers
31 views

Excel range to html? Excel 2010

Looking to take a range of A1:I26 on sheet "Desc" and convert it to html. That html then show in Cell H2 on sheet "-Listings-" The cells in range A1:I26 has a graph with formatting i want kept (I.E. ...
0
votes
2answers
3k views

Complex rota hours calculation in excel

OK so there are a number of different shifts in operation here and I want a total hours formula. problem is the rota is written using a number of different notations for different shifts some are ...
1
vote
1answer
38 views

If statement that returns original function if false (similar to iferror, or substitute)

If I use IFERROR as opposed to IF(ISERROR I can save typing the condition twice. i.e. =IFERROR(Long lookup,"not found") is much preferable to =IF(ISERROR(long_lookup),"not found",long_lookup) ...
3
votes
1answer
3k views

Macros in Excel 2010 hangs

I have a spreadsheet with several macros. Generally, when previously using Excel 2007, a user clicks a button and everything works as expected (calculations, some email sending & file I/O). ...
0
votes
2answers
69 views

How can I compare two columns and if match return a value?

How Can I compare the entries on TAB: SUMMARY SLS, column B with SUMMARY P&S, column B and bring back a "X" if a match is found in the cell with the formula? SUMMARY SLS and SUMMARY P&S are ...
0
votes
1answer
21 views

Find cell address for MAX+IF function based on category

I have a large set of data, which has been divided into 9 categories using numbers 1-9. The data is not sorted by category, but the categories are defined in a column as data. Using MAX+IF, I have a ...
4
votes
3answers
47 views

How do I force Excel to always type purple text?

I'm making changes to a large Excel worksheet, and every change I make needs to be in purple text. Right now, I'm typing the change and then clicking purple text. Is there a way to force Excel to ...
0
votes
0answers
10 views

Why does outlook 2010 contact avantlink.com during splash screen startup?

The "contacting ......" message takes forever and finally allows outlook to run. I blocked the site via host file and now it either tried to make contact and stops to allow outlook to run, or a second ...
0
votes
2answers
19 views

How to sum with two variables involving date range

I get raw data much similar to the example below that has thousands of rows. What I need to be able to do is sum the values in column C (Or column D) based on the value in column A within the date ...
0
votes
2answers
30 views

Compare 2 different columns in 2 different Excel Files

This is a bit different than the others. I'm trying to compare 2 different inventory sheets, comparing serial numbers of equipment from 2 different reports. I have File A which has 4 worksheets in ...
-1
votes
1answer
26 views

BOM comparison sheet

I have been working on Comparison sheet, where i need to compare Base BOM1 with other BOMS. I added formula & prepared the attached sheet & I am able to highlight the mismatch values. But i ...
0
votes
0answers
19 views

Search for ID column in all worksheets and then search within those columns

I have multiple workbooks with multiple sheets on each. I am looking for a way to return the value under the column ID#, like to search all the sheets in the workbook. The header ID# might be in a ...
-1
votes
3answers
11k views

Excel quirk: Will not create graph from certain data

I had a certain block of data in a spreadsheet I was trying to create a graph (chart) from. I spent over an hour trying to figure out what was going wrong with my chart settings. I tried cutting and ...
0
votes
1answer
16 views

Copy/paste changing date format in excel 2010

I want to copy/paste a spreadsheet that my employee has created into the main spreadsheet residing on my computer. When I do so, the date column in the employee spreadsheet changes to a random 6 ...
-1
votes
2answers
43 views

Combine data from multiple rows into single row [closed]

I've got a raw data dump of user profiles on a server. One column has the user and the other has the group. For each separate group a user belongs to, there is a separate row. I want to have all the ...
-1
votes
1answer
3k views

Special-Pasting a hyperlink in Excel

Is there a way to use the Paste Special command to paste a hyperlink from one cell in Excel 2010 to another cell? I am asking specifically about the Paste Special command, not the Paste Link or ...
1
vote
1answer
43 views

Excel macro to format cells based on value and group with blank rows below

I'm trying to create an excel macro to format some data that is exported from another program. Here is an example of the data layout: ID Code SubCodes 1 A1 1 1 ...