Thank you bobhc.You have placed a large file in Dropbox, many will not look depending on their connection speed, a small sample file uploaded to this site would have been more of a help.
If you have the Adobe PDF software you can do this through the software if not you can find some basic converters on Google.
As this site is all about helping putting help in your title is a bit superfluous.
.
My bro had converted the file in to excel but in chunks with many sheets in to different worksheets. Can u collate all the workbooks with all the worksheets using vba. I will send u the file by tomorrow morning then.Have u got the file.
Loads of thanks deepak..
It worked out for me...and it reduced my effort and time on that work...
![]()