# Questions tagged [microsoft-excel-2007]

Microsoft Office Excel is a spreadsheet application written and distributed by Microsoft. Use this tag for problems specific to Excel 2007 for Windows.

2,157
questions

**2**

votes

**1**answer

53 views

### Excel - How to find a number exist in which sheet

I have 10 sheets in a excel file.
Sheet2 to Sheet10 are raw data, and every sheet A1 has that sheet name, like this
Sheet2
colA colB colC colD
row1 Sheet2
row2 ...

**0**

votes

**0**answers

37 views

### Delete Multiple rows based on criteria from Multiple CSV files in a Folder

Option Explicit
Sub Delete_Rows_From_CSV_Files()
Dim source_folder_name As String
source_folder_name = "C:\Users\Siraj\Documents\CSV FILES\" 'change the path to the source folder accordingly
...

**0**

votes

**0**answers

29 views

### When opening read only excel file save as dialog box is displayed

When I open read only excel file save as dialog box opens and I can't read file without saving a copy of it.Also a new excel file created in desktop can't saves the modification . Every time save as ...

**0**

votes

**0**answers

23 views

### Excel 2007 command shortcut keys changed

One of our users have a pretty weird problem with his Excel 2007.
For example (sometimes but more often) when i would like to print from Excel 2007 (CTRL + P), I get the "Insert" window instead of "...

**0**

votes

**0**answers

16 views

### Can I enter a name in cell A1, and that to appear in B1, then in A1 to enter another name and it to appear in B2 etc

There is excel file that contains, for example, a biology test. Students open the file on their computers and in cell A1, which is titled "Student's Name and Surname", write their names and then do ...

**0**

votes

**0**answers

35 views

### How to enter a name in cell A1, and that to appear in B1, then in A1 to enter another name and it to appear in B2 etc

How to enter a name in cell A1, and that to appear in B1, then in A1 to enter another name and it to appear in B2 etc.
It is about registering students for online testing in an excel table. Cell A1 is ...

**0**

votes

**1**answer

40 views

### Excel formula to calculate based on another field's contents

What I want to achieve is, to create a universal formula for Bob, George, Charles, to calculate
their balance based on "Affects balance" field.
So in the example below results would be following:
C3:...

**0**

votes

**2**answers

38 views

### Excel Large Data to Summary Table

In the attached excel workbook contains 2 sheets, First one is data and second one is Result.
In the Data sheet, "A" column contains the length (10 meter) and "B" column contains the type of pole to ...

**2**

votes

**2**answers

28 views

### MS Excel: INDIRECT with an ! (exclamation) followed by some string name

I am new to excel macros I am trying to get my head around the macros. I have figured out that
=INDIRECT(A1 & "!D1")
will reference to A1 cell and then look for that sheetname and find its D1 ...

**0**

votes

**0**answers

22 views

### Activate an Excel Sheet Function using a Keyboard Macro instead of an In-sheet Button Object

I'm trying to set up an Excel sheet with a function to automatically add a blank row at the top of the sheet per this question. So far, all is going well. Now I want to know if the function can be ...

**1**

vote

**1**answer

54 views

### Creating an excel formula to calculate returns

So I have a dataset of monthly stock returns from January 2000 until today for six different stock indices. At the bottom of the page, I want to show the yearly return for each year as a percentage ...

**0**

votes

**1**answer

16 views

### How to get the percentage change with intervals on Microsoft Excel?

So I have a dataset of monthly stock returns from January 2000 until today for six different stock indices. At the bottom of the page, I want to show the yearly return for each year as a percentage ...

**0**

votes

**0**answers

19 views

### Copying a multi-line formula excel

I have a very large spreadsheet that helps me track inventory. I wanted to add the ability to change the monthly projection factor from one central location and have it change that month for each item....

**1**

vote

**1**answer

30 views

### In Excel 2007, how do I remove duplicate lines, while merging data

To help you understand the question, here is a sample:
I have this:
Name - Account# - Address - . . .- phone
Mr. A . . 4278 . . . . 123 Main . . . 555-1212
Mr. B . . 7532 . . . . 435 ...

**2**

votes

**2**answers

55 views

### matching all highlighted dates in one column to those of another column

I'm currently stuck on this step of my project. image of my document My ultimate objective is to highlight all highlighted dates in column P in column M. I was wondering if there was a formula so that ...

**1**

vote

**1**answer

31 views

### Excel count numbers, with taking day of today in account

I have an Excel sheet that looks like this:
In the column "Total" I have the total amount of minutes that need to be executed.
In the days after the "Todo" column I have the number of minutes that ...

