**1**

vote

**0**answers

13 views

### How to add data vertically while xtracting tables from web page to excel

My code
Public Sub Raju()
Dim alertTime As Date
alertTime = Now + TimeValue("0:05:00")
'
' mymacro Macro
'
Dim ws As Worksheet
Set ws = Worksheets("Sheet1")
...

**0**

votes

**0**answers

7 views

### Copying Conditional Formatting rule to range of cells and automatically updating the cell references

I wanted to apply Conditional Formatting to range of cells A2:A30 using a formula =Countif(A2:A$30,A2)>1. It works and gave the desired result. However when I go to any cell other than A2 and click ...

**0**

votes

**1**answer

10 views

### Excel scatter plot with two x series and one y series

My data consists of a y value and the two x values that can be used as inputs to a quadratic equation to give the y value. I'd like to plot them, ideally with separate colours for the positive and ...

**-1**

votes

**1**answer

17 views

### How do you consolidate “date. Time1 and Time2”? [on hold]

How do you consolidate "date. Time1 and Time2"
For example:
A B C
1 Date Time1 Time2
2 09/04/2016 05:03:15 AM

**0**

votes

**1**answer

30 views

### Mirroring formulas to multiple sheets in Excel

I have an Excel Workbook with multiple Sheets each using the identical layout, but with different sets of data. From time to time, I need to vary the way the values are calculated, but I don't want ...

**0**

votes

**0**answers

12 views

### Excel Help - how to pass the in SQL Query from another cell [on hold]

