+ Reply to Thread
Results 1 to 2 of 2

Dynamically changing references of column with worksheets

  1. #1
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2021 / 365
    Posts
    1,238

    Dynamically changing references of column with worksheets

    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.
    Attached Files Attached Files
    Last edited by paradise2sr; 05-13-2019 at 02:30 AM.

  2. #2
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2021 / 365
    Posts
    1,238

    Re: Dynamically changing references of column with worksheets

    I have duly revised the title and description for ease of understanding.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 07-13-2017, 07:57 AM
  2. Replies: 1
    Last Post: 09-04-2014, 03:39 AM
  3. [SOLVED] When checkbox is checked it does not copy to new sheet. Only if not checked using false
    By thelisa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-28-2013, 07:59 AM
  4. [SOLVED] include column in sum formula if checkbox is checked
    By jrtaylor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2013, 02:10 PM
  5. [SOLVED] VBA code to uncheck checkbox 2 & 3 if checkbox 1 is checked
    By hydz1213 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-25-2013, 03:10 AM
  6. 1 checkbox can be checked/column applies to 10 rows,and don't allow to key numbers in.
    By lovelypaint in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-08-2012, 07:53 PM
  7. Select range dynamically using relative row and column references
    By gtol in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-01-2012, 06:43 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1