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:
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!
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: www.familycomputerclub.com/excel/shared-workbook-in-excel
How to share a workbook on SKYDRIVE:
For the complete macro code:
Get the book Excel 2016 Power Programming with VBA: amzn.to/2kDP35V
If you are from India you can get this book here: amzn.to/2jzJGqU