# Tagged Questions

**1**

vote

**1**answer

20 views

### VBA + Polymorphism: Override worksheet functions from 3rd party

my company makes extensive use of a data provider using a (closed source) VBA plugin. In principal, every query follows follows a certain structure:
Fill one cell with a formula, where arguments to ...

**0**

votes

**1**answer

24 views

### Get result of formula as text

I have an Excel doc which populates a matrix using formula, for example;
| A | B | C
1|=1+2 |=2+2 |
2| | |=4-1
would display as;
| A | B | C
1|3 |4 |
2| ...

**1**

vote

**1**answer

35 views

### Working with cell addresses in excel with VBA

I have a Excel sheet in which are multiple forms. The forms look all the same and they have exact the same cells between them. They are ordered in 4 x 3:
x x x x
x x x x
x x x x
x x x x
....
There ...

**0**

votes

**1**answer

25 views

### Error outputting a string to cell

I am using a vba macro to automate part of an excel spreadsheet. The following line keeps giving me a runtime error 1004# application or object defined error
Sheets("Material").Last.Offset(0, ...

**0**

votes

**1**answer

20 views

### Deleting rows that contain a keyword in the column

I have an excel file that has a id as one of the columns, each id has multiple entries and follow a set of survey questions. I need to delete all of the rows that have that keyword (which is in a ...

**0**

votes

**1**answer

35 views

### Excel: portable formula to reference data on previous (relative) worksheet

I need to create a fairly simple Excel spreadsheet (workbook). I need 12 sheets (tabs), one for each month.
Each sheet references cells in the previous sheet. For example, the "May" sheet is ...

**2**

votes

**1**answer

63 views

### Replace cell references with values without F9 using macro

This is an Excel macro question. Given a series of formulas such as the following:
= A1 + A2
= B2 + B2
etc., ...
I would like to replace each of these cell references with the values without ...

**0**

votes

**1**answer

69 views

### Hide columns based on content (sum of rows)

I'm trying to hide columns based on the sum of selected rows (i.e., cells) in those columns.
For example - if the sum of E9:E12 is 0, then hide column E.
Additionally, and probably a little harder - ...

**1**

vote

**2**answers

48 views

### Excel 2010: Calculate full months between dates

I have dates in two columns and I would need to calculate amount of full months between two dates.
I export the spreadsheet from SAP ERP in .xls format but opening with Excel 2010. DATEDIF function ...

**0**

votes

**1**answer

38 views

### Convert formulas in table to structural references

I have converted my range in excel 2010 into a table. However, the formulas which were before like that(see below) stayed the same and do not convert into structural references.
...

**0**

votes

**2**answers

29 views

### Showing name of row instead of excel cell name

I am having extremely long formulas over an extremely big sheet. At the moment I am tracking the formulas with the Formula Auditing Tool. However, my idea would be to just replace for example in a ...

**-1**

votes

**1**answer

109 views

### Compare the value change of data in Excel between two similar sheets without VBA?

I need to match data in the column A's of two different sheets with similar data and then compare the values in column C. sheet 1 features data from this month, sheet 2 from last month.
I have column ...

**0**

votes

**1**answer

60 views

### Months and Date keep being switched around when running VBA

I have a column on my sheet, Column F which is full of dates. Now I need these dates to be in this format "dd,mm,yyyy" but sometimes they are in text form, us/armenian format in the original data. Why ...

**1**

vote

**1**answer

35 views

### Clear contents from matched column of data in another sheet

I have a column of email addresses on sheet 2 col A (but I could put them on sheet 1 if it would make it easier / faster) that I want to remove from sheet 1 col D if matched (there may be 2 or more ...

**0**

votes

**1**answer

72 views

### How to require a cell input if another cell has a value

I'm trying to edit the VBA for one of my workbooks so that If there is a value in column A, then a value for column C is required or else the file won't save, but i'm having some trouble with this. I ...

**0**

votes

**1**answer

110 views

### VBA Solution to VLOOKUP with Hyperlinks

I am looking for some help with a VBA solution for preserving hyperlinks when using VLOOKUP on Excel (2010).
I have a load of data on Sheet 1 for internal use only, and a cut-down version of this ...

**3**

votes

**1**answer

379 views

### Add/Subtract button Excel VBA

Here is an example of my project in this picture
I like collecting, so I am making an inventory sheet in Excel.
I want to make a way that I can click a button and it affects the next, or previous ...

**0**

votes

**2**answers

769 views

### Searching for a value in Excel, returning yes or no

I have one workbook, with two separate worksheets. I want to know if the values that appear in worksheet B also appear in worksheet A, if so, I want to return a "YES". If not, I want to return a "NO". ...

**1**

vote

**3**answers

79 views

### Trouble using Excel OFFSET function

I have an Excel workbook with numerous sheets entitled "Week1", "Week2", "Week3" ... "Week7". Each week, I input the customers IDs of people buying my product in column C, and -- as I am interested ...

**1**

vote

**1**answer

85 views

### Excel - Change cell colour based on a date in the comment or mixed in with text

I am using excel 2010 and I am trying to set up a rule that will change the colour of a cell based on a date within that cell.
For example the cell may contain Site meeting - 11.05.14
I would like ...

**3**

votes

**3**answers

122 views

### Custom user function without using VBA

Is it possible to create a custom user function in Excel without using VBA?
My problem is I have a long string of standard excel functions strung together to make one very long function.
This function ...

**0**

votes

**1**answer

131 views

### Can Excel's Find formula have multiple find_text criteria?

I have a list of names on a NAMES tab range A1:A100.
On another tab 'Data Export', in column A I have an export of thousands of comments where one of those names from the NAME tab can be found within ...

**1**

vote

**1**answer

268 views

### Excel 2010 VBA only affecting last row in range

I have some VBA code written in Excel 2010 to force padding around the rows in a table, but part of the code only affects the last row in the range. Here's the full code:
Private Sub ...

**0**

votes

**2**answers

258 views

### Excel 2010 formula, How do I write this formula? (VBA)

I need a bit of help from the more experienced Excel VBA users.
Basically I have 2 groups of 3 cells (6 cells total)
If one group of 3 cells is filled in it needs to accept it and not return a ...

**0**

votes

**1**answer

451 views

### Updating another Excel spreadsheet from current spreadsheet

I used the VBA code in "How do you write an Excel formula that will paste a specific value in a different cell?" posted here in May 2013 and it works well to populate/fill another cell in the same ...

**0**

votes

**1**answer

162 views

### Insert columns, within a range, based on cell reference

So am trying to tell VBA to insert a certain number of columns between two other columsn based on a cell reference.
I've managed to get excel to insert columns within my range:
Sub INSERT()
...

**0**

votes

**1**answer

59 views

### compare and update spreadsheets

Please I need some help with excel spreadsheet here. I have two worksheets, one holding the old records and the other holding the current record. What I wish to do is to develop a vba code associated ...

**2**

votes

**1**answer

137 views

### Excel VBA code Private Sub Worksheet Change Power function not working

I'm making a worksheet where the wind speed defines the potential energy of the location. This value is the basis of a few sheets in the same Excel file. I'm trying to write a code that where I10 is ...

**0**

votes

**1**answer

162 views

### Generate ordered numeric list in Excel based on cell value

I'm not sure if this is possible, but I would like to create an ordered numeric list automatically based on a cell value. For example, if I have a cell with a value of 100, I want excel to ...

**2**

votes

**0**answers

265 views

### Splitting an excel 2010 spreadsheet into multiple workbook files based on column value

I find and clean a lot of contact data, sorted by country, which I am currently using excel to manage. Mainly because it is easier to clean and manipulate the data I find this way, and I can easily ...

**1**

vote

**1**answer

113 views

### Need a Excel script to identify email addresses that contain a different variation of the first name of the contact

I have an Excel spreadsheet with 50k+ rows of data, where we are trying to identify within the rows of data where the email address has no match of the first name, etc.
We are basically trying to ...

**-1**

votes

**1**answer

31 views

### Need Macro to perform formula based on cell not number

I am working on a budget workbook and in column I (I5-I1135) I have numbers that I need to upon prompt (such as CTRL C) have the numbers divide by 10 then multiply by 12..
Example:
cell I5 has ...

**2**

votes

**1**answer

145 views

### excel vba: to export multiple excel sheet into its designated jpg file

I am working on an excel vba command to export multiple excel sheet to its designated jpg file.
I have 16 worksheet in one excel workbook and it would be best to export each sheet into jpg format.
...

**0**

votes

**1**answer

309 views

### Excel formulas for budgeting sheet (or VBA code)

I'm (an amateur) and I'm creating a sheet to help me with Budgeting. I've got bills that I can enter, but that come at a variety of different intervals. I'd love it if I could enter the total from ...

**0**

votes

**1**answer

97 views

### Excel 2010 - Show cell contents - wrong number appearance

I was trying to create a simple function in Excel VBA editor. When I click on a cell within the certain range, I want to copy its value into another cell I have set.
Private Sub ...

**1**

vote

**2**answers

298 views

### Excel formula/VBA to detect a property of a group of rows

I have a large dataset in an Excel sheet where:
column A: quote number
column B: opportunity number
column C: sales order number.
One quote number will have multiple opportunity numbers. A sales ...

**0**

votes

**0**answers

78 views

### IF word in A1 matches word in Col C AND word in B1 matches word in Col E AND

Cell A1 contains a paragraph made of Hebrew words (They are Bible verses in Hebrew, so sometimes more than 254 characters long in each cell).
Cell B1 contains a paragraph of English words (They are ...

**0**

votes

**1**answer

128 views

### Move rows to new sheets in excel

I'm having a problem. At my work we often get spreadsheets with locations. We need to spread out each of the locations to a different worksheet. Because then we list nearby businesses to advertise to. ...

**0**

votes

**1**answer

383 views

### Find and Replace VBA/Macro in Excel 2010

Another Excel VBA question. I'm using Excel 2010
I want to create a Macro that will remove the following 3 symbols in any cell for a selected range:
[ ] "
For example; If I select a range of ...

**3**

votes

**1**answer

141 views

### Excel macro copy same entries once in another sheet paper

I'm really new to VBA Excel.
Let's say I have paper 1 with in column A many alert types, and column B the place where it happened (I'm working for a security company). What I need to do is read ...

**0**

votes

**0**answers

418 views

### Using VBA how can I reassemble Excel worksheets in different workbooks while maintaing the format?

I am struggling to complete this code successfully.
Basically I have a master workbook which has defined range names. The first range is the header followed by a number of ranges (section1, section2. ...

**2**

votes

**2**answers

118 views

### How to create number +1 from the previous sheet

I want to copy single sheet to multiple sheets in the same workbook with macros,I know how to do it but I still have further question.
I am using formula:
Sub Button3_Click()
Dim x As Integer
Dim y ...

**-1**

votes

**1**answer

97 views

### How to fill Excel 2010 Cells with a recursion idea

What I'm trying to do is have cells auto populate and un-populate dependent on the value of another cell.
For instance, Cell B3 has a set value of -0.1, Cell B4 has a set value of 0. Cell D3 is the ...

**0**

votes

**1**answer

216 views

### Updating a table in Excel when a new line is added

I have a problem and I find it very hard to explain, but here goes:
I have an excel sheet in which one of my employees needs to enter his data.
This data is used to calculate an average value (among ...

**-1**

votes

**1**answer

346 views

### Is it possible to build a cumulative formula that will sum on new worksheet added daily?

I have a worksheet that the user opens each day and clicks a button that copies the current sheet to a new sheet and renames (Day 1, Day 2, etc.).
I want to keep a cumulative count in some of the ...

**1**

vote

**1**answer

1k views

### LINEST function in excel vba

I am trying to figure out the 2 order equation (Y = ax^2 + bx + c) for a set of data values. When I use the inbuilt function in excel
=LINEST(C2533:C2537,B2533:B2537^{1,2})
I get the following ...

**3**

votes

**2**answers

5k views

### How to implement MATCH and INDEX functions together in Excel VBA?

I am trying to find the row number of the first cell that is less than zero.
So, by browsing through the net I was able to come up with this formula which works perfectly fine:
...

**0**

votes

**3**answers

474 views

### How to update cell references when setting the Formula property in VBA?

Here is a snippet of my code:
For i = 1 To k
If Range("D2").Offset(i, 0).Interior.ColorIndex > 0 Then
Else
Range("D2").Offset(i, 0).Formula = Range("D2").Formula
The ...

**1**

vote

**2**answers

554 views

### Passing Range to ABS function in VBA

I would like to perform a function which looks like this
Selection.FormulaArray = "=GEOMEAN(ABS((C646:E646)))"
Since my range keeps varying I would like to pass the range as a variable which looks ...

**0**

votes

**1**answer

356 views

### Creating multiple plot per level of factor (trillis graph) in excel

Is there way to automate the process to make graphs like the following (also known as trallis graph) in excel ? I know there are some R interface with Excel (some of them need to be purchased), but I ...