How to copy data from one sheet to multiple sheets using IF

SK - Jun 12, 2015 at 06:18 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Jun 12, 2015 at 07:58 AM

We have one sheet were the master data is entered. There are different users who input data on this master sheet. How can this data be copied on separate sheets(user wise) simultaneously. For example, the users are A,B,C. How can the data of A be copied on separate sheet while user A is inputting the master data sheet. Similarly, this has to follow with other users B & C. Do we need to run any kind of a macro to perform this action? Please help.

Thanks in advance,

Sami Khan

3 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jun 12, 2015 at 07:37 AM
when the user enters data there should be one column where user name must be also entered. in that case you can filter data according to each user and then copy filtered data to sheet named that user. every time you have unfilter and then again filter. you post a sample sheet ( small sample) and then the macro can be written