You can also use the 'skydrive' on your hotmail account to share files. Such a data transfer can also happen in a networked environment using the 'share workbook' feature in MS-Excel. 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. 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. '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. What I need is to do is move data from row 1-11 and place it in its designated column in the transpose worksheet under the data column in each number.
Nisha - a webiste visitor at - has the following query: I want to be able to place data in the first worksheet and have it automatically placed in the correct column on another worksheet. Useful for beginners as well as advanced learners. Our Excel training videos on YouTube cover formulas, functions and VBA. What would be the function/formula to automatically move data from one sheet to another AS LONG AS certain criteria are met In my case: IF in Sheet 1, cell B2 contains EITHER 'FTIC' OR 'TRANS' AND cell B4 contains 'STU' then the text from D2 is copied into cell D2 in Sheet 2.
0 kommentar(er)
