Forum

Catalin Bombea
@catalinb
Admin
Member
Joined: Nov 8, 2013
Last seen: Mar 17, 2025
Topics: 1 / Replies: 1936
Reply
RE: Dropdown Menu

You cannot do that in a single dropdown, use dependent dropdowns:

3 years ago
Reply
RE: Posting in Ledger by Using Formula

Hi Reehan In a formula, the @ operator refers to the current row, that means The account used is not always what you expect, see the image, it is l...

3 years ago
Reply
RE: Not everything is a number....

Hi Jim, I don't think there is such a tutorial, as each need has unique elements that needs to be designed to work in that specific way. You can...

3 years ago
Reply
RE: Parcel Tracking?

Hi Justin, Each carrier has a different website and its own way to display information. Most probably they have an API service, which is unique aga...

3 years ago
Reply
RE: VBA function for Quarterly financial calculations

Hi, Unfortunately, there is no magic function, some topics you mentioned are pretty complex. For example, COGS needs a specific method, like FIFO o...

3 years ago
Forum
Reply
RE: Excel - read the name from different sheets and return back to another sheet in sequence

Hi Chris, Try this one: Sub AssignAgent() Dim r As range Dim i As Integer Dim Agents As Range: Set Agents=ThisWorkbook.Worksheet(...

3 years ago
Forum
Reply
RE: Need vba code to export row values into msword file with new file name

Hi Mani, It's a complex setup you need to make, before exporting data: Insert Content Controls in your word document, named exactly as your exce...

3 years ago
Forum
Reply
RE: Using VBA to read PDF / Word Doc Content

Nothing attached, we cannot see what you got. How do you "define apps"? Dim AcrobatApplication As New Acrobat.CAcroApp Dim AcrobatDocument As...

3 years ago
Forum
Reply
RE: Total counts of columns values exceeds set target remove values dynamically in Powerquery

Hi Femco, Here is an example, note the Transformation step that clears the 3 grade columns if the subject is not in the list of Accredited subjects...

3 years ago
Forum
Reply
RE: Why would SOME dates show mm/dd/yy when most (as required) show dd/mm/yy?

Hi, Can you tell us what date format you have set in your system? (Control Panel > Region) If it's showing US date format, change it to UK da...

3 years ago
Forum
Reply
RE: Total counts of columns values exceeds set target remove values dynamically in Powerquery

First you have to decide what you need then we will setup a table similar to one of the tables below. Which one fits: setting a list of subjects pe...

3 years ago
Forum
Reply
RE: Total counts of columns values exceeds set target remove values dynamically in Powerquery

Hi Femco, If the subjects vary a lot between subject, makes sense to set the allowed subjects by student. If not, then you can set a subject pri...

3 years ago
Forum
Reply
RE: Set Slicer Left and Width properties to match columns

Hi Shawn, The topic seems very similar to your other post. Before creating a new one, please try to provide feedback or implement the solution you ...

3 years ago
Forum
Reply
RE: Greedy heuristic in VBA

Hi Endros, Can you come with a more detailed description? Hard to imagine what you're after without a sample and a proper description.

3 years ago
Forum
Page 19 / 130