Miercuri, 20.06.2018, 08:22:38
Bine aţi venit Vizitator | Înregistrare | Autentificare


Meniu site
Categoriile secţiunii
Prietenii site-ului

Total online: 1
Vizitatori: 1
Utilizatori: 0
Categoriile canalului


Principală » Video » Tutoriale_video_EXCEL

Excel - Transfer data from one Excel worksheet to another automatically

Vizualizări: 1 Adăugat de: vio vio 
Descrierea intrării:

Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday.For details you can visit our website:http://www.familycomputerclub.comNisha - a webiste visitor at familycomputerclub.com - has the following query:'I am working in a small call center and when our clients call, we take the basic details like user_name, User_id, phone_number, problem.Now what I want is, when a call comes we will note down all the above mentioned details in to an excel sheet and when I click on update this data should be saved in another excel sheet.Thanks in advance!NishaP.S.: What is a variable in Excel VBA?'We use a command button and code it using VBA so that the data entered by an operator is automatically transferred to another worksheet on click. Such a data transfer can also happen in a networked environment using the 'share workbook' feature in MS-Excel.You can also use the 'skydrive' on your hotmail account to share files.Link to sharing workbooks on a network: http://www.familycomputerclub.com/excel/shared-workbook-in-excelHow to share a workbook on SKYDRIVE:http://www.familycomputerclub.com/how-to-share-files-on-net.htmlFor the complete macro code:http://familycomputerclub.com/transfer-data-from-one-excel-worksheet-to-another-automatically.html

Limba: Rusă
Timpul de rulare al video-ului: 00:17:20
Autor: Dinesh Kumar Takyar
Total comentarii : 0
Doar utilizatorii înregistraţi pot adăuga comentarii
[ Înregistrare | Autentificare ]