**2**

votes

**1**answer

22 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

**0**answers

17 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

**1**answer

28 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

**1**answer

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

**0**answers

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

**1**answer

58 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

**0**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

323 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

**2**answers

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

**0**answers

29 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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

18 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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

25 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

**0**answers

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

**1**answer

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

**0**answers

42 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

**1**answer

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

**1**answer

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

**9**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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.
...