i have a button and code so that when i click the button it prints, saves and creates a new worksheet ie job 2 ready for data entry,
somewhere in that process i would like it to copy the contents of certain cells from sheet job 1 to sheet job list,
but if i did
it will only copy that one cell, i want it to return back to job * and copy the next cell and so on,
but it must also be in the next avaliable blanck cell down on the job list
so where copying the contents in to cell A2 of the job list for Job 1, job 2 must be in A3, job 3 in A4 and so on
these sheets are all in the same workbook if that mkes it easier
Bookmarks