simple power query thats frustrating me

[Tradesman]

I have a list if invoices that contains these headers

Original Headings

1. Sell-to Customer No.
2. Customer Name
3. Document No.
4. Posting Date
5. Type
6. No.
7. Description
8. Quantity
9. Unit Price Excl. VAT
10. Amount
11. Unit Cost (LCY)
12. Unit Cost
13. Original Order Qty.

I can populate it from an xlsx file exported from Micisopft NAV

all i want to do is when ive ran a new invoice report - add the new invoices to the bottom of the dta table - checking for duplicates while i do it.

I thought append would work but I'm struggling to get it do what i want

I think i just need to place a new sales report into a folder then run a query from the main workbook with the consolidated data in it?

but i can get it right - i think i am just a newbie

help pls

 

[alansidman]

This video if watched to the end may be what you need

 

[Tradesman]

Okay cool - that should do it then I add another step of remove duplicates (in case the new sales reports overlap )

and I'm done - iii report back shortly......

 

[Tradesman]

In excel for mac it doesn't have an option for folder only 1 of 8 file options??

any ideas

 

[alansidman]

Copy the Mcode that Mynda provided for the Source and put that into your blank query. I don't have a MAC and that seems to be the only rational solution that I can think of. Maybe one of the MAC experts with PQ knowledge will come by. In the meantime, I will do some research on Mr. Google.

EDIT: Found the following. Scroll Down to find a workaround

Power Query Debuts for Excel for Mac but with Significant Gaps

In early 2023, the Power Query tools debuted for Excel for Mac. This is a great first step, but many people will be disappointed that Power Query in Excel for Mac does not have some essential options.

www.mrexcel.com

 

[alansidman]

Follow up: Here is a video showing how the workaround