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,

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