Simple Cell Reference using VBA

[powerwill]

Hello Experts,

I have a Workbook with over 100 forms (sheets).

Certain cells from every form need to be referenced horizontally on another sheet (DUMP) in the same work book. So that any changes made to any of the forms would update the DUMP sheet automatically.

So far I have been doing this manually, going into each cell and looking up the cell reference.

I am trying to build a macro that would do it for me for all 100 sheets.

Any help is appreciated!

 

[powerwill]

Hello Experts,

I have a Workbook with over 100 forms (sheets).

Certain cells from every form need to be referenced horizontally on another sheet (DUMP) in the same work book. So that any changes made to any of the forms would update the DUMP sheet automatically.

So far I have been doing this manually, going into each cell and looking up the cell reference.

I am trying to build a macro that would do it for me for all 100 sheets.

Any help is appreciated!

View attachment 82717View attachment 82718

@davesexcel appreciate any help!