Hi Folks,
Anyone out there have time to write me a short code for the following please.
I want to search column B in worksheet1 starting from row 6 downwards and for every cell that is > "" i want to copy them and place them in column B of worksheet2 starting from row 6 and continue downwards.
I know how to do it like this for each cell:
If Sheets1.Range ("B6").value >"" then
sheets2.Range ("B6").value = Sheets1.Range ("B6").value
End If
But not sure how to do it short code
Thanks
Anyone out there have time to write me a short code for the following please.
I want to search column B in worksheet1 starting from row 6 downwards and for every cell that is > "" i want to copy them and place them in column B of worksheet2 starting from row 6 and continue downwards.
I know how to do it like this for each cell:
If Sheets1.Range ("B6").value >"" then
sheets2.Range ("B6").value = Sheets1.Range ("B6").value
End If
But not sure how to do it short code
Thanks