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

learn more… | top users | synonyms (1)

0
votes
2answers
80 views

referencing variable cells within the AVERAGE function

I am trying to create an automated system to average data, but the starting row and ending row of that data varies from one time to the next. I currently use the LOOKUP function to locate a reference ...
0
votes
0answers
12 views

Linking data to chart using vba

I am trying to connect this data to my chart but i am getting application defined or object defined error Dim chtObj As ChartObject For Each chtObj In ActiveSheet.ChartObjects chtObj.Delete Next ...
0
votes
2answers
804 views

Deleting charts in excel using vba

How to delete all charts in Excel Workbooks using VBA. ActiveSheet.ChartObjects("Chart 3").Activate ActiveChart.Parent.Delete
0
votes
1answer
67 views

Condition Formatting error

I am unable use condition formatting using the code below, I don't know were I am going wrong here: Sub condition_formatting_ms_sheet_test() Application.Workbooks(file_name).Worksheets("ms")....
0
votes
1answer
28 views

Excel Budget Spreadsheet Microsoft Word 2007

I have used a Microsoft Word 2007 annual budget spreadsheet template for budgets since they were .xlr. Npw they are .xlsx files and when I am working in them they take forever to process each entry ...
0
votes
0answers
11 views

Excel, Ascending Workbook Default Filenames

Disclaimer: I'm very new to using VBA, so please bear with me! I'm currently using the following macro to quickly export 4 specific pages from a larger workbook to a new workbook that gets emailed ...
1
vote
1answer
48 views

How can I build a plot data in Excel without separating categories into multiple columns?

How can I plot the following data where each category is colored differently in excel? category | datetime | score -------------------------------------- foo | 2016-01-01 00:00:00 | 1 ...
2
votes
2answers
28 views

Unwrapped text won't flow into linked cells

I have linked cells that have text flowing to empty adjacent cells in the original. In the destination sheet, the empty cells showed 0s and the flowed text disappeared. Suppressing the 0s in Excel ...
0
votes
1answer
24 views

ISBLANK not working as expected

I am using: =IF(OR(ISBLANK(B9),ISBLANK(C9)), "", C9-B9) To stop my data from returning a zero. However the data that I need to return is the difference between two months =MONTH(L9)-MONTH(O9), ...
0
votes
1answer
77 views

Using Min/Max function in excel how do I return a different value from the same row?

I've created a table (not using the table tool just using the cells) in Excel in one sheet. In another sheet I have called the min/max function for that table to return the highest/lowest value. ...
4
votes
2answers
100 views

Is there an add-on for Excel to allow me to sort by an arbitrary column with a SINGLE click?

Windows Explorer allows you to sort by an column by clicking on the 'header' of that column so you can see files sorted by size or filename etc. Excel on the other hand forces you to go through the ...
0
votes
2answers
44 views

Excel SaveAS RTF

Sometimes I need to save a block of cells in a worksheet in RTF format. I am using Excel 2007. I currently: open an instance of Word copy the cell bock from the worksheet paste into Word save the ...
1
vote
2answers
133 views

Can't detect month “Jan” in excel table?

The reference no, e.g. EPS-I-S160201 is in the format of EPS-I-"Category""yy""mm""Sequence No" Reference No is auto generated to run in sequence. The last 2 digits will auto reset the last 2 numbers ...
0
votes
1answer
26 views

Using a Date to refer to a page to VLOOKUP into

I currently have data that has a date and item number and I'm looking to pull the price from a different sheet. =Vlookup(#,Jan1!(Range),2,0) Gives me my price of Jan 1 =Vlookup(#,Jan3!(Range),2,0) ...
0
votes
1answer
24 views

Assigning Serial Number to Combination of cells selected from List

I have two columns(Column A and Column B) which are in LIST drop down form A B a 1 b 2 c 3 d 4 ....so on that means you can select "a" from column A and "2" from column B ...
1
vote
0answers
45 views

SUM nested values based on nesting level labels [closed]

I have a manufacturing process, which has costs for raw materials and processing steps. Level 1 is the finished product. Its cost is composed of level 2 materials and processes. Some of the level 2 ...
0
votes
0answers
30 views

Two sheets need to have matching data

I'll do my best to put this simply. Let's say I have two sheets with the same table formatting. Both have columns "ID" and "Fruit". One of the sheets has missing fruit names, but still has all of the ...
-2
votes
2answers
36 views

