Hi Experts;
I want to copy some raw data from Sheet2 to Sheet1 like;
in Sheet1 there is one column for name of colors.(Black, Blue, Green, Red)
In Sheet2 there are some values for all colors. (Black, Blue, Green, Red)
I want to past Sheet2 color values in Sheet1 before respected color names.
if I filter Sheet1 for "Black" copy all values under "Black" from Sheet2 and past them on Sheet1 visible cell which are filtered for "Black".
It does not put that values on filtered cells with color_name "Black".
Past OR (Ctrl+v) put values in continuous cells.
Sample file is attached!
Thanks and Regards
Bookmarks