11-30-2016
05:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
11-30-2016
05:14 PM
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.