All Questions
Tagged with worksheet-function vba
40
questions
11
votes
5
answers
214k
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:
...
- 1,894
3
votes
3
answers
13k
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 no ...
- 31
2
votes
1
answer
2k
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 ...
- 23
0
votes
4
answers
72k
views
EXCEL - How to have a formula output and user input on the same cell?
I would like help from someone as I believe this problem requires VB. I basically have a CELL(A4) where people will be entering values to find out the corresponding calculations displayed below.
...
- 3
16
votes
7
answers
62k
views
Custom Formula Not Updating
I followed this guide to create the following custom function which counts the number of cells of a certain colour in my spreadsheet:
Function ColorFunction(rColor As Range, rRange As Range, Optional ...
- 163
3
votes
1
answer
19k
views
Excel Large Function with Duplicates
I'm trying to apply a LARGE function to get the 5 largest values from a column ignoring duplicates. I did some searching around and found some proposed solutions but they don't seem to work for me. In ...
- 518
2
votes
3
answers
13k
views
Listing non-blank cells in Excel based on adjacent column(s)
Given columns A and B, I want to list the A-values that have a non-blank B-cell in their row, in column C:
A B C
One Two
Two x Four
Three
Four x
...
The best I came up with so ...
- 133
1
vote
5
answers
17k
views
How can I tell if sheet a exists in a workbook?
I have the following code that's not working as expected:
If Sheets("a") <> "" Then MsgBox ("sheet a exists")
How can I tell if sheet a exists in the workbook?
- 510
0
votes
1
answer
2k
views
How to create a source and destination worksheets in Excel?
I am struggling with an excel feature regarding creating a Source and Destination workbook.
My Source data comes from the web. So I download it, create few new columns and functions and use it to make ...
- 1
-1
votes
1
answer
11k
views
excel vba: copy rows if data match with values in column in another sheet
I have ask a related question here.
Sir Adelaide has provided me this very useful solution.
So now, in this almost similar case, I have 2 excel sheets in my workbook.
[Xsheet][1]
Sheet1
I'm gonna ...
- 47
4
votes
1
answer
41k
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 ...
- 41
4
votes
1
answer
13k
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 ...
- 639
4
votes
1
answer
7k
views
In Excel, doing a "Freeze Panes" on the right-most column instead of the left-most?
My understanding of Excel's "Freeze Panes" feature is that you can only freeze the left-most column(s), or top-most row(s).
However, I have a table where a very important column needs to be located ...
- 197
3
votes
1
answer
1k
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.
...
- 31
3
votes
1
answer
326
views
Transpose unique rows to columns while IF statement conditions are met but do not consolidate
Current State:
A B C D E
FG Component FieldKey Cost$ Qty
7120 7120 1220 $4.71 9,783
7120 9907062 1220 $7.80 4,061
7120 ...
- 45