looking for help with macro combining formula, expansion and printout features
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:
•column B: for all cells a formula is returning “externe calc” or empty
•column A: every cell is an identifier number
•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.
Add: looking for help with macro combining formula, expansion and printout features
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,
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By toothbrush in forum Excel Formulas & Functions
Last Post: 11-27-2012, 07:39 PM
By kurifodo in forum Excel Formulas & Functions
Last Post: 10-02-2012, 11:18 AM
By R_S_6 in forum Excel Programming / VBA / Macros
Last Post: 12-13-2010, 11:51 AM
By excellentexcel in forum Excel Programming / VBA / Macros
Last Post: 01-09-2009, 10:31 AM
By Momo in forum Excel Programming / VBA / Macros
Last Post: 01-27-2005, 02:06 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1