All Questions
Tagged with worksheet-function vba
575
questions
0
votes
1
answer
260
views
Keep VBA code working if I run it from a button in another sheet, or replace the code with formula
I'm trying to sort the date in an excel sheet, I want to click on a button to do this, but button is not at the same sheet
I assigned the macro in a button in the same sheet, it worked very well, but ...
0
votes
2
answers
1k
views
Create a macro that automatically updates time & date but doesn't change when I type in other cells
At my job we have this CSR sheet that we use for self service.
The idea is you fill each row as a call is taken every day
and then email it to our boss.
I put an example of the sheet at the bottom.
...
-2
votes
1
answer
421
views
Consolidate first letter in single cell [duplicate]
Have been looking for a while and can't find a solution.
I am trying to find a way to consolidate the first letter in single cells using a formula/vba. I am new to excel and vba but slowly learning.
...
1
vote
1
answer
223
views
Use Cell references within SUM function (Excel)
I am trying to create a function in one sheet, that sums up information on another sheet and as I will be running this multiple times with different datasets, I need this to be flexible. I am trying ...
0
votes
2
answers
757
views
Merge Rows and Sum Single Value in Excel
I want to merge rows with mostly similar data but sum their quantity values, using the unique "id" value while keeping the rest of the data in the row intact.
The raw output looks like this:
...
0
votes
1
answer
461
views
VBA code to auto hide rows based upon text in cell A1
I cannot seem to get my code for this sheet to work properly.
I have code in there functioning fine which will hide rows based upon whether cells in a range are empty.
However I would like to ...
0
votes
2
answers
2k
views
Move data from multiple columns into one and remove duplicates
I currently have a situation wherein I require the unique data from multiple columns to be moved/identified in one single column.
The data currently looks like this:
Apple
Microsoft
Dell
U.S
U.S
...
0
votes
0
answers
232
views
Count dependents in other sheets VBA
I want to count the number of dependents of a cell in same sheet as well as in other sheets using VBA.
I have used below code and results are in the picture.
enter image description here
Sub tst()
Dim ...
0
votes
0
answers
70
views
How to Insert an autofilter if cell in row range contains value
I'm trying to create a function that inserts a filter within a cell range if a cell contains a value
Here is my code:
Sub FilterFunc()
Dim i As Long, lastCol As Long
Dim rng As Range, cell As ...
0
votes
1
answer
385
views
Excel - Transfer inputs from one sheet to another sheet to do calculations and returns a value
I'm just wondering if I could link the two sheets in Excel where you can transfer inputs from Sheet 1 to Sheet 2 to do some calculations and then return a value back to Sheet 1.
See the attached ...
0
votes
1
answer
71
views
How to sort 3 unusual type of dates in Excel?
I have 3 types of dates in my excel files. These dates include the above : Q (quarter), Apr (Abbreviation or abbreviated name of the month), April (Full name of the month). These are combined with the ...
0
votes
1
answer
297
views
How to change order of values in Excel?
I want to edit arrangement of values entered in a column and separated by a semicolon.
For example this is a very small sample of my files:
And now i want to convert to this:
Note:
Always the first ...
0
votes
1
answer
948
views
Excel: How do I list all the values in that column based on dynamic column header name?
This is my scenario, The "Creative Direction" Sheet is a template that I give to my clients. When it is returned to me, they've added extra columns in between of my columns. It takes a long ...
2
votes
0
answers
332
views
Excel: Multiple Selections in one drop down/one cell possible--perhaps using a listbox?
The current problem I have has to do with tagging multiple categories to an a list of items in Excel. A rough example is shown below, with the second column being the CONCAT column that takes in data ...
1
vote
1
answer
710
views
In-Cell Calls to Excel VBA Functions Not Updating
I am having difficulty with a VBA function called from an Excel cell not automatically updating or updating manually with F9, Shift+F9, etc.
I'm Using "Microsoft® Excel® for Microsoft 365 MSO (...