I am sure there must be some other ways easy and time efficient in
terms of a macro or VB Code. Request help from the group please.

I am sure, too, but your being far more specific will likely get a
much better response here.

You could also try automating by turning on the macro recorder
while doing your usual work.

HTH,
Merjet