**0**

votes

**1**answer

39 views

### What should I do if I have to match one column with another column in excel in the same spreadsheet?

I need to find out how many rows in column B match with rows of column A.

**1**

vote

**2**answers

44 views

### How should I design the spreadsheets for 3 dimensional data?

My supervisor asked me to go through a word document. It's a list of all the issues found in a building by the night guard, sorted by month. Things like, lights were left on in this room, or the door ...

**1**

vote

**0**answers

52 views

### Convert two numbers to a range

I want to convert these two numbers into a range so that when I find a number between them, I can still find it.
My data:
[Column 1] [Column 2]
Ticket Start Ticket End
000-000-001 000-000-...

**0**

votes

**0**answers

36 views

### Data validation backward compatibility bug

I have been given a spreadsheet made in Office 365 that uses data validation on several cells. The validation uses a range of cells from another sheet in the spreadsheet.
When opening the document in ...

**0**

votes

**0**answers

16 views

### Conditional Formating for spreadsheet cells with data in another cell

I have a spreadsheet to track spoilage costs and I have columns I through V labeled.
If my quality issue is one of these categories then highlight the cell below, if data is put in column E of the ...

**0**

votes

**0**answers

68 views

### Excel file in 2016 version freezes and high CPU usage but works fine in excel 2007

An Excel file i downloaded from a site works fine in excel 2007 but it freezes and shows high CPU usage for a long duration. I am not using any addins in Excel, There is no macro in the file, many ...

**0**

votes

**3**answers

133 views

### Cell value change with Month

I'm trying to have certain dates out of the week from day 1 to the last day of the month when I type a month in a cell for example:
If cell "I6" Contains "March" or whatever month:
...

**0**

votes

**1**answer

61 views

### Filter data issue on a data filtering formula

I want to sort my list in different sheets as mention value in cell. I want same value formula , that list currently I am uploading excel file in which >= formula is working but when I am going to ...

**0**

votes

**1**answer

16 views

### referencing cell based on specific data in excel

I want to get the cell address (column number and Row number) based on the data it has.
Example: Cell A1 has value 8 and column B has number 1 to 100 in random order (no value repeating twice). I ...

**-1**

votes

**1**answer

75 views

### I want to scan down column 1 and if, for each cell, it matches any of the cells in column 2 I want it to return the entry in column 2 it matches

I want to scan down column A in sheet alpha (alpha!A) which is a list of emails such that if, for each cell A1,A2,...AX, the said cell matches any of the entries in column D of sheet beta (beta!D), ...

**0**

votes

**0**answers

20 views

### word 2007 Line nunbering hidden behind square wrapped shapes

There is probably a simple answer to this questionā¦
when I try to put line numbering in a page where there is an image on the left-hand side and the lines are on the right-hand side, I cannot get the ...

**0**

votes

**2**answers

80 views

### Finding Specific Duplicate Text/Strings in Two Different Cells

I had a quick question regarding how I might find exact duplicate text/strings using a formula or macro. Here are two of my columns for example:
With those columns in mind, I would like to have a ...

**0**

votes

**2**answers

75 views

### VBA Save ONLY VISIBLE Sheet as Workbook

I was working with the following VBA (attached below). It works great, and what I like the most is that it is Path/Name independent.
I am now trying to save multiple reports which are based on some ...

**0**

votes

**0**answers

31 views

### PERSONAL.XLSB and many workbooks

I have problem to move trough many workbooks using VBA. I want to use Workbooks(i).Activate but i have problem with that. Every day i export 4 different workbooks. Every day they have different names. ...

**0**

votes

**1**answer

73 views

### NOT SURE WHAT IF FUNCTION CAN BE USE

