+ Reply to Thread
Results 1 to 2 of 2

looking for help with macro combining formula, expansion and printout features

  1. #1
    Registered User
    Join Date
    08-22-2013
    Location
    Zürich
    MS-Off Ver
    Excel 2010
    Posts
    2

    looking for help with macro combining formula, expansion and printout features

    Hello everyone,
    I like to ask for your help in constructing following macro, where filling a formula, expansion and printout are combined. I could puzzle some parts but am majorly stuck trying to do the following:

    The setup:
    Sheet “Analysis”,

    •column B: for all cells a formula is returning “externe calc” or empty
    •column A: every cell is an identifier number

    Sheet “ZB”,

    •I like to paste in cell $D$2 the range of identifiers, as shown in column A/Sheet Analysis, that have a corresponding “externe calc” in column B
    •This should happen as follows: get the first identifier, place it in cell $D$2, --by doing this, data linked to this identifier will be used in the same sheet ZB. This data will occur in a given segment, as the sheet is organized in different blocks (rows) that are collapsed. At this point, I want to expand the segment where the data is shown (keeping the other segments collapsed) and print the sheet.
    •After these actions, the following identifier should be pasted in cell $D$2, followed by the same sequence.

    I would greatly appreciate any help in this. Of course, further clarifications re the setup are available if needed.
    Thanks so much in advance for your time and help.
    Kind regards,

  2. #2
    Registered User
    Join Date
    08-22-2013
    Location
    Zürich
    MS-Off Ver
    Excel 2010
    Posts
    2

    Add: looking for help with macro combining formula, expansion and printout features

    Hi,

    I have uploaded a sample file, with Sheets Analysis and ZB
    In addition to the setup explained in my initial message, I like to add the following (bold point 5.)

    So the sequence i like to run is:
    1. retrieve and paste identifier in $D$2 in Sheet/ZB
    2. the data linked to that identifier will be used in calculations in sheet ZB. The segment in which calculations will occur in accordance to the date in Sheet Analysis/ $A$2.
    3. That segment only should then expand
    4. The sheet as seen as such should be printed
    5. The value calculated in Sheet ZB/ O303 should be pasted back in Analysis/N4, in the corresponding identifier
    Note: the row to retrieve the value in Sheet ZB varies according to the date in $A$2 Sheet Analysis

    I believe this macro encompasses a lot of steps, not sure if this can run in once. Any help or advice is greatly appreciated!
    thanks a lot for your time,
    kind regards
    Attached Files Attached Files

+ 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. [SOLVED] Expansion of an Array Formula
    By toothbrush in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-27-2012, 07:39 PM
  2. dynamic expansion of formula ranges
    By kurifodo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-02-2012, 11:18 AM
  3. Userform to Control Macro Features. Macro = Search for File Type
    By R_S_6 in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 12-13-2010, 11:51 AM
  4. filter features+macro
    By excellentexcel in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 01-09-2009, 10:31 AM
  5. [SOLVED] Macro save as Expansion
    By Momo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-27-2005, 02:06 PM

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