i didnt explain my self to well
what im after is this:-
i want ot copy like this
Sheet Job 1 Cell F2 - Sheet Job List Cell A6
Sheet Job 1 Cell G2 - Sheet Job List Cell B6
Sheet Job 1 Cell H2 - Sheet Job List Cell C6
Sheet Job 1 Cell S2:U2 - Sheet Job List Cell D6:F6
Sheet Job 1 Cell F6:S6 - Sheet Job List Cell G6:N6
Sheet Job 1 Cell H4:K4 - Sheet Job List Cell O6:R6
Sheet Job 1 Cell F8:S8 - Sheet Job List Cell S6:AA6
Sheet Job 1 Cell AB10:AF10 - Sheet Job List Cell AB6:AE6
Sheet Job 1 Cell S4:U4 - Sheet Job List Cell AF6:AI6
Sheet Job 1 Cell V4:Y4 - Sheet Job List Cell AJ6:AM6
Sheet Job 1 Cell K59:R59 - Sheet Job List Cell AN6:AP6
that fine and reletivly easy.
the macro i have at the mo, save, copys the worksheet Job 1, and renames it job 2, so now i have 3 tabs in the work book, job 2 gets filled out and those cells need copying in to job list to, but 1 row down ie:
Sheet Job 2 Cell F2 - Sheet Job List Cell A7
Sheet Job 2 Cell G2 - Sheet Job List Cell B7
Sheet Job 2 Cell H2 - Sheet Job List Cell C7
Sheet Job 2 Cell S2:U2 - Sheet Job List Cell D7:F7
Sheet Job 2 Cell F6:S6 - Sheet Job List Cell G7:N7
Sheet Job 2 Cell H4:K4 - Sheet Job List Cell O7:R7
Sheet Job 2 Cell F8:S8 - Sheet Job List Cell S7:AA7
Sheet Job 2 Cell AB10:AF10 - Sheet Job List Cell AB7:AE7
Sheet Job 2 Cell S4:U4 - Sheet Job List Cell AF7:AI7
Sheet Job 2 Cell V4:Y4 - Sheet Job List Cell AJ7:AM7
Sheet Job 2 Cell K59:R59 - Sheet Job List Cell AN7:AP7
and repeat the process for Job 3, 4, 5........ 50 etc
i can email you my workbook if that helps
ive tried to use
activesheet(range("H4:k4").select
selection.copy
then copy to job list, but i cant work out how to get it ot go back to the latest job to select the next cell to copy
ican email my workbook to help if need be