G
Guest
Hi,
I made autofilter on range in sheet1 and I need to copy it (only the rows
after the filter) for another range in sheet2 but I need to do it row by row
because for each row in column 3 i need the value from col 5.
For example:
Sheet1:
1,5,aa,33,bbb
2,6,bb,45,ccc
Sheet2: (after the copy)
1,5,bbb,33,bbb
2,6,ccc,45,ccc
How can I do it?
thanks,
Shlomit
I made autofilter on range in sheet1 and I need to copy it (only the rows
after the filter) for another range in sheet2 but I need to do it row by row
because for each row in column 3 i need the value from col 5.
For example:
Sheet1:
1,5,aa,33,bbb
2,6,bb,45,ccc
Sheet2: (after the copy)
1,5,bbb,33,bbb
2,6,ccc,45,ccc
How can I do it?
thanks,
Shlomit