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)

3
votes
1answer
24 views

Excel formulas - how to make a cell blank down the page

I am having trouble figuring out the formula for my budget. Cells look like this A B C D DATE WEEKLY BILLS TOTAL 2015 $50 $1,956.73 Jan ...
-1
votes
0answers
19 views

How can I automate the process of printing 2 rows of data from one sheet after pasting it onto the form on another sheet?

Sheet 1 of my spreadsheet has the following form: A B C D They are just columns named 'A','B','C' and 'D'. Sheet 2 has the following data: A 1 2 3 4 5 6 7 8 9 10 I want to print pages of ...
2
votes
1answer
29 views

VBA EXcel - I am getting an error (400) if using error trap getting no object/application defined error

My excel sheet has these data, 7 columns sl.no | bed | 2| 4| 3|4|3| some times column no 7 is empty, and then only I'm getting error And my code Sub sup_cal_area_sft() Dim lru, plru As Long Dim ...
0
votes
1answer
13 views

Checkout/in Excel Workbooks from SharePoint with VBA

I have found several articles and past questions in SO that help with this, but I have added a twist. I found a way to map a network drive on my PC to the SharePoint folders. If I open a workbook that ...
0
votes
0answers
20 views

Locked cells are editable. Why?

Why am I able to edit the contents of a locked cell when the sheet is protected? What am I missing. When I select "Protect Sheet" the only choices I make available are to select locked cells or ...
-1
votes
1answer
61 views

How do I reference another cell based on the value of another cell?

No one understood my question which is understood due to my bad explanation. I'll put an example to avoid further confusion. In Sheet2 I want to change A2's formula then it will fill B2,C2, and ...
-2
votes
0answers
11 views

How to align data in four columns using excel?

I want to align data in four columns using excel. Each column has some values in common and some values appear more than once in column. Few values are unique to each column.
0
votes
2answers
15 views

How to test Excel workbook compatibility?

I have prepared an excel workbook in Excel 2013 (32-bit) Windows. It is a kind of report template, where others input the data, selects from in-cell dropdowns etc. The workbook does not contain any ...
-1
votes
0answers
22 views

Abbreviations management [closed]

I need to deal with a great number of abbreviations, so I would like to create a spreadsheet where all of them are automatically ordered as I enter each in a new cell. Also, the whole row ...
0
votes
1answer
29 views

How to synchronize text in Excel in multiple sheets

I have Excel file with four sheets. How to make duplication using Excel built-in function using specific parameters? Example: Sheet 1 - Total: A B C 1 Iveco ...
0
votes
2answers
29 views

Is it possible to have an =if equation involving text and math?

This is what I'm shooting for: =IF(LEFT(Q3,2)="By","see authorizing lab"&"-"&SUM(Q3-L3)) I'm trying to say IF Q3 says "By" the return "see authorizing lab" if not then subtract L3 from Q3 ...
3
votes
1answer
324 views

Omit weekends and/or holidays in days to complete formula

Is there a way to not include weekends and or holidays in an Excel formula involving dates? Example: =Q2-Q1 (a date in q2 minus a date in q1 = so many days) Excluding weekends & holidays?
2
votes
2answers
47 views

Creating an Invoice in Excel

I have only dabbled with Excel and not much in quite some time now. I have an Excel Invoice laid out so Column A is a name of a job and each row in column A can be a different job. Now column B ...
2
votes
0answers
30 views

How to interpolate a graph with multiple series in Excel?

I have a X-Y scatter plot in Excel 2007 with multiple lines on same plot like a series for 2%, and other series for 3% and 5%. How can I interpolate such data? For example, if I want to know a value ...
0
votes
1answer
9 views

Microsoft Excel 2007 function required to find specific information in a worksheet

I have an Excel worksheet in which I have 15 columns. In column 13 I have 3 names and blank spaces spasmodically placed, in the 3rd column i have dates running from latest to earliest down the page. I ...
0
votes
1answer
7 views

Display empty cell if referencing empty cell (formula)

I'm working on an excel spreadsheet, and im aiming for a clean interface with almost all cells filled with specific formula. Ex formula on column V : =IF(G1=" LNN ","PENDING", "N/A") What's ...
3
votes
2answers
24 views

Drop Down List and one formula

I am trying to get an average depending on two drop down lists. But i would like to get an average even when the second drop down has no input in it. The formula I use is a simple: AVERAGEIFS with: ...
0
votes
1answer
31 views

Is there a formula to look for partial text in a cell?

This is what I'm using right now in the formula: =IF(E6="Mix Design Gr S","By Mix Design","")&IF(E6="R-Value","By Soils","")&IF(E6="PS Package","By Soils","") Is there a way to only look for ...
0
votes
1answer
28 views

How to default Macros to run from This Workbook, NOT All Open Workbooks?

We have a macro enabled workbook (ver. 2010) that many people use. A few of these people have macros in their Personal.xlsb workbook. We have a situation where the macro in the shared workbook is ...
1
vote
1answer
39 views

Finding unused names in Excel [duplicate]

I was curious if anyone would be able to help me or give me some direction. I have a worksheet with the following sort of data. +---+----------------+--------+-----+----------------+ | | A ...
0
votes
1answer
21 views

Trying to create sequential hyperlink to worksheets in the same book

