Excel Macro / Formula Helo

[Sampath17]

Hi

I am very new to excel macros

I am working with a spreadsheet that looks like this

-- removed inline image ---

Is there a Macro / Formula that could do this?

Thanks for your help.

S

 

[Jonmo1]

Glad to help..

You can remove this line

Don't need to activate/select sheets to manipulate them.

And I wouldn't expect too much faster..
It's a pretty NON standard thing you're doing..

 

[Sampath17]

Glad to help..

You can remove this line

Don't need to activate/select sheets to manipulate them.

And I wouldn't expect too much faster..
It's a pretty NON standard thing you're doing..

Thank you very much for you help.

I will take your advice on the "activate/select sheets"