All Questions
527
questions
0
votes
1
answer
1k
views
VBA - make hyperlink display text equal to active cell contents
How do I make the display text for this hyperlink equal to the contents of the active cell, cell B50, rather than the text "B50"?
The rest of the formula works, it's just the display text I ...
0
votes
1
answer
1k
views
VBA - How do I reference the last row of data for Range?
My Excel workbook has a summary Recap sheet that pulls data from the proceeding detail sheets (with new detail sheets being added frequently).
When a new detail sheet is added, I want my macro insert ...
-1
votes
2
answers
152
views
How can I enter a formula that pulls data from a newly added sheet of an Excel workbook, not specified by number?
My Excel workbook has a summary Recap sheet
followed by many sheets, each named for a different city.
More cities (and sheets) are added over time, so I add more lines to the Recap sheet. I'm trying ...
0
votes
1
answer
157
views
I want VLOOKUP, but I want be able to see the "nth" unique result, not just the first
I want to create an Excel function in vba that works identically to VLOOKUP, but has an extra argument to let you pick the nth unique result.
Here's non working code that I've come up with so far. It ...
-1
votes
1
answer
81
views
I have a large worksheet with many columns. How do ! find specific columns - headers- and their contents and bring them to the beginning of the sheet?
I have a large worksheet with many columns. How do I search specific columns return them to the beginning of the same sheet from B1?
I am using this for an automated weekly task that does not have a ...
0
votes
1
answer
259
views
use multiple cells value as criteria2 for AutoFilter in VBA
I want to filter multiples dates A1:A3 in a Date column A4:A1000. I did this manually with macro recording mode, see pic1. I got this code for criteria2 ActiveSheet.ListObjects("Table1")....
0
votes
0
answers
217
views
Excel massive issue with UDF values, returning #VALUE, not storing calculated values
since I updated my Excel sheets with UDFs I have massive problems.
I wanted to change my formulas only in one place (that is the UDF), instead of every columns containing the same formula of my sheets ...
0
votes
1
answer
83
views
Excel: Count Weighed Cells
I've an excel-spreadsheet, which is my timetable. this means, that I've some tasks, which is almost always a connected cell, sometimes I connect 20 cells, sometimes only two. Example
Since every cell ...
0
votes
2
answers
206
views
Searching for a string over several columns in Excel, that is present in several rows and then combining information into a single row
I have one spreadsheet with a series of work numbers - one on each row. Another spreadsheet has a series of treatments with work numbers spread over several rows and columns.
I want to search for a ...
0
votes
0
answers
37
views
Copy data excel in format table word split list in different pages
Hello and thanks in advance for your help.
1- I have a spreadsheet that Sheet1 and Sheet2 have data list of names and ID that change in daily basis in Excel, is it possible a VBA code run copy from ...
0
votes
1
answer
2k
views
Excel Date Timezone Conversion [duplicate]
I have a spreadsheet from a system that outputs the date and time format like this:
15/09/2021 04:29 AM
The format of the field/cell is Custom:
dd/mm/yyyy hh:mm
How do I convert the output so that ...
0
votes
2
answers
114
views
Can my unwieldy SUMIFS VBA code be streamlined?
I would like to start this by saying I know enough VBA coding "to be dangerous" as the old saying goes.
I work at a library and was given a report from the system to make into a table with ...
1
vote
0
answers
69
views
How do I extract design information from a pivot table in an external worksheet (properties) (Excel)
I am teaching a course in Microsoft Excel, using Excel 2019. As part of an exam in this course, I ask students to create pivot tables. I will then need to grade these exams.
Each student submits an ...
3
votes
2
answers
393
views
Equivalent of Excel VALUE function for VBA
I need to convert a time value from the text format "hh:mm" to a number. The Value can also be negative and higher than 24 hours. I came up with the following formula to achieve this:
=IF(...
2
votes
1
answer
9k
views
How can I refer to an Excel worksheet by index rather than name?
Woe is me, I have an Excel workbook with a gazillion sheets; each with its own unique, non-sequential name. I want to refer to these sheets using their indices rather than names. How can I do that?