I have SQL query in one Cell and Query data from the another cell
Example. Below Query internal ID i need to pass the another cell.please some one help me, how to pass the values.
{
...

**0**

votes

**1**answer

25 views

### How Can I make an excel column of Hyperlinks open in NON default browser

I have a ms excel 2007 worksheet with a column (A) of hyperlinks using the excel function in this way =HYPERLINK(A2,"url".
How Can I make (if this is possible) open all cels on that column in the NON ...

**-2**

votes

**0**answers

22 views

### Why data is getting copied in the same row?

Found this coding online and tried to use it for one of my workbook. This is not the exact coding as I needed to tweak as per my data.When I click on the button(Macro) 1st time it's correctly moving ...

**0**

votes

**0**answers

12 views

### I am looking to reverse lookup missing numbers from a VLOOKUP in Excel

Hi please let me know if this is a duplicate but I did a brief search and did not find anything that wasn't a ton of code that I couldn't relate back to my spreadsheet.
I have excel 2003-2007.
I ...

**0**

votes

**1**answer

39 views

### MS Excel - I wish to count unique values based on a parent column

I am very new to Excel. I need some help in counting unique values in each of three columns (considering them only one at a time) with respect to a parent column (the first one (A) in the image). Can ...

**3**

votes

**1**answer

32 views

### does Excel copy only visible cells when a filter is enabled

According to MS doc
excel 2007 https://support.office.com/en-us/article/Copy-visible-cells-only-6e3a1f01-2884-4332-b262-8b814412847e
excel 2013 ...

**0**

votes

**2**answers

24 views

### Apply Custom Number Formatting to Error values

I'm trying to apply a custom number format to cells in Excel 2007 that return an error value.
I understand that I can apply custom number formatting to number/text values in the form ...

**-2**

votes

**0**answers

20 views

### Excel VBA - Combining daily data into monthly data [closed]

I am very new to VBA. So, my problem is that each day I have a file containing a list of products (with their respective code) with their total volume sold and the value of each product sold ($).
I ...

**1**

vote

**1**answer

82 views

### Is there an English Office Language Interface Pack?

Located in France, I have only access to a French version of Excel and would like to change it to English for programming purposes. I want to use this model, based partly on Excel VBA code. Currently ...

**1**

vote

**2**answers

30 views

### finding multiple values in one column and replace values in another column

I want to find values in one column and replace values in another column in sheet2.
My data is in sheet1.
How do I find and replace value?
I tried the following formula but it is not working.
...

**0**

votes

**1**answer

33 views

### Excel weight calculations

I'm really new to excel and was wondering how I could take the info below and if one of the items was not a full box, and contains say 5 eaches of that product instead of 40, how I could enter that ...

**1**

vote

**2**answers

27 views

### Compare groups of cell values according to column headers, in 2 different tables.

I need to compare a group of values in Table A to another group of values in Table B. If the column headers (the name of the columns in each table) are the same in both tables, then the respective ...

**-1**

votes

**1**answer

37 views

### How to extract only specific numeric values from a range of data in MS Excel?

I have a range of data say a1:a100 in which there exist mixed up numeric and alphabetic values.
I want that only the numeric values which are greater than 1 and lesser then 10000000 (i.e. falling ...

**-2**

votes

**1**answer

32 views

### Linking Data in Excel

What is the easiest way to do the following:
I have a list with 4 columns (customer name, invoice number, invoice date, invoice amount) and in another spread sheet I want to enter the invoice number ...

**0**

votes

**1**answer

23 views

### Reference formula 'Text' within another cell in Excel [duplicate]

I would like to insert text from a cell into a formula.
For example, using the formula:
=LOOKUP(A1,'Sheet2'!B2:B10, 'Sheet2'!D2:D10)
I would like to change 'Sheet2' to some other reference (i.e. ...

**0**

votes

**1**answer

37 views

### Remove words in a cell that are already in another cell

I have Business names in column A and descriptions in Column B. this descriptions included business names also. Example:
Column A: McLain Homes
Column B: McLain Homes Est in 1990 McLain ideally ...

**0**

votes

**1**answer

20 views

### Count specific assets (one column) which belongs to unique users (depending on another column)

To get the total of In Stock. I used this formula and it works. but this formula works for specific text.
=SUMPRODUCT((A2:A6="In Stock")*(B2:B6="Laptop"))
I need simpler formula to count rest ...

**-1**

votes

**0**answers

50 views

### Java Installer crashing when accessing VBA code

I work usually with DDE Excel.
I have two computers, one with Windows XP and another with Windows 10 64 Bit. The problem happens with the latter computer.
I connect the computer with provider DDE ...

**0**

votes

**1**answer

39 views

### Spreadsheet formula for adding all values adjecent to multiple instances of text cells

Given a table with unique and duplicate text values in a column with number values adjacent in the following format:
A|12
B|23
C|98
A|66
D|86
E|3
B|25
A|65
.
.
.
The values are simplified for the ...

**0**

votes

**0**answers

21 views

### How to insert online pictures into excel with VBA

I want to add images from my web image repository so I have all the hyperlinks in row 3 (C3:L3) and in row 2 (C2:L2), I would like to automatically insert the image whenever I press the Display image ...

**-2**

votes

**0**answers

14 views

### excel formula - suming multiple columns of one row in an index

i want to sum 10 columns of data. I do not want to just sum based on the cell reference. I want to sell based on name ranges. However, I don't want to type all 10 named ranges into the sum box.
I ...

**0**

votes

**0**answers

20 views

### Conditional formatting of “difference lines” in a 2 series chart

I have 4 columns of data:
1st column is the name of the Route
2nd column is Time1 in decimal hours
3rd column is Time2 in decimal hours
4th column is TimeDifference in decimal hours (or decimal ...

**1**

vote

**1**answer

26 views

### Pie Chart in Excel, is it possible to have a slice for a remaining balance?

There is a budget for each employee to use on expenses. We keep track of expenses throughout the year as it gets used. At the end of the year, a lot of these budgeted dollars do not get spent and i'd ...

**0**

votes

**1**answer

74 views

### Excel: How to Group Dates Per Week in Line Graph

I have data that looks like this:
Actual End Date ----CP
2016-04-22------------4
2016-04-26------------3
2016-04-26------------9
2016-04-22------------7
2016-04-26------------6
...

**0**

votes

**3**answers

31 views

### Leaving a cell blank in excel, or display a different cell

I've tried to read the other posts and follow but I just can't wrap my head around this formula.
I would like F9 to:
be blank if no data is entered in D9
if data is entered in E9, then D9*E9
if ...

**0**

votes

**0**answers

31 views

### Excel converts comma delimited to tab delimited when saving [duplicate]

I create data in Excel 2013 and save it as .csv. We have an application that imports files of type .address so after saving the file as customer.csv, I change the extension to customer.address. This ...

**0**

votes

**1**answer

19 views

### Values need to copy from Col A to Col B in Excel without data loss

In my Excel, I have 2 columns For Ex: Col A & Col B.
In Col A I have 100 Records but in Col B having only 50 records that is scattered not in sequence.
I have to copy and paste the same ...

**0**

votes

**1**answer

18 views

### Sort data on repeat sequence

I want to order the data of my spread sheet on a repeat sequence
Actual
a a a b b b c c c
Desired
a b c a b c a b c
Any suggestions are much appreciated

**0**

votes

**0**answers

29 views

### Excel 2010, “Runtime Error '32809': Application-defined or object defined error”

I am having this error when I open up certain workbooks that contain macros. The files are stored on a network drive and this error only happens on a few computers which leads me to believe the ...

**1**

vote

**1**answer

55 views

### Excel IF formula using before or after date and amount

I need help writing a formula for the following. superuser sample
I hope you can see my image, and I explain myself well enough.
I want column L (my new column) to display column I(dollar amount) ...

**0**

votes

**2**answers

11 views

### Looping through two column to check for condition

I want to loop through column P and see if there is a cell that has the number "1" in it then at the same time loop through column N to see if there is also a number "1" at same row/column, if there ...

**0**

votes

**1**answer

59 views

### Check excel cell if font is a certain color?

I want to use vba to check if the text in a cell in excel is of a certain color, lets say red. Any ideas?

**0**

votes

**0**answers

27 views

### Excel 2007: Why #REF!+#REF!=number in evaluating formulas?

Total A.xlsx contains formulas adding cells (without the help of functions, just the "+" sign) from several files named 01 A.xlsx, 02 A.xlsx and so on.
All files (including the total) are in the same ...

**0**

votes

**1**answer

24 views

### Excel: How to check values in mutiple rows which mark values per day and highlight row with the earliest entry

I have a database wich shows value assigned to each customer in each week of the year. What I want is to have highlighted (i.e. marked with X, at the very end of my report) the earliest week on which ...

**1**

vote

**1**answer

28 views

### Why can Excel 2007 not calculate sub formulas right? [closed]

I have the simplest possible scenario:
open a new Excel 2007 document
In the first row put 6.99
In the second row put 4.99
In the third row put =A1*0.4
And in the fourth row =SUM((A2-A3)/A2)
This ...

**1**

vote

**1**answer

72 views

### What is the Excel Formula to calculate based on consumption and rate

I need help to come out with a solution for this:
Actually I want to calculate my electricity consumption. as the attached pic. the first consumption 0-200kwh, rate $0.218, for 201-300 consumption ...

**0**

votes

**1**answer

41 views

### Change name box of a image inserted into excel worksheet

When you insert a picture into a excel worksheet, you get automatically Picture 1, Picture 2, and so forth...... I have a function when a picture is selected to put black border around it. Problem is, ...

**0**

votes

**0**answers

29 views

### Excel 2007 Unprotect Sheet prompt in password protected sheets on Windows 7 machines

Windows 7 users of software I created in Excel get an "Unprotect Sheet" prompt when clicking on any sheet or cell in a sheet that is password protected. They hit cancel, sometimes several times and ...

**1**

vote

**1**answer

30 views

### How to plot a complex table relation on excel?

How can I generate a table as displayed in the image attached using Microsoft excel. The x and y axis in yellow are simply perfect squares while The table content is composed of axis sums. I cannot ...

**-1**

votes

**1**answer

20 views

### Excel - Check if there is a match to a cell in the rest of the workbook

I've got a workbook that has spread a list across 10 different worksheets, but the list has become out of date. I'm trying to find out which of those in the new list aren't already included in one of ...

**0**

votes

**3**answers

43 views

### Vlookup to check all values before returning value?

i have this Project, I have to check values from a different sheet and copy the value of the Cell beside it.
Sheet 1
Billy
Paul
Mike
Jesse
Sheet 2
Billy |
Paul | X
Jesse |
Billy | X
Mike | X
I ...

**0**

votes

**2**answers

53 views

### Removing Space in a number

I have gone through many solutions for removing of space in a number but my data is as below:-
( 76,120.04 )
Here space in staring of number, after comma, & ending of number also. So in this ...

**0**

votes

**2**answers

35 views

### Excel VBA Run-time error 9 subscrit out of range

While closing the workbook I am getting:
Run-time error 9 subscript out of range
This is the VBA code:
Set wbk = Workbooks.Open(path & filename)
...

**0**

votes

**1**answer

45 views

### Excel highlight row if 2 cell values match

if I have cell D2 (input value 100) and M2 equals the value from another sheet and that value matches the value of D2 how do I highlight the whole row not just the cells?

**0**

votes

**1**answer

27 views

### How do I copy elements from one sheet to another?

This is a slightly complicated question because it has two dimensions.
I have a row of formulas in one sheet in a workbook in Excel. I want to copy the numbers in that row as a column to another ...