Dear Experts/Forum Contributors.
Kindly, find enclosed attachment two files before & after.Before file contains the code which applies when there is only one unit and fixed column that gets converted into PDF when clicked/triggered from 'Master' Worksheet.
Currently, I am facing that I have more than one units with different columns of data.
As enclosed in attachment in file 'Data_Before or existing' in worksheet 'Data' column E:H is data of Unit 1,
What I am expecting/wanted that in file 'Data_After or Required' that in actual there are more data set after H i.e G:J, K:N, O:R,S:V respectively representing for Unit1, Unit2,Unit3 & Unit4
I want the same results triggering from 'Master' worksheet for different units & different columns on selection in respective worksheet Unit2,Unit3,Unit4 for which selection as well pdf conversion is required.
As usual ,I hope for your kind effort into this matter.
NB:I have posted this thread also at https://chandoo.org/forum/threads/dy...ksheets.41664/ and will marked solved to all as soon as it is solved at anywhere.
Bookmarks