i would like to be able to type a number in a column & autofill the address in the next column

I have a workbook where I have a column 'site no.' where I'd like to be able to type a 3 digit number & the column 'site address' is auto filled with the address. site numbers & site address's ...
3
votes
0answers
71 views

Checkbox location changes when workbook is opened in Excel 2010

I am using Excel 2007 at home to develop a sheet for work that has data input using multiple checkboxes. Each checkbox is in an empty cell. When I open it at work with Excel 2010, all the ...
2
votes
3answers
255 views

How do I restart a number count if Cell value = 0

Been looking how to do this all day. I am trying to get an auto reset if a cell hits 0 but I just cannot find the formula or VBA to help achieve this. A1 9 B1 9 C1 0 D1 9 E1 9 F1 9 G1 9 H1 36 (I ...
2
votes
1answer
23 views

Delete input field from Excel 2007

How can I delete an input field from Excel 2007? Note that copying the content of the page without selecting the input is not an acceptable answer.
0
votes
0answers
47 views

Can you use unit of measurement combinations with Excel's CONVERT function, and if so, how?

I've been wanting to experiment more with Excel's CONVERT function and came across a useful web page that listed the proper syntax required for it. The url to the page is below: https://support....
0
votes
0answers
40 views

What is the most efficient way to standardize time formats and find time durations exceeding specific lengths using Excel 2007?

THE SCENARIO: Let’s say somebody hands you a spreadsheet containing a column for the time duration of 416,000 videos. When the information was entered, it was entered into an Excel 2007 spreadsheet ...
0
votes
0answers
37 views

Formula to find difference/change between 3 or more fields?

Probably a dumb question, but I'm looking to find the difference between 3 values in excel. +-----------+-----------+-----------+ | Nov. 2015 | Dec. 2015 | Jan. 2016 | +-----------+-----------+------...
0
votes
1answer
30 views

How to fill a cell according to the type of number

Currently I have 2 suppliers with barcode scanning system in excel. Since I scan them in Column A in excel (with auto-enter to the next cell), I would like to know if it is possible to have ...
0
votes
0answers
30 views

Excel 2007 backup spreadsheet without formulas

I have a spreadsheet report that refers to multiple other workbooks to update values. Currently no macro is used, spreadsheet depends on cell references to update the values. I need to do a daily ...
0
votes
3answers
73 views

Filling cells with sequential numbers in an Excel (2007) spreadsheet as a noob

I need to fill an excel column with a sequential series, in this case from 1 to 31. As a complete noob I've no idea what a macro is so the answers on "Filling cells with sequential numbers in an Excel ...
1
vote
1answer
82 views

How to implement answer to: “How to get excel row numbers to skip the header”

The question How to get excel row numbers to skip the header asks about how to change the way Excel numbers its rows. The author's usual practice was to use Row 1 for column headers and wanted to ...
0
votes
0answers
31 views

Auto filter with multiple criteria and display data if anyone of the criteria met in the table

I'm trying to filter an excel table based on four criteria and using the below code for it. Range("A17").AutoFilter field:=8, Criteria1:="=" & a, field:=6, Criteria2:="=" & b,field:=7, ...
0
votes
1answer
15 views

Excel 2007 I need to be able to enter data in a cell on one sheet and have that populate on a different sheet

Thank you in advance, I am attempting to have a workbook that on the 1st sheet has cells that I need to populate with the data I enter on the 2nd sheet. There is no calculations that will be performed ...
0
votes
2answers
64 views

How to put comma into digits like eastern (especially Indian) style by using a formula in M S Excel?

Friends I want to put comma automatically into the digits like this- 10,00,000 Or 1,00,000 For this I want to use a formula. I also know that I can do this by format cell>number>use 1000 separator (,...
0
votes
2answers
203 views

Excel Personal Macro Workbook keeps getting disabled

I'm a new user to this site. I'm trying to run a VBA macro in Excel once a day at midnight using the windows task scheduler. It imports data from a .txt file that gets dropped into a folder at night, ...
0
votes
1answer
38 views

Comparing 2 columns and add blanks in 2nd column

I have 2 columns where some cells have the same value. I would like to sort both columns and put blank cells to another column if it doesn't have duplication. Example: | Test1 | Test1 | | Test2 | ...
1
vote
1answer
39 views

what is the purpose of Print Scaling in the page layout tab in Excel?

What is the purpose of Print Scaling in the page layout tab in Excel? in the Width and Height I can select Automatic and options like 1 or 2 pages and others. but I don't know its purpose. Is it ...
0
votes
0answers
14 views

Microsoft Excel 2007 for OC

I have a column with multiples of different answers, like the following: Country Germany US Italy Italy Germany Germany Germany US Italy US I want to: list how many different countries are in ...
0
votes
1answer
30 views

Excel VBA localisation issue - WIN 8.1 Enterprise, Excel 2007

I have a problem with file using VBA macros created in GER version of Excel. This macro is testing the pivot table item for "Alle", but when someone opens the file in EN version, the pivot table item ...
0
votes
1answer
51 views

Concatenating multiple characters with different formats in excel

I need to create a large series of multiple machine numbers with the following character formatting: Machine Number(first 4 digits)_Date(last 6 digits) as provided in the sample image below: One ...
0
votes
2answers
161 views

Excel - For each unique ID, every time a particular column turns one, it needs to be cumulatively added

I have a big data set. What I want to happen is for each customer number occurrence, when the transaction type column has an entry CC or SO, it needs to be calculated as a donation. So for each ...
1
vote
1answer
91 views

Excel automatic “date changed” field for each column of data

I'm using Windows Excel 2007, if that matters, and I'm trying to have a date field update to today's date automatically only when a cell in that column gets changed. I add new data entries per column ...
0
votes
1answer
36 views

Convert a column B into a comma separated list , “ORDER BY” Colum A

trying start with VB in excel just need understand how it works , this task can be done in SQL, but I really want to know how can be easy done in excel column A contains par numbers , column b models ...
0
votes
1answer
110 views

How to compare the Values in two different columns if the Values are same get the values

Column B has Values of customer Number (multiple times) till Row 1000 and column A has the sales orders information like below. Column A Column B ORDER1 KRISHNA ORDER2 RAVI ...
0
votes
0answers
14 views

How to merge Excel 2007 table with pre-existing Word 2007 table

Using Word 2007 and Excel 2007. I have a client technical document that contain tables that have very specific formatting (borders, fonts, font colors) that I'm not allowed to change. The tables are ...
0
votes
0answers
50 views

How to combine multiple databases in excel into one strong and efficient database

I'm working in a highly reputed government company as a data entry clerk and my responsibility is to keep the contact information database updated by adding new contacts and making sure that all the ...
0
votes
2answers
101 views

Excel: Separate empty cells from having 0 value

I wanted to know if there is an option that doesn't allow empty number cells to obtain the 0 value when there is a function that takes values from these cells. For example, if I want to add the ...
0
votes
1answer
733 views

How do I implement the VBA module to copy filtered data

I need to implement a VBA Macro that copies data from one excel worksheet and puts certain column into another one. Sub sbCopyRangeToAnotherSheet() 'Method 1 Sheets("Sheet1").Range("A1:B10").Copy ...
0
votes
0answers
59 views

Extract all URLs and emails from a single cell

I have an Excel workbook, in column A each cell contains lot of text and some URLs and emails (all this in one cell). Among all the text within a single cell I want to extract all URLs and emails. ...
0
votes
0answers
28 views

how to get cells containing keywords separated by a comma to become filter keywords on activating the filter

I have a table of recipes: Dish | Ingredients | Tools | Soup |tomatoes, basil|bowl, fork | Pizza|eggs, cheese |pan, knife, plate| Pie |meat, eggs, ham|skillet, knife | If I ...
0
votes
0answers
21 views

Excel Pulling details from sheet 2

How could we get the data from the Page 2 in same work sheet matching with data provided in sheet 1. But data with sheet 1 and sheet 2 matches nearly same not exact. Please suggest by the following ...
0
votes
0answers
64 views

Excel split row into multiple rows

I am using Excel 2007. I want to split rows into multiple rows with one phone number on each row, so that it looks like rows 8-12 in the screenshot.
6
votes
2answers
1k views

How to generate random string from a set of available strings in Excel?

I want to generate a column which will have random string values in any order. Those string values have to be from ('New', 'Mint', 'Very Good', 'Good', 'Acceptable', 'Poor') strings? Can anyone let me ...