• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamically changing references of column with worksheets


Dear Experts/Forum Contributors.

This post is still unsolved and it is also posted at Link to Other forum.

Kindly, find enclosed attachment (Link to Other Forum) 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( Link to Other Forum) 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.

Pls find the file at link >>>>Link to Other Forum