**0**

votes

**0**answers

26 views

### How to Copy/Paste Link data conditionally (or achieve the same results), based on entries from one worksheet to the next within Excel 2007?

I am attempting to create a job log in Excel 2007 with two separate worksheets: Potential Opportunities (source sheet), and Interested Employers (destination sheet). These two sheets have the ...

**1**

vote

**1**answer

520 views

### Excel 2007 or 2010 copy/paste without merging cells & with shift all down

Let say I have an excel sheet with structure like
I select a few cells (at one column) and click Ctrl+C. After that I want to paste it. I select one cell(B116):
And click Ctrl+V. It gives me ...

**0**

votes

**3**answers

156 views

### How to dynamically populate a filter list with “first match” on a row, using excel 2007

The image is an example of what I am working with. I am trying to write a formula in my leftmost column, just under the listbox cell that you can see, which will find a string/value match in that ...

**1**

vote

**0**answers

16 views

### Embed an dotm file into an Excel document

I have a dotm file( macro enabled word template). I want to insert it into an Excel file and I want to open it by the clicking of a command button in Excel form. The problem is, when I open this dotm ...

**4**

votes

**1**answer

2k views

### Add/Subtract button Excel VBA

Here is an example of my project in this picture
I like collecting, so I am making an inventory sheet in Excel.
I want to make a way that I can click a button and it affects the next, or previous ...

**0**

votes

**1**answer

152 views

### Excel - Sum certain range from pivot table

I have an excel pivot table that looks like the following:
Is there any way I can create a formula that will calculate the sales$ for a particular product at a particular store for a particular ...

**1**

vote

**1**answer

191 views

### Sorting Dates in Excel By Month

My boss has given me a job in which he has given me the names of customers and their wives who has bought our products from 2 to 3 regional offices. My boss wants me to format all this data into one ...

**0**

votes

**0**answers

55 views

### Cannot “save as” file on Microsoft Excel and Word 2007 running on Vista Home Premium edition

I have Excel and Word 2007 running on Vista home premium edition. After working on a new file and try to "save as" just before naming the file, a window pops up 2 dialog messages "Search online to ...

**0**

votes

**2**answers

2k views

### How to automatically update values referenced from one sheet to another in excel

Here is my problem . I have 2 to 3 worksheets and I need to make a master worksheet . The 2 3 worksheets are containing the sales made in the day and the customer name . the problem is that new ...

**2**

votes

**1**answer

957 views

### How do I filter on bold, struck through or italic text in Excel 2007?

Is it possible to filter an Excel column based on the format of the text, such as whether it's bold, italic or struck through?

**0**

votes

**2**answers

180 views

### Is there one simple formula for Excel that can identify a string contain non-ASCII Characters?

I know that using the clean formula, I can clean up some of the non-ASCII characters (such as additional non-printable ASCII control characters #0 through to #31, #129, #141, #143, #144, and #157 ...

**0**

votes

**1**answer

51 views

### Why is Excel truncating my normal numbers?

I open MS Excel 2007 and I write:
50
and Excel changes that into 0.5
I write 500
and excel changes that into 5
I write 5000
and excel changes that into 50
and so on and so on.
It is driving me ...

**-1**

votes

**1**answer

83 views

### How to split up above single cell Address value into multiple cell value through macro

How to split up the below single cell value into multiple cell value through macro ?
So, this...
A1 = MISS FirstName LastName***95*SPECIAL ROAD**LONDON SW92**SW929AB
...should split as below,
B1 ...

**0**

votes

**1**answer

31 views

### Automatically place numbers in cell Microsoft Office Excel 2007

| | A | B | C | D |
|---|--------|-----------|-----------|-----------|
| 1 | Number | First | Second | Third |
...

**0**

votes

**2**answers

68 views

### Excel 2007 IF AND function calculation not copying across

I'm using an IF AND function, which is:
...

**1**

vote

**1**answer

523 views

### Can the data validation list width be controlled in Excel 2007 and greater?

In Excel 2007, I can add data validation to a cell, and supply a list of allowed values.
However, experimentation suggests that the data validation drop-down list will never display at a smaller ...

**1**

vote

**1**answer

28 views

### How to generate a series of growing values and timestamps for cell that updates automatically?

I have a cell A1 which references a sheet that gets updated by an external source (database). My goal is to record a log that traces the growing value of cell A1 at each different time the data is ...

**0**

votes

**1**answer

46 views

### Can I create a cell with enumerated values in a csv file

Can I create a cell with enumerated values in a csv file?
For example, I want a cell that can only get the values:
a) "value1"
b) "value2"
c) "value3"
Is this possible?
PS:
I have used this ...

