simple power query thats frustrating me

Tradesman

New Member
Joined
Sep 20, 2023
Messages
3
Office Version
  1. 365
Platform
  1. MacOS
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
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
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......
 
Upvote 0
In excel for mac it doesn't have an option for folder only 1 of 8 file options??

any ideas
 

Attachments

  • Screenshot 2023-09-21 at 10.11.30.png
    Screenshot 2023-09-21 at 10.11.30.png
    221.7 KB · Views: 5
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,223,317
Messages
6,171,419
Members
452,402
Latest member
siduslevis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top