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,
Bookmarks