Posted by Mark on April 08, 2001 3:32 AM
on sheet one of my workbook,I have a list of various details(customer,quantity,order date....).What I would like to do is copy the last line of data from this sheet onto the next available line on sheet 2,I was hoping that I could do this with a controll button placed onto sheet one.
also(just to make things even more complicated!)on sheet 2,I have a column that is filled in with "yes" if the work for that line has been completed(blank if it is still in progress)What I would like on this one is,if the completed column has "yes" typed into it,then the whole line deleted,and any gaps between the rows removed(contents below moved up)
is this possible or am i expecting too much?!
thankyou in advance