Posts by royUK

Try this

Sub RunAdvFilter()
Call AdvFilter(Sheet1, Sheet1.Range("A1"), Range("H1"), Sheet2.Range("A1"))
End Sub

First of all why not convert the data to a Table, that way it is easier to refer to in the code.

What errors are you getting?

Why do you need code for this?

Why is the sum range one cell?

Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post

All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.

How to use code tags

Just highlight all of the code and press the <> in the post menu above button to add the code tags.

Thanks.

Try this

Private Sub Workbook_BeforeClose(Cancel As Boolean)

Answer1 = MsgBox("Update the Dashboard?", vbYesNo)

    If Answer1 = vbYes Then
        Workbooks.Open Filename:="path to filename/filename.xlsx"
        ThisWorkbook.Close True '<- TRUE will save the current workbook's changes, FALSE will close without saving.
    End If

End Sub

Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post

All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.

How to use code tags

Just highlight all of the code and press the <> in the post menu above button to add the code tags.

Thanks.

AutoFilter is the most efficient way whether using VBA or not.Attach an example of your workbook.

Microsoft are introducing Office Scripts for online, but I don't think that it's widely available yet. Ordinary VBA will not work online.

Take a look at this example for the password, for the other part you need to attach an example workbook

When you click the arrow you see a menu. Select the Number Filters option and use<0.

Note this is AutoFilter not Advanced Filter

This is a different question so start a new one and post it in Excel and Email Help

You aren't giving much information for us to work with! Explain more thoroughly.

Do you want it adding by the BuildInvoiceAll macro?

That needs checking though

Attach an example workbook.

What do you mean? Are you trying to import from a CSV?

Try Excel's VBA Collection

The cells referred to in the code are empty.

I don't think you will need the "=" in the concatenate line.

I definitely think you should be using a none VBA way. There's no point using VBA when a properly designed spreadsheet would be better. Store all additional inputs in a Table and sum those values.

Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post

All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.

How to use code tags

Just highlight all of the code and press the <> in the post menu above button to add the code tags.

Thanks.

You shouldn't have preset numbers for ID, they should be generated by the code,