# Tagged Questions

**-1**

votes

**0**answers

10 views

### Using two Private Sub Worksheet_Change(ByVal Target As Range)

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("B10").Value = "0" Then
Rows("9:12").EntireRow.Hidden = True
ElseIf Range("B10").Value > 0 Then
...

**2**

votes

**3**answers

21 views

### Custom Sort using Excel without Custom List

I want to be able to sort excel rows where data looks like
Column - 1 Other Columns
701-GBL-1843-MLMK blah
566-JJB-2785-MYJW
254-WYD-3220-NAND
884-GLE-2843-FRYA
And I want ...

**0**

votes

**2**answers

19 views

### Expand Excel ComboBox on click

How can I set up my combo boxes on the form i am building to open automatically when clicked on the field portion not just the arrow? I have been searching for a while and I can't seem to find any ...

**-1**

votes

**1**answer

40 views

### How to write Excel macro to copy selected row of data between two sheets?

I'm not really experienced in the whole VBA area, i get how macros work but this is just out of my reach.
Basically as i stated in the title i need to write a macro that will copy the selected row or ...

**0**

votes

**1**answer

20 views

### Automating building a table from web sources in MS Excel 2013

I want to build a table indicating a number of things available in a given market. To do this I access the sites with relevant information and copy numbers to a table each day. I would love to ...

**0**

votes

**1**answer

16 views

### Apply a formula to an entire column since the number of rows is changing from a source file?

I have a connection to a text file source so the excel worksheet updates automatically. Therefore the number of rows is always growing every time it updates. How can I apply a formula to an entire ...

**-1**

votes

**0**answers

14 views

### how to create excel charts having strings in both x axis and y axis [duplicate]

