transferring data between 2 worksheets in same workbook

B

bigdaddy3

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Returning values listed under multiple conditions 6
Cell values to an array, then array transpose to another workbook 8
Code to format cells on several worksheets 2
Have problem in Manipulating Workbook Object and make macro shortest as possible 0
[Q] How to create new worksheets based on an array (via named range) 4
Copy data that matches criteria in one worksheet to another worksh 1
Sound repeats unending until closing workbook 2
Link to another worksheet 1

Top