Marţi, 24.04.2018, 04:08:21
Bine aţi venit Vizitator | Înregistrare | Autentificare

VIO

Meniu site
Categoriile secţiunii
    
    
    
    
    
    
    
    
    
    
CALENDAR
Vremea
Prietenii site-ului
Stiri
Statistici

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

Video

Principală » Video » Tutoriale_video_EXCEL

Excel - Transfer Data from Multiple Workbooks into Master Workbook Automatically

00:18:15
Vizualizări: 0 Adăugat de: vio vio 
Descrierea intrării:

We can transfer data from multiple workbooks into a master workbook automatically using Excel VBA.Sherin has created a template file with specific headers. Her suppliers have also been instructed to have the same headers with the relevant data below them. Now when the suppliers send her the workbooks by email, Sherin transfers them to a common folder where she has her template or master file. She wishes to now automate the process of transferring the relevant data from the suppliers files to her master file.The process involves the following VBA code:(1) Find out how many suppliers files are there in the folder(2) Open the files one by one(3) Copy the relevant data(4) Close the suppliers file(5) Paste the data into the template or master file(6) Loop through all the files using the LEN function with the DO WHILE loopFinally we can call our subroutine or macro every time we open the workbook to automatically transfer the data from the suppliers files to our master file.Code and further details: http://www.familycomputerclub.com/transfer-data-from-multiple-workbooks-into-master-workbook-automatically-using-vba.html

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