Hi everyone. I have a spreadsheet that is pretty big, pretty complex, and it is challenging to learn new techniques with it.
Currently we run the numbers and publish a technician pick sheet in pdf. That sheet only shows what he rates that we have on hand.
We also publish a sheet specific to that tech showing all the background information not seen by the picker on the warehouse floor in pdf format. That is handy when someone asks a question about that specific date/time/tech.
And, we publish a stripped down pdf showing what he was owed no matter what was in or out of stock.
The third out put is what I would like to experiment with. I've googled it. I searched this forum. But, to be honest I am not finding an easy edit that I can understand at my skill level.
Here is the current macro. The only thing I want to change is that the output file is a workbook I can edit instead of .pdf that gets converted back to excel from time to time. So the Ranges modification and the various calls will have to stay in place. I especially need to keep the filename as shown. P6 is basically "techname & ponumber & "backfill" all concantentated to the cell. This provides a unique and searchable way to quickly get to a specific pick sheet months later. So, if we can't do that then I need to keep what works.
I'm looking forward to learning a lot of new stuff. Thank you for taking the time to look at this.
Please Login or Register to view this content.
Bookmarks