I need a macro that will take names from range A21:A2 and paste on C3:F3 (merged cell) on another sheet.
For example:
Column A
Bird, Tweety
Bird, Big
Man, Goofy
It will take Bird, Tweety and place it on cell C3:F3 on a different sheet which we'll call "Bird, Tweety" for now. The sheets are in the same order as the range starting from the bottom. Help?
For example:
Column A
Bird, Tweety
Bird, Big
Man, Goofy
It will take Bird, Tweety and place it on cell C3:F3 on a different sheet which we'll call "Bird, Tweety" for now. The sheets are in the same order as the range starting from the bottom. Help?