I have this details, And I want my remarks to be automatically populated depends on what kind of PAPER I have.
Example
Column A - (Sales#) : 1234
Column B - (Warehouse) : FLOWER
Column C - (Purchase)...

**0**

votes

**0**answers

16 views

### Color scaling broken in Excel 2007

For some reason, I noticed in a certain spreadsheet I use often that color scaling appears not to work at all on one sheet, but it works fine on the other pages in the workbook.
By "not work", I mean ...

**0**

votes

**0**answers

40 views

### Dependent dropdown list in Excel

I have a table. I have three columns, 1-Company, 2-Product, 3-Area. The data is unordered and duplicate values are also there.
Then below the table, I am doing working... I can use cell validation, ...

**0**

votes

**0**answers

44 views

### Combobox ListFillRange not working in excel 365 in spreadsheet written in excel 2007

I'm attempting to get a spreadsheet made in Excel 2007 to work in 365 but have run into a stumbling point with populating a combobox. I have a named range "SearchBox_Name" dynamically set as:
=...

**0**

votes

**1**answer

96 views

### Excel VBA - If texbox empty, insert text

I have a Macro that takes text entered into a textbox and posts it to the next empty row. This simulates a running list. The problem is that if the textbox is left blank, the next time the user clicks ...

**0**

votes

**0**answers

20 views

### Excel - Need to get info from multiple resizing tables - Match, Indirect, VLookup

I am trying to make it so that my operators can cut and paste information into a spreadsheet and then I will have a Vlookup, etc. to be able to get the information I need. The problem is that I have ...

**0**

votes

**2**answers

55 views

### search value of its corresponding date within the range of date

I want to find if the data of its corresponding date is in the next working date.
I use =VLOOKUP(WORKDAY(A2,1),A:B,2,FALSE)=B2 but the problem is I have numerous data like almost 10,000 rows in a ...

**2**

votes

**2**answers

54 views

### Designing student monitoring sheet

I want to design a monitoring Excel sheet to keep track of my students' progress.
It should look something like this:
In the example picture, I'd be interested in assessing each student's performance ...

**6**

votes

**3**answers

148 views

### How to merge rows with Excel?

I have a worksheet containing:
ID VALUE1 VALUE2
--------------------------
ABC 8274
DEF 613
GHI 236
ABC 11.13
XYZ 173
GHI ...

**0**

votes

**1**answer

39 views

### How do I conditionally format to highlight cells with =-IF in the formula?

I have a large workbook with many sheets, each with two sections in them.
One section, the formulas should begin
=IF(ISNA(...
and in the other section the formulas should begin
=-IF(ISNA(...
...

**1**

vote

**1**answer

107 views

### Need Array formula to multiple match different column with different rows and get result in EXCEL 2007

I have attach the excel file
Need Array formula to multiple match different column with different rows and get result in EXCEL 2007
As you can refer to the picture I want to check Year between 2000 ...

**0**

votes

**1**answer

162 views

### (Solved) Conditional format cells rule for first character ignoring leading spaces (Excel 2007)

Is there a rule which can specify all cells where the first character is ', ignoring leading spaces?
I am using excel for macros troubleshooting, want to dim out comment cells. which start with ' but ...

**0**

votes

**0**answers

80 views

### How can I fix my Profit Margin formula? [UPDATED]

I have created a model whereby I've got the following:
Cost (column P)
Dealer price (Column S)
Current List price (Column T)
I've then done some market research and have adjusted List pricing (RRP) ...

**1**

vote

**1**answer

117 views

### How to reduce number of formulas and columns?

My goal is to adjust my pricing to match that of the competition, be it by reducing or increasing my current pricing. My model is a bit complicated and messy because their pricing includes tax, while ...

**0**

votes

**2**answers

97 views

### MS Excel - How to drop the character between the concatenated cells

I need to concatenated cells and put a comma between them. But some cells in the concatenated columns are empty and the result shows the commas between them. How to drop the commas if a cell is empty? ...

**2**

votes

**3**answers

426 views

### Check if cell text has a specific format

I am looking for a way to determine if text entered into an Excel cell is following this format: "0000/00/00" (0s can be any one digit number {0,1,2,3,4,5,6,7,8,9}).
Is there a way to check if the ...

**0**

votes

**1**answer

59 views

### Match the entire row from one table with another and then return a value from table 1 in Excel

If I have two tables, Table 1 has the following data
***
CTRL Number DATE MEMO DOLLAR
1 4/4/2014 "xyz" 505050
2 4/5/2014 "fadf" 99999
3 ...

**1**

vote

**0**answers

18 views

### MS Excel 2007 not displaying chart as required

I have Category Names to select from cells A3, A5, A7, & Values from E3, E5, E7. The slices on the pie chart show as appropriate, if I omit the Category Names; but do not, if I include them in my ...

**1**

vote

**1**answer

120 views

### EXCEL - How to use VLOOKUP to get the entire table contents?

I have an Excel sheet with columns:
Screenshot
Data
Table 1 Table 2
METADATA Date ...

**0**

votes

**0**answers

11 views

### Insert incremented value in entire column based on specific cell value

I'm making a sheet where a user enters a starting value in a cell, and the amount of times to increment in another cell. I want the starting value to then show in a column, and the amount to increment ...