I have a summary page, and 50+ other pages, numbered 1-50. what I'm trying to do is create a hyperlink that will go to the correct sheet when clicked. I've got it working for one, but when I drag it ...
0
votes
2answers
44 views

EXCEL VBA works with F5 - but will not run automatically when cell values are changed

The VBA formula works perfect with F5 Column E cells E3:E5 have Functions that calculate to a dollar amount or $0.00. This is the formula pulling from =SUM('MEDENT Proposal - Creator'!B15*15) ...
0
votes
1answer
20 views

EXCEL automatic Tab Color change not updating

I have a formula for Automatic Tab color change that works when I manually change the cell, but it does not work when the cell is changed by a function updating it from another sheet: =SUM('MEDENT ...
0
votes
1answer
18 views

Using Excel 2007, how to autofill cells from one sheet to another

I want to put the Employee's Number in this sheet. ...so the Employee's information can show based on this sheet. (Click image to enlarge)
0
votes
1answer
41 views

How can I use excel to make a budget balance report? [on hold]

I have an excel sheet with my bank transactions. The format is: accountNumber mutationcode transactiondate valuedate startamount endamount transactionamount description In the ...
0
votes
1answer
13 views

Excel use mouse to jump to beginning of range (opposite of double-clicking cell border to jump to end)

In Excel when you double-click the border between cells you jump to the end of the range (equivalent to Ctrl+DownArrow or Ctrl+RightArrow). Is there a way to click somehow to jump to the beginning of ...
0
votes
0answers
21 views

How can I speed up functions in Excel? How I can make my sheet/worksheet faster? How do I know how long took create something in Excel?

I have long functions in Excel that use other sheets in my worksheet for example : {=INDEX( Sheet1, MATCH( $A2 & MAX( IF( ( 1 * ( $A2 = ...
-1
votes
0answers
8 views

Extracting Images from URL's in excel sheet to a particular folder with url as file name

I have an excel sheet which contains images Url's of a particular product in column "A". I want those images to be extracted into a separate folder with file name as url itself. Can you please help me ...
0
votes
1answer
26 views

Filter list with condition and return results as delimited list in a single cell

I need to return all values in column A that match a set criterion in Column B. The returned values need to be in a single cell in a single formula. In the attached Sample image, I need a single ...
0
votes
0answers
16 views

Need Excel sorting formula matching 2 sets of data

I can't figure this out. I need to sort and match 1 data set of 3 or more columns (sample on the left) with another data set of 2 columns on the right. I need to match the right JVA column rows ...
1
vote
1answer
26 views

Adding value to cell based on ending of string in another cell in Excel

I've got a seemingly involved request that I can't seem to wrap my head around. I will try and simplify as best I can... I have a column (A) that contains number values, and a column (B) that ...
0
votes
0answers
43 views

How do I program a excel chart to auto find or tell me the % likely for the next line?

Basically, I'm trying to find a way to get my excel file to tell me what is the % likely the next line is going to be a given set of numbers. https://www.dropbox.com/s/bd4hgyt886p86kk/Data.xlsx?dl=0 ...
0
votes
1answer
27 views

How to make line graph, or bar graph with different categories on excel

I don't know anything about Excel and I've been trying this for over an hour. I had to do an experiment for class that asks if hair color relates to height. I have the hair color and height of 20 ...
1
vote
1answer
17 views

Referencing a range using hyperlink

I'm looking for a solution of hyperlinking a cell. For example: On Sheet one I have details for XYZ from B1 to D5 for ABC B7 to D11. On sheet two I have XYZ and ABC. If I click in sheet two ...
30
votes
9answers
3k views

Limit Excel CPU Usage

Is there a way to limit how much CPU usage excel has access to when running? I have a VBA script that calculates a bunch of giant array formulas. The entire calculation takes maybe 20 minutes using ...
0
votes
1answer
15 views

How do I change the blank template in Excel 2007?

I have created a new template for Excel 2007 and placed in it the C:\Users\[username]\AppData\Roaming\Microsoft\Excel\XLSTART Book. This has worked successfully in that when you open Excel it uses ...
1
vote
0answers
23 views

How can I view the properties of a ComboBox on an Excel 2007 Worksheet?

A similar question has been asked and solved on this forum, but the solution offered there does not work for me. I have enabled the Developer tab, and clicked Design Mode, but still, right-clicking ...
0
votes
0answers
30 views

Change line style for missing values in EXCEL

I'm plotting a chart where some of my lines contain missing values. I managed to interpolate using Select Data -> Hidden and Empty Cells -> Connect data points with line. However, there's no way to ...
-2
votes
1answer
36 views

Excel display time NOW in cells automatically on sheet change

In my A1,A2,...,A10 cells i have this code =IF(B1>0,NOW(),0) So if B1>0 A1 equals to Date time now and all this for B2 and A2 B3 and A3 and so on. But the problem is that if i change for ...
0
votes
2answers
25 views

Applying Filter And Finding The Last Cell - Excel

Sub test_sum() last_row_in_Process_sheet = Application.Workbooks(file_name).Worksheets("ms").Range("a65536").End(xlUp).Row atmCurrentSum = ...
0
votes
2answers
62 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
10 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
35 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
28 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() ...
0
votes
1answer
19 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
8 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
28 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
17 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
21 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
38 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. ...