Please quote for the following small amendment to a file I have.
I have a customer quote system that generates product quotes anywhere from 1 to 5 pages. Please provide a quote to detect the last page with products on and then delete all subsequent pages.
If you look at the dummy file, only the first 2 pages have products on, so this would need pages 3, 4 & 5 deleted. The 'Live' File will have 10 pages on, so ideally the code will just delete all pages after the last one with products on.
I had originally tried to code it so that a new quote page was generated each time the previous one had filled, but for various reasons this didn't work out, so have thought of this as an alternative.
I would be happy for it to be a small piece of VBA which I can attach to an active X button on a seperate page.
Have had a look at your previous Tidy Tool and have run a live export through it and it is almost perfect. I will detail one or two small changes later on today to complete the job, but overall I am very impressed!!