Can any one tell me the procedure to transfer data between sheets in excel? I am using excel 2007, there are two column in my employee sheet 1] employee data 2] employee no and i want to transfer the data in to worker sheet.
Can any one tell me the procedure to transfer data between sheets in excel? I am using excel 2007, there are two column in my employee sheet 1] employee data 2] employee no and i want to transfer the data in to worker sheet.
To transfer data, enter them in sheet 1(employee sheet), go to sheet 2(worker sheet) and the cell in which you want the linked number to appear and enter the equal (=) sign. Then go back to sheet 1 (employee sheet) and the source cell and press Enter. Now, to transfer a formula: Assume the formula is in sheet 1(employee sheet), cell A1(employee data). Highlight A1, Copy (Ctrl+C) it, go to the cell in sheet 2(worker sheet)where you want the formula to go and Paste (Ctrl+V) it. Excel will adjust the formula to =Sheetl!A1.
You can use macro to transfer data between sheets in excel.A macro records your mouse clicks and keystrokes while you work and lets you play them back later. You can use a macro to record the sequence of commands you use to perform a certain task.
All you have to do is to click on all the details you have (employee in your case) you have to go to insert/name/defined/name it and then go to f(X) and try to get vlookup function and make these in the first block but eg.(E1:E2).
Bookmarks