Transfer data from one Excel worksheet to another automatically
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:
https://www.exceltrainingvideos.com/t...
Nisha - 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!
Nisha
P.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/exc...
How to share a workbook on SKYDRIVE:
http://www.familycomputerclub.com/how...
For the complete macro code:
http://www.exceltrainingvideos.com/tr...
Get the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V
If you are from India you can get this book here: http://amzn.to/2jzJGqU
