Hi Everyone,
I am a begineer with VBA. I need some help. Sample data is shown
below. Column A is a list of employee names. The TBD person
represents a new hire that will be hired sometime in the future.
Columns AR and beyond are months years. For example, row 1 column AR
is Sept -09. Row 1 column AS is Oct- 09. This continues out until
Dec. 2010.
Column A .......Column AR Column AS Column AT ...
Sept-09 Oct-09 Nov -09
TBD 1 1
TBD 1
1. I need to select the TBD person from Column A and the first
occurance of the "1" in the columns AR, AS, AT and columns outward to
Dec 2010.
2. I need to copy and paste the month and year that the new hire is
starting to a new sheet. This is contained in the first row of that
coumn. This is represented by the first occurance of the 1.
For example, this is what it the TBDs (new hires) would look like on
sheet2 for the data above.
Employee Mo.
TBD Oct-09
TBD Sept-09
--~--~---------~--~----~------------~-------~--~----~
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~----------~----~----~----~------~----~------~--~---
