hi guys
i am looking for a macro that i can assign to a button on (demand sheet "send to list").
i am after a macro that will move columns contents B7-R7 on every row if the person puts in a number greater then 1 in column Q. to the work sheet LIST
example
Sheet demand some one asks for 34 in Q7 and 23 in Q10 then presses the SEND TO LIST button
this will send all the contents from B7 - r7 and b10 - r10 to sheet List and populate B5 and B6
hope this makes sense
thank you for looking
Bookmarks