Exporting a 30 Piece Layout to Excel

[[Br...]]

I've been trying to remember how to make a template to export 30 pieces worth of data, I know how to add the button to them, but it tends to either come up blank or not give enough results. Anyone have any idea?
Thanks

[[Er...]]

It's hard to say what is going on in your Excel sheet.

We use Excel power query to combine the data. Then a pivot table to organize it.

viewtopic.php?p=45584&hilit=excel+query#p45584

[[Ün...]]

A macro file that combines Excel files

[[Ke...]]

Please sign in to view this quote.

Work well with large batch?
Last time I tried one that looked like this, it did not necessarily import them in the correct order.

[[Ün...]]

I can merge 100-200 excel files, yes you're right sometimes it messes up the sorting, but it's not hard to fix it with excel.

I am able to fix the order by adding the part number to the incremental part number section.

This is the best solution I've been able to combine 16 pages of data with 400 measurements

[[Ri...]]

If you are using PiWeb, it is extremely easy to export massive amounts of data out of the database with relative ease.

[[Br...]]

Thank you, I will give these a go today