Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.

Hi Curtis,

 

Similar to rtrayes13 problem, i would like to export Parts List to excel.

The issue that i have is that i might have more than one part list on a single sheet. 

Firstly, can this be done and if so i am after a code that does;

 

Search all sheet(s) for part list(s)

Import the Part List(s) to excel (preferable all on same excel sheet with a gap between each part list) 

* If there are more than one sheets in idw then excel can be the same.

** Eg idw sheet 1 has 4 part list therefore excel sheet 1 will have 4 parts list all with a gap between them

& if idw sheet 2 has 2 part list then excel sheet 2 will have 2 part list all with a gap between them

 

Save file location in same location as idw. 

 

Thanks in advance.