[Br...] Posted June 6, 2023 Share Posted June 6, 2023 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 Link to comment Share on other sites More sharing options...
[Er...] Posted June 7, 2023 Share Posted June 7, 2023 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 Link to comment Share on other sites More sharing options...
[Ün...] Posted June 7, 2023 Share Posted June 7, 2023 A macro file that combines Excel files Link to comment Share on other sites More sharing options...
[Ke...] Posted June 7, 2023 Share Posted June 7, 2023 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. Link to comment Share on other sites More sharing options...
[Ün...] Posted June 7, 2023 Share Posted June 7, 2023 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 Link to comment Share on other sites More sharing options...
[Ri...] Posted June 7, 2023 Share Posted June 7, 2023 If you are using PiWeb, it is extremely easy to export massive amounts of data out of the database with relative ease. Link to comment Share on other sites More sharing options...
[Br...] Posted June 8, 2023 Author Share Posted June 8, 2023 Thank you, I will give these a go today Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in