transferring data between 2 worksheets in same workbook
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 |
All times are GMT +1. The time now is 03:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com