Previous Topic Next Topic

Excel masters plz help

Closed
rohan_wagela Posts 3 Registration date Thursday April 8, 2010 Status Member Last seen April 9, 2010 - Apr 9, 2010 at 06:30 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 13, 2010 at 06:55 AM
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.
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 9, 2010 at 08:55 AM
see
https://ccm.net/forum/affich-258700-interesting-question-for-excel-champions?full#29

You asked same over there, and i have responded there
rohan
Apr 13, 2010 at 02:41 AM
if you can tell me more about macros it will be great.
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 13, 2010 at 06:55 AM
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

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses