Hi,I'm looking for a macro that can do following task (I have attached file for reference):a) Merge the text in column B of file Bank stmt tab, ex in it merges cell B3-B6 & replaces the text on cell B1. No merge required in cell B7, but data needs to be merged from B8-11Once the merge is don