M Maddy Member Apr 10, 2018 #1 Hi Team, Can someone please guide me, how can I paste huge chunk of data from one sheet to another through formula, because its not letting me to copy paste that with error-copy area and paste area are not the same size and shape.
Hi Team, Can someone please guide me, how can I paste huge chunk of data from one sheet to another through formula, because its not letting me to copy paste that with error-copy area and paste area are not the same size and shape.
Marc L Excel Ninja Apr 10, 2018 #2 Hi ! As it's a bad idea to merge cells, just avoid it and no more issue !