**0**

votes

**2**answers

356 views

### Nneed to calculate average of NON sequential multiple cells & I want to exclude values = 0 or Empty Cell with AVERAGEIF

Nneed to calculate average of NON sequential multiple cells and I want to exclude values = 0 or Empty Cell with AVERAGEIFS.
There is a mistake in my formula but I can't find a way to have it since ...

**1**

vote

**1**answer

47 views

### Excel not accessible after import of data through script [closed]

I am using a python script to open up an excel workbook (by creating a pointer to it). After I put some data in the excel and script execution is completed, I tried to access(see note below ) the ...

**0**

votes

**1**answer

128 views

### VBA Code De-bugging in 2010 excel

Looking for some help in debugging some old VBA/Macro code to work in the newer version of MS Excel 2010. The macro in question is the "Material Rollup" function.
The purpose of the macro is after ...

**0**

votes

**0**answers

248 views

### Can't Find/Find&Replace “Purple, Accent 4, Lighter 40%”, all other colors work - Excel 2007

I have a several large Excel tables that I am managing for my current project. Whenever a metric or value in the table changes, I indicate the change by changing the background color of the cell for ...

**0**

votes

**1**answer

27 views

### Sorting and showing the most repeated row (value)

I have a sheet containing over 200k+ rows with values like this,
10.10.10.10
11.11.11.11
12.12.12.12
10.10.10.10
10.10.10.10
I want to be able to show the most repeated row at the top or extract it ...

**1**

vote

**2**answers

46 views

### How do I find matching data in Excel?

I am trying to find some files listed in a big Excel workbook.
On Sheet 1 I have the list of all the files with full path.
C:\A\B\01.xlsx
C:\A\C\02.xls
C:\A\D\03.zip
C:\A\E\04.jpg
...

**0**

votes

**0**answers

39 views

### Excel dates with standard format (*) become custom when opened in another country

