Forum

Hi Matthew, List column headings should be avoided, it is usually used when your list refers to a sheet range that HAS headers, this way the list read...

Hi Matthew, What do you mean with: "1. Column heads from my worksheet page." See if the attached search form helps, where you can select the col...

Hi Ron, can you upload your PBI model?

Hi Quynh, First, you will have to follow the cross posting rules, it's not fair to post the same question on multiple sites on web without posting ...

Hi Juliet, I see what you mean, but I dare to suggest a better layout and a proper table structure, having that structure from Working sheet, with ...

Hi Juliet, Here is the InventoryQuery updated, in the last column you will have a table for each record, with the dates and quantities sorted: ...

Hi Nels, Can we see that main macro code? What do you mean by achieve control? You want to pause the macro while you do manual things and you want ...

Hi, First, we will need a list of unique products with a mark on those products that brings the max number of pallets to 21. It will be useful i...

Hi Uffy, There are many online courses. You can try this one: I'm not aware of specific accounting vba courses.

Hi William, You can find code to create an email in this tutorial: Instead of adding an attachment, you can just use the HTMLBody property to ...

Hi Fikri, You can use this code:

Hi Dennis, I reformatted data as in the attached file, using Power Query, let me know if that works for you.

The slicer in sites controls PivotTable1 and PivotTable6, from Report and Pivot Table sheets. They both have the same data source - Sites & Groups...

Look at your query steps, from the beginning of the query. Filter the Name column to remove FilterDatabase entries from that list. In th...

Hi Yachu, Look at the step where you have the list of sheets and tables. If there is a filter applied in one of the source file sheets, there will ...