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
0answers
7 views

Changing current mail merge to use new source data

I have a mail merge file that I created last year, I would like to use a new source data file to create new post cards. Can this be done and how do I go about doing it? I really don't want to create ...
3
votes
1answer
26 views

Extract content from the formula in a referenced cell in Excel 2007

I have a cell A3 that says Name. Cell F16 contains =A3, which displays Name, just like I want it to. I need cell F26 to take the information from cell F16 and display the referenced location. In ...
0
votes
0answers
6 views

Excel 2007 Consolidate rows multiple ranges on multiple sheets where a Cell is not “”

I am in need of some VBA code: I have 5 worksheets which I wish to consolidate into a Summary/Master sheet. The 5 worksheets have the same number of rows and columns but there are subheadings on ...
2
votes
0answers
24 views

Looping through master sheet and filter out rows that are needed

I have created a script which I want to allow a user to select a file (Master File) and if a condition is a met I want to Copy the data to the excel workbook (which the script is run on) The code ...
0
votes
1answer
32 views

Excel Formula with conditions

This feels like it should be simple but my head is hurting now and I'm struggling. I need to add a condition to an existing sheet which already contains formulas and references to other sheets. ...
0
votes
0answers
11 views

Copy Blank Count

i want to copy the blank color count under Color column from "5-Jul-15" sheet and "6-Jul-15" sheet to ABC sheet under "5-Jul-15" and "6-Jul-15" column (i.e. C13 and E13) respectively. It should ...
1
vote
1answer
26 views

How do I recover a previous version of an Excel file which was overwritten? [duplicate]

Does anyone know of a way to recover a previous version of an MS Excel (2007) file in Windows Vista Home Premium version, which I've accidentally wrote over?
-2
votes
0answers
49 views

lookupvalue and return multiple values in Excel do not work

I need to pull through multiple unique IDs for expenses. i.e. one timesheet consists of 5 expense payments for one date, but each of these expenses for that day contain individual unique ID. I need to ...
0
votes
0answers
27 views

Having trouble graphing big data in Excel (3500+ rows, 2 columns)

I really need with help this issue. I'm trying to show a relationship between two categories but the only problem is there's too much data! Problem: Is there a relationship between X and Y? X and Y ...
0
votes
0answers
18 views

Is this possible to generate excel combo box based on cell value?

As you can see, Cell C2 got 1,2,3,4. I assume this is a student id. So, I would like to generate a combo box in Cell B8, using Cell C2's data, separated by ,. So, in this case, the combo box should ...
4
votes
1answer
36 views

Add multiple series to a dynamic chart

I have a large amount of data stored in a table that is used to update about 8 charts (through named ranges). Each chart has the date and ID as the x-axis with a particular parameter being charted. ...
0
votes
1answer
24 views

In excel how could I generate a row of data from another sheet?

In excel I have a sheet named "sales", and another one named "factor". In factor I have some fields for factor ID, customer name, product code, quantities and price. I want when I add this data to ...
1
vote
1answer
21 views

Excel - pivot date values with max function

I am trying to pivot date values in a pivot table in MS Excel. I am getting incorrect date values. I do not want "Grand Total" as they do not apply for dates. Is it possible to do such pivots in ...
-4
votes
0answers
20 views

In MS Excel - how to write a formula for slab rate calculation [closed]

Out of 419 units consumed, for the first 100 units the rate will be Rs.2.60; from 101-150 units - Rs.3.15; from 151-200 units - Rs.3.55 and from 201-419 units it will be at Rs.3.85. Can you please ...
1
vote
0answers
22 views

Excel lookup value not on same row

