I have 2 worksheets i work on in 1 workbook with details on both some which
are the same some not which are transferred back and forth with the codes in
sheet1 and sheet 2. Sheet 1 is staff details,Sheet 2 is pay details.the code
in fig1 goes into sheet1 vba and code in sheet 2 goes in sheet2 vba. The
problem i have is that i actually have to open sheet 2 for those figures to
transfer to sheet 1 is there anyway it can be done by better coding,any ideas.

(FIG 1) Worksheets ("Pay").Range("I6").Value = _
Worksheets("Staff Details") . Range("E4").Value

(FIG2) Worksheets ("Staff Details").Range("M17:M69").Value = _
Worksheets ("P11D").Range("E13:E66").Value
--
BD3