I have a student data with Student Name and their grade (A/B/C/D/E.). Now I want to have a graph for this data.
Description: Hai, I was tried to plot a graph having two fields (NAME and Gradde like ...

**0**

votes

**2**answers

23 views

### Error when value not present

I am using the code below several times over in one sub for different values not just "CPNEC". It works fine where there is a range with that value on the spreadsheet but falls over it the value does ...

**-1**

votes

**2**answers

44 views

### how to create excel charts having strings in both x and y axis

I have a student data with Student Name and their grade (A/B/C/D/E.). Now I want to have a graph for this data.
Kindly help me.

**0**

votes

**2**answers

30 views

### How to shift unique values down a column to the same value in another column?

My friend has two columns where one has unique values and another column has those same values but also duplicated like shown below
Column 1 Column 2
ABC123 ABC123
CDE456 ABC123
EFG789 ...

**0**

votes

**0**answers

19 views

### Excel 2D-lookup on a PivotTable with changing coloumns and rows

I want to do a Vlookup on a 2D pivot table but neither the coloumns and rows of the pivot are fixed and are subject to change due to ever changing data source. How can I perform a accurate vlookup on ...

**0**

votes

**0**answers

15 views

### VBA Compare columns on two diff worksheets, find in 2nd and group on 2nd worksheet

Excel 2010
Hi. I have a 6,000 line spreadsheet and need to group the lines, based on identified roll up points in another spreadsheet (150 roll up points). I want to be able to see the summary ...

**1**

vote

**2**answers

25 views

### String Manupulation in VBA

I have single column that needs to be split to multiple, like Text-to-columns in excel. However there is a small challenge. Conventional delimiter will not work. Consider the string below
Original: ...

**0**

votes

**1**answer

33 views

### How to make a named cell read-only

I would like to make a cell "Cell Name" read-only.
I found this code here but don't know how to use the String value instead of the range:
Private Sub Worksheet_SelectionChange(ByVal Target As ...

**0**

votes

**0**answers

14 views

### Runtime error 9:Subscript Out of Range near end of code at “Worksheets(”UserForm“).Select”

The following code is for a userform, the user having three options, one being less than 70,000 square feet, one being between 70,000 and 150,000 square feet and one greater than 150,000 square feet. ...

**0**

votes

**2**answers

39 views

### Combine Multiple Values into Rows with Blanks

So I researched this for awhile, but I seem to be hitting a wall. I will admit- I successfully did this once, made a tutorial for my coworkers- then I nor anyone else was able to replicate the ...

**2**

votes

**1**answer

30 views

### VBA selecting range in Excel

I can set the range for all of a column such as :
ActiveSheet.Range("A:A")
But I'd like to set something such as
ActiveSheet.Range("A10:A")
but there doesn't seem to be an easy way to do this ...

**-1**

votes

**1**answer

18 views

### Deleting range of cells based on criterea

I have an Excel file with several macros, used for data processing.
The masterfile reads one or more .csv files and copies all data it needs into a tab (lets call it sheet1) within the masterfile. ...

**0**

votes

**1**answer

18 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

**2**answers

33 views

### VBA Excel: How to assign .txt file content to a string type variable?

I made a little sub in excel that sends an email according to the parameters you enter:
Sub Mail_LSP(mailsubject As String, consignee As String, coalcopy As String, mailbody As String)
Dim mlook As ...

**0**

votes

**1**answer

16 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

**2**answers

50 views

### Adding together values from multiple spreadsheets (VBA)

In my Excel workbook, I have three separate spreadsheets. The spreadsheets are identical in format and represent count values for different categories (passenger cars, trucks, etc.). I need to combine ...

**0**

votes

**1**answer

26 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

44 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

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

**0**

votes

**1**answer

9 views

### RE: displaying max of direct data input or cell value from formula

With reference to :
Excel - how to either have direct data input or cell value from formula
I would like to inquire on a related issue.
How would i edit my VBA formula if i would like to compare the ...

**0**

votes

**1**answer

23 views

### Disable or delete right click menus VBA

Whenever I right click on an excel sheet two menus come up: one with cut, copy, paste, etc. and one with font size, bold, italic etc.
I can customize the first one to have whatever command I want. ...

**0**

votes

**0**answers

36 views

### Forfiles SubFolders

I am hoping I can get some help here. I saw a another post similar to my problem and I figured I would give it a try. I have a Forefiles code running in Excel using VBA. The code works great on local ...

**0**

votes

**0**answers

39 views

### VBA Code to update data in closed excel files within a folder by clicking a button

I have a code which works really well that updates values of closed excel files in a workbook. What I want to do is alter the code so I can create a on my worksheet where I can make y changes I ...

**-1**

votes

**0**answers

17 views

### Excel or R: Make 1 file for each line of a table, preserving the headers

I have 200 lines in an excel table that I'd like to split into 200 files (csv), with the headers maintained in each file.
Is there a way I can do this using VBA in excel, or even R?
Many thanks

**0**

votes

**1**answer

48 views

### Expanding a cell formula resolving all its references (precedents)

In Excel I have a cell containing a formula referencing other cells, which reference other cells and so on... forming a large tree of references. I'd like to substitute recursively all the occurrences ...

**0**

votes

**1**answer

27 views

### Excel 2007 VBA Export range as jpg file is trucating picture

I have a workbook with many different ranges of data with 77 lines or more. I need to copy them and save as JPG files, which will be used by other application.
Below is the example of code that I'm ...

**3**

votes

**1**answer

62 views

### show more than 8 items in the Data Validation drop down list in Excel

I have added a simple data validation to a cell but it only displays 8 items in the dropdown.
Excluding the combobox solution and probably involving some WinAPI is there a way to make the drop ...

**0**

votes

**1**answer

53 views

### VBA Lookup by Multiple Criteria - Then Copy & Paste

Currently I have a 2 way database with 10+ fields and 1,000+ rows. Some fields are customer name, car model, year of model, price, date of purchase.
I would like to lookup rows of data by multiple ...

**1**

vote

**0**answers

42 views

### Transferring Data Between Workbooks Based on a Value in a Specific Cell

I have created a form in Excel that moves information entered in the form to the adjacent sheet in the same workbook as well as my agents workbook at a different file path. That piece of the puzzle is ...

**0**

votes

**0**answers

36 views

### VBA Excel: Macro working well, add-in does half of the job

I created a macro that:
1.takes the value in cell "D11" then
2.trims the value acording to some criteria, then
3.opens another workbook ans searches the trimmed value then
4.copies some info to ...

**0**

votes

**0**answers

16 views

### Displaying images from database in a pivot table

I've got a table with sales data on MySql server. I can connect to it from Excel and generate a pivot table just fine. One of the fields in the table contains URL to an image of a product. Is there a ...

**0**

votes

**1**answer

43 views

### Obtaining Frequency of A Number for Each Sub-Heading

I have two columns, one with people and times associated with those people, and one filled with 0s and 1s. For any given person there is some associated combination of 0s and 1s. We can determine ...

**0**

votes

**0**answers

44 views

### Automation of solver in Excel by VBA macro code

I'm solving a 3rd degree polynomial equation, e.g.,
-0.003x3 +0.195x2 -1.087x -180 = 0
in Excel.
I can do this by SOLVER of Excel and can find the value of x.
The problem is the constant term ...

**0**

votes

**1**answer

34 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

22 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

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

**2**

votes

**2**answers

80 views

### How to Programmatically Split Data Using VBA Using Specific Logic

This is an addition to my previous post here. The code that was previously supplied to me worked like a charm, but I am having issues modifying it adding some additional logic.
I am creating a macro ...

**0**

votes

**2**answers

64 views

### Excel concatenation of one column based on values in another

Similar to this: Excel - pivot values in one cell (as comma-separated value)
Except it can be a VBA solution, and I do not have duplicates in Column A. Instead, there are blank rows below each value:
...

**0**

votes

**1**answer

37 views

### Sort with a Macro

I have a spreadsheet with 8 columns of data. (Row 1 contains my headers).
I am trying to record a macro that I do not have to edit afterwards.
I press record macro, I highlight my data, I go to the ...

**-1**

votes

**1**answer

57 views

### How to re-arrange Excel database from 1 long row, into 3 short rows of unequal lengths and automatically repeat the process?

This question is an extension/continuation of my previous question at How to re-arrange Excel database from 1 long row, into 3 short rows and automatically repeat the process? which was answered by ...

**1**

vote

**1**answer

107 views

### How do I copy hyperlink only (and not text) to another cell? [duplicate]

I have a spreadsheet where column A displays names. There are a few hundred names and each has a different hyperlink (which links to that person's web page). I want to transfer those hyperlinks across ...

**0**

votes

**1**answer

44 views

### Set default expand/colapse state on pivot tables

The Setup
I have a pivot table in tabular form pulling data from an Analysis Services Cube.
I want to calculate the number of days between two dates, but the setup will only allow me to pull in all ...

**0**

votes

**1**answer

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

**-2**

votes

**1**answer

58 views

### How to delete specific columns from all excel workbooks in a particular folder

I have a folder in which I have about 30 excel files. In each of these files, I need to delete about 20 specific columns.
Here are some details:
I am using Excel 2013
The columns are in the first ...