What i`m looking for is that the data will be filled automatically from data table by lookup value in not same row. See the picture or xls example https://dropmefiles.com/BDlHe 1st table lookup ...
1
vote
2answers
31 views

Bypass Excel file selection confirmation for data connection with non-.txt text file

I have an Excel workbook that processes model output from another program. That program produces space-delimited plain-text output files with a ".plt" extension. I have a data connection in Excel to ...
1
vote
1answer
27 views

2010 Excel formula dilema [closed]

I am trying to set up an inventory spreadsheet using 3 worksheets. the first one has the items in inventory and their counts. the second sheet consists of the number of items used at an event which ...
1
vote
0answers
15 views

How to prevent enabling editing in Protected View in Excel 2013 from altering chart formatting of Excel 2000-2003 and 2007-2010 workbooks

In Excel 2013, when opening and enabling editing from Protected View a macro-enabled Excel workbook downloaded from the internet, with two versions in .xls (Excel 2000-2003) and .xlsm (Excel ...
1
vote
0answers
25 views

Why am I getting an error in this Excel module that runs access queries and copies results to the workbook?

I have written a module in excel to run 6 access queries and copy them into the excel workbook. My code works perfectly until I get to the 5th and 6th query then I get the error; Run-time error ...
1
vote
1answer
27 views

Conditional formatting based on specific cells

Is it possible to set conditional formatting based on a value written in a specific cell? I would like to colour the rows of saturday and sunday and not colour the working days. The condition is ...
0
votes
0answers
24 views

Excel formula works on one sheet but not the other. Non-blank max number

I'm trying to calculate the max number between 2 non blank cells in column A, using the values in column B when B>C. There are no blanks in B:B. C is always blank unless C>B. ...
0
votes
0answers
11 views

Excel match number in differ worksheets

I have a excel spreadsheet with 2 worksheets. Both contains a column with serial numbers. Is there a way to create a 3rd worksheet where all serial numbers in worksheet 1 which match worksheet 2 ...
0
votes
1answer
35 views

Excel, pair 2 columns, then find all rows where column J is in two different Column D

SO I would like to have a formula or macro, to look at a table in Excel, pair two columns say J and M. Then find rows where M is connected to more then one value of Column J, Column J is Super Group, ...
-1
votes
4answers
87 views

How to capitalize the first letter in a cell in Excel

Recently i came across excel with cells filled with small cases,Is it there any easy way or macro to capitalize each word of the excel? For E.g Consider the below image : After conversion it ...
0
votes
0answers
31 views

How can i sort data with macro in different worksheet?

I use the following code for sorting a sheet in a workbook with a macro but when I open another workbook, it doesn't work. How I can I change the code so it can run in another workbook as well using ...
0
votes
1answer
44 views

VLOOKUP where the column to look for is a drop down list?

I am doing a little format in which I call data from other cells, from other worksheet to fill it out. I am using VLOOKUP to do that. So as an example I have: Name: (Drop down list) Sex ...
0
votes
1answer
47 views

Excel max number between 2 non-blank cells A, in column B (given no blanks in B) [closed]

I need to calculate the maximum number between 2 consecutive non-blank cells in A, but using the values in B. ie. use a formula in column C that will give me the results I manually plotted in D. ...
0
votes
1answer
38 views

If Column value = string then add row next to column to sum

I want to make an expense chart In Excel. I have two Columns, one for type of expense and one for cost of expense. I made a few categories where the types are summed. The types are Entertainment, ...
-1
votes
1answer
39 views

Formula issue Microsoft Excel

I need help urgently for a work problem. So basically, the summation of opening stock and production give total stock. While closing stock is ((opening stock+production)-sale)) and stock cover is ...
0
votes
1answer
45 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 ...
1
vote
1answer
56 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 ...
0
votes
0answers
13 views

Adding data table onto another table using matching identifiers

How do i add fields in one data table onto another data table using matching identifiers in excel. I have two data tables in separate sheets that I want to merge adding all of the fields from the ...
0
votes
0answers
13 views

open excel using .bat when excel error “file in use” is returned

I have created a .bat file to open Excel, then my Excel workbook which contains a macro which runs on open, all on a scheduled task timer. The problem is that occasionally the Excel files are not ...
0
votes
1answer
48 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 ...
1
vote
1answer
27 views

fit a table in a middle of an excel sheet

I have a table in a sheet like this: I want to place the table in the middle of page. but the number of column is odd (5) and the number of column in the sheet is even (8). there is 2 cols after ...
0
votes
2answers
47 views

Excel help - extract info from middle of cell

Is it possible to take the words 'each', 'Any 2 for', 'kg', etc... out of these cells and put them into another cell... leaving only the $x.xx price so it can be sorted. Examples for above are: 1) ...
1
vote
2answers
34 views

Excel shortcut to set font size and bold

I have an Excel budget spreadsheet that as items (cells with numbers) are paid, I make the font bold and size 14. Is there a way to create a shortcut to do this with one keyboard move instead of ...
0
votes
1answer
47 views

How to select only the first max value in excel? [closed]

I need to make an operation on a cell and I choose the one with the maximum value. If it happens that there are more than one cell with the max value I need to do the operation only to the first one, ...
1
vote
0answers
28 views

Opening a file with a # in its path using the default application from Excel 2007

I have a pdf file which is located at "D:\some\#folder\filename.pdf". And want to open it from an Excel worksheet by clicking on a hyperlink (or something similar). Just creating a hyperlink does not ...
0
votes
1answer
53 views

How do I Reference all non-blank cells after row A6 for a Formula

I want to use the following formula: INDEX(A6:A94,MODE(MATCH(A6:A94,A6:A94,0))) Except the exact number of rows is ambiguous (imported using VBA). How can I reference all non-blank cells starting ...
0
votes
1answer
86 views

How do you format numbers in Excel for Indian Currency (Rupees)?

Currently the Excel default formatting is: 1,000,000 500,000 How do you format the number to use the comma separator (,) like this 10,00,00,00 50,00,00 This is is how Indian Currency (Rupees) ...
0
votes
1answer
38 views

How to prepend numbers to typed values in column [duplicate]

I need to manually enter a list of six-digit codes in a column. Each code starts with the same two-number prefix, 03. e.g.: 030144 030289 030283 Is there a way that I can type just the last four ...
0
votes
1answer
23 views

How to get a formula to extend to new cells depending on pivot table

I have a pivot table with some formulas using the data from the pivot table to the side of it. My problem is that if I add a filter, say city, so that the pivot table extends down, the formulas to the ...
1
vote
2answers
38 views

DATEVALUE() gives different values for similar data

In one column, I have timestamps in the format Jun 10, 2015 11:36:51 AM So, to get the date from that column, I created another column and used the formula =DATEVALUE(CONCATENATE(MID(D2,5,2)," ...
2
votes
1answer
38 views

Not getting desired output with VLOOKUP - Need assistance

I have Table 1, which looks like this - A1 B1 C1 1 X Date11 2 Y Date12 3 Z Date13 I have another table, Table 2, that looks like this - A2 B2 C2 1 M Date21 2 N Date22 3 X ...
0
votes
1answer
39 views

How to keep pivot table from expanding into occupied rows and columns

I have a pivot table with other calculations surrounding it. My issue is that if more row/column groupings are added to the pivot table, it extends and reaches the cells where these other calculations ...
-1
votes
1answer
49 views

Excel Vlookup range or if function

I have been struggling to find a formula that works for the example below (see question mark!). What i am trying to do is merge 2 datasets. The problem is that the common identifiers are not always ...
0
votes
1answer
36 views

What formula would you use to add up a column based on results from two drop down menus? [duplicate]

I would like to calculate a column based on selections from two other columns with drop down menus. For example : In one column, "C" you have 3 options (A team,B team,C team), In column "F" you ...
1
vote
1answer
37 views

Excel SUMIFS based on two criteria

I would like to total a list of minutes based on two criteria to make a graph after the data is calculated. The item "Department" (Column C) and "Day of Week" (Column F) are both drop down menus. I ...
2
votes
1answer
46 views

How can I use Excel to monitor my payable?

Here's what I wanted to happen, I have five columns Supplier Amount Payment Supplier1 Supplier2 When I have a receipt of my payable, I'll encode the name of supplier and it's amount. When ...