I am writing a macro that copies cells from one sheet and puts it on another sheet in the next empty field how do i do this ?
thanks
benn
I am writing a macro that copies cells from one sheet and puts it on another sheet in the next empty field how do i do this ?
thanks
benn
in vba use this type of code
sheet2.range(rows.count,
cells(rows.Count,"E").end(xlup).offset(1,0).pastespecial
it will be pasted next empty cell in column E
<[email protected]> wrote in message
news:[email protected]...
>
> I am writing a macro that copies cells from one sheet and puts it on
> another sheet in the next empty field how do i do this ?
>
> thanks
> benn
>
>
> --
> cassy01
> ------------------------------------------------------------------------
> cassy01's Profile:
> http://www.excelforum.com/member.php...nfo&userid=780
> View this thread: http://www.excelforum.com/showthread...hreadid=514335
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks