# Tagged Questions

**2**

votes

**3**answers

34 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

49 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

60 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

79 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

51 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

49 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

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

**1**

vote

**1**answer

115 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

50 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

164 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

85 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

25 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

95 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

171 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

65 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

239 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

68 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

78 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

352 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

134 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

401 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

101 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

72 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

**0**answers

39 views

### How can I get this subroutine run when “yes” is selected?

Below is a code that I now have working, It takes the sheet "INITIATING DEVICES" and searches for column "G" if column "G" has a value of "Yes" then it will copy that row, only columns "A, B, C" to ...

**0**

votes

**1**answer

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

**0**

votes

**0**answers

64 views

### Update Excel table with newest available information and put old information on separate sheet

I have combined several worksheets into one master spreadsheet. Unfortunately, each spreadsheet parts of the original spreadsheets had complete information. I need to clean up my information. What I ...

**-1**

votes

**1**answer

257 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

823 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

4k 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

375 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

424 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

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

**0**

votes

**2**answers

998 views

### How can I turn a Calculated Column back into a data column in an Excel Table?

I have a large Excel Table (44 columns, 1000+ rows), but one of the columns has been accidentally turned into a Calculated Column (See Here). The result being that now when the users try to add new ...

**4**

votes

**2**answers

858 views

### Excel - concatenating cells where reference number matches [duplicate]

I have a worksheet with many rows. Some of the rows share reference numbers (contained in, say, column A). What I'd like to do is, where a row shares a reference number with another row, I'd like to ...

**2**

votes

**1**answer

143 views

### How to programmatically stylize part of a string in a calculated cell

I have a cell that contains something like this:
="String of text that's moderately long" & YEAR(NOW()) & "."
I want to know if there's any way that, via macro, I can colorize/stylize PART ...

**0**

votes

**1**answer

237 views

### Transpose table to a single-column list

So I have a table full of data which looks like this:
Subject A Subject B Subject C Subject D Count
Person A F F F 3
Person B F ...

**2**

votes

**2**answers

289 views

### Auto Updating an Excel Filter

Firstly I'm using excel 2010.
I have had a look at other "auto-update" and from what I saw they wanted you to type some information in to make it "refresh" the auto-update.
Essentially what I have ...

**0**

votes

**1**answer

140 views

### Creating a Macro or Formula to copy data through a query

Here is my formula that I'm looking to build off of:
=IFERROR(VLOOKUP($A1,Table2,10,FALSE),"")
I don't know if I can use just a formula or if it has to be a macro. I am trying to create a query ...

**3**

votes

**2**answers

2k views

### Excel: conditionally format a cell using the format of another, content-matching cell

I have an Excel spreadsheet where I’d like to be able to create a “key” of formatted cells with unique values, and then in another sheet format cells using the key formatting.
So for example, my key ...

**2**

votes

**1**answer

175 views

### Show (copy) data at “X” time and stop update

I have two sheets.
In the first sheet, cell F4, I have 00:00:00 (countdown). G9, G10 and G11 are cells that receive live data (decimal numbers).
In the second sheet, I have three cells linked from ...

**0**

votes

**2**answers

2k views

### Using an insert if formula in excel with 3 conditions

Trying to do an insert if formula in excel like the following:
In my column K I want three conditions:
Date is Today or older (ie project is due today or earlier) = RED
Date is Today + up to 7 days ...

**2**

votes

**1**answer

446 views

### How to have a cell calculate only once

I have cell N29 calculating some values based on streaming data. Once a condition is met in cell Q29, the calculation or final value should be passed to cell O29 and no longer calculate in either ...

**0**

votes

**1**answer

2k views

### Selecting the date of every Monday and Wednesday from a date range

I need a formula or a macro to help automate a grade sheet's dates.
We have class every Monday or Wednesday only. I would like to vlookup from an input table of each quarter's date range, for ...

**1**

vote

**3**answers

2k views

### How do I transpose data in columns to rows?

How do I transpose data in columns to rows?
If the data is:
Joe
some city
some state
Bob
no city
no state
and I use Paste Special » Transpose, I get
Joe some city some state Bob ...

**6**

votes

**4**answers

33k views

### How to combine values from multiple rows into a single row in Excel?

I have a data dump in Excel that consists of annual customer data for two different values. The data was provided with a separate row for value for every year and customer. I.e. it looks like this:
...

**2**

votes

**2**answers

2k views

### Excel VBA Function for Value AND Format Lookup

I need a custom function to lookup both a cell value and copy the source format. I have a list of values in two columns. The first is of integers and the second column is the corresponding text ...

**1**

vote

**1**answer

2k views

### Prevent Excel 2010 user from pasting formatting into cell

Is there a way to lock a cell so that a user can copy/paste a value into it, but not copy formatting to it? Locking the worksheet doesn't prevent the user from changing the formatting of the cell by ...

**0**

votes

**2**answers

2k views

### Pass values instead of range to VBA Function

I am creating VBA functions in Excel 2007. One has a prototype:
Function ToLevelCode_Range(val As Double, ByRef R As Range)
I can call it this way just fine and it gets the correct result:
...

**1**

vote

**1**answer

3k views

### excel 2010 vba macro ActiveCell.Formula = produces an empty cell when run

This macro formula (in a loop to place a Vlookup formula for each newly inserted worksheet) results in an empty cell when run:
ActiveCell.Formula = "=VLookup(""Total Other Operating Expenses"", ...

**3**

votes

**3**answers

680 views

### Is there a way to set the name box of a cell programmatically in Excel

I would like to programmatically set the name box of a cell in a worksheet I'm working on, either through a formula or through a macro. The end point is that I don't want to set it by hand.
In my ...