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.

Filter by
Sorted by
Tagged with
2
votes
1answer
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
1answer
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
2answers
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
2answers
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
2answers
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
1answer
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
1answer
39 views
1
vote
2answers
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
0answers
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
0answers
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
0answers
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
0answers
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
3answers
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
1answer
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
1answer
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
1answer
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
0answers
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
2answers
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
2answers
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
0answers
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
1answer
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
0answers
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
0answers
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
0answers
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
1answer
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
0answers
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
2answers
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
2answers
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
3answers
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
2answers
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
3answers
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
1answer
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
0answers
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
1answer
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
0answers
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 ...

1
2 3 4 5
44