Excel masters plz help

[Closed]
Report
Posts
3
Registration date
Thursday April 8, 2010
Status
Member
Last seen
April 9, 2010
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
dear all,
I will tell you the question in more detail.
In sheet1 I am entering the data for the whole year, in column f I am entering names.(10 diff. names).
I have made separate sheet for each person. when a name comes in column f in any row it should get copied to the sheet created for that person(sheet2). If the same name again comes in sheet1 column f , then it should get copied in the next row(sheet2). and when i am updating the row in sheet1 it should get updated in the sheet2 if it had been copied to sheet2 earlier.
Plz tell the solution in details.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
see
https://ccm.net/forum/affich-258700-interesting-question-for-excel-champions?full#29

You asked same over there, and i have responded there
if you can tell me more about macros it will be great.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
what you mean explain about macros ? the best way to start on a macro would be that use the macro recorder that comes with excel. It will record you actions as you perform various tasks in excel. You can then look at it and customize it for more generic solutions