Here in the USA, I have created an Excel 2007 spreadsheet with a table that contains several columns with dates. I have formatted the date columns using the standard short date format (with the ...

**0**

votes

**2**answers

271 views

### In Excel, checking if a cell matches one item from a named constant string list

This question is an expansion on In Excel, how do I check if a cell is in a list of values (a range of cells) .
I'm trying to do =COUNTIF(name,G6) and when name refers to some cells, it works fine, ...

**1**

vote

**2**answers

218 views

### Excel SUM function for whole column?

How can I sum the whole column without freeze head?
I have a situation: I need to SUM each column, but the total rows in each column will keep changing. users are keep adding data in each columns, ...

**-1**

votes

**1**answer

101 views

### how to copy data from on cell to diferrent cell using command button

for example the first thing i put in cell b1 has "='Ex-post'!C172"which has value "1" and c1 has "=OFFSET('Ex-post'!$B$4,MATCH($H$1,'Ex-post'!$B$5:$B$542, 0),4)" in which the value is 2300 and i want ...

**0**

votes

**2**answers

215 views

### Superscripts in Excel chart labels

I have data like this in two columns:
2 | 5
4 | 6
8 | 7
I want to plot them (scatter plot) with x={2,4,8}, y={5,6,7} but in the x-axis show 2 as 2^1, 4 as 2^2, 8 as 2^3, but not with the ^ symbol ...

**0**

votes

**1**answer

33 views

### Excel 2007. Write changes back to extern file source

it's possible to import data into an excel sheet from an external (csv) file.
Every time content of this external file will be changed, we'll see these changes in the excel sheet.
But is it ...

**0**

votes

**1**answer

923 views

### I don't want Ms excel to scroll down by cell units [duplicate]

When I scroll down (or up) in Ms Excel 2007, it scrolls down so that only whole cells (or at least it tries to do so) could be displayed next in that page. And it keeps jumping down one complete row ...

**0**

votes

**0**answers

31 views

### Why does Excel 2007 change 13 to 14 when typed in?

Every time my co-worker types 13 into an excel cell, excel changes it to 14.
She was using excel 2003 and this was happening. Our tech installed 2007 and it is still happening. We have to use a ...

**1**

vote

**1**answer

297 views

### Microsoft Excel lookup match without sorting data

Have a value list and need to insert points by looking up the data table. Data table has value for points in 1000 increments. Actual value that I lookup will not be rounded to 1000 so I tried using ...

**0**

votes

**1**answer

74 views

### Concatenate a range with values in between

I work with ranged data and want to populate a cell that includes values at set increments between the min and maximum. For example, the minimum outer diameter is 1 1/16" and the maximum outer ...

**1**

vote

**2**answers

356 views

### Excel Lookup adds double quotes to string

I'm using this formula to get value form a table
=LOOKUP(C11;Alias[A];Alias[B])
where C11 = 12354567
But when I use
=LOOKUP(LEFT(C11,7);Alias[A];Alias[B])
where C11 = 12345678, the formula does ...

**0**

votes

**1**answer

177 views

### Defined Name to give text or date value instead of numeric value

I had been trying out Define Name in Excel. I defined a name for a cell in which I would put a text or date value or I may leave it blank.
But when I use this defined name in another cell, the second ...

**0**

votes

**1**answer

261 views

### cell format excel number to text

I have a file with 4 columns and over 7000 rows. The columns are formatted as Number or Geral.
But I'm using a plugging for php (SimpleXLSX) to read the xlsx file and create queries to insert into a ...

**2**

votes

**1**answer

1k views

### Excel - sum values based on a column that match another column in another table

I've been working my head around this, but haven't figured it out yet, and I'm sure it's dead simple.
Suppose the following example:
There are two tables, one containing animals, and the other one ...

**1**

vote

**2**answers

695 views

### MS Excel Column content replication across two sheets

Microsoft Excel functional Question
How do I replicate (copy a column contents of Values to another sheet column) of a whole column (with data content) from a primary sheet to an secondary sheet in ...

**0**

votes

**3**answers

80 views

### In Excel replacing a column with another column

I have a list of Variables in Column A > list of items
another list of variables in Column B > with corresponding Item Codes for >> column A
And in Column C > I have list of item codes randomly ...

**1**

vote

**0**answers

75 views

### Make Excel 2007 pivot tables default to Classic View

When I launch a new pivot table in Excel 2007 (.xlsx file format) the defaults appear to be:
New view (not Classic view)
Autofit column widths on update = on
Subtotals = on (top of group)
I end up ...

**0**

votes

**1**answer

56 views

### excel - if value grater than, use that value

I am having problems with my excel function. I want to:
if value 1 is greater than value 2, then write value 1 in a cell. If value 2 is greater than value 1, then write value 2 in the cell.
...

**0**

votes

**2**answers

60 views

### How can I work out days, hours and minutes from a total number of minuts?

In Excel I have a number of minutes that I need to convert in to days, hours and minutes, but I cannot figure out how to get the minutes. Here is how the data must be presented -
Total Minutes Days ...

**2**

votes

**0**answers

47 views

### CTRL+SHIFT+DOWN not working in Excel 2007

Ctrl+Shift+↓ is not working in Excel 2007. I have unchecked:
Options → Advanced → Tools → Options → Transition Navigation Keys
Ctrl+Shift+↑ is working fine. If I ...

**0**

votes

**1**answer

93 views

### How to change the size of my 'glow' effect on excel, when I use custom color?

When I create a shape in Excel(2007) I apply some effects in it on Format > Shape Styles > Shape Effects, with one of them being "glow" with some predefined colors and sizes.
What I'm trying to do ...

**0**

votes

**1**answer

43 views

### New instance of Excel does not see already opened instance

I have Avizo.xlt with one Worksheet and a code which intended to put this WS inside already opened document, which is SLK report made by our ancient ERP system, and close this document.
Everything ...

**2**

votes

**1**answer

90 views

### Sumif range of criteria

I've checked different questions and answers on the site, but couldn't find what I'm looking for.
I try to have a sum of values, using multiple criteria (OR): When I use, e.g.,
...

**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 ...

**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 ...

**-1**

votes

**2**answers

40 views

### Referencing cells from a different worksheet

Im trying to reference data within a cell of first work sheet (active) on a second worksheet (trucks). When I use =active!$L$34 on my second worksheet (trucks) it bring the right number over. However ...