Forum

Hi, You have to put the shape name in the cell next to column BK and use the code below placed in the sheet Lower module. The code will fail if the...

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

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

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

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

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

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

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

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

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

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

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

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

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

Nothing attached, please try again. Thank you