running the same record macro on different spreadsheets

[gwtechie72]

I got have my recorded macro setup the way I want, however when I want to run
it on a new update spreadsheet I cant. Is there a way to run this recorded
macro, without having to re-create it all over again?

 

[Barb Reinhardt]

I'm guessing that you've hardcoded a worksheet reference of some sort.
Could you post your macro and someone can assist with modifying it?

 

[Max]

I wonder why the simple index/match didn't cut it for you.