BTTControlo_2012.xlsmAlready for some time that do not touch in vba, so my difficulty.
1. Numbering sequecial automatically, conditional.
2. Copying content from one sheet to another, conditional.
will then:
The workbook records the inscriptions on a mountain bike ride sheet. In 1st sheet, the Column A is for automatic sequential numbering, but only if in the 2nd column content is "Confirmed", ie, paying the subscription.
The 2nd sheet, notes the arrival of the participants. This sheet allows you to change the course originally set by the participant, column E.
What i mean is, that according to the route taken by the participant, column E, copy complete row to sheet 3 or 4.
For example, if the participant has the course of 60 km, the respective row is copied to the sheet 60Km results, if the route of 30Km made, then the row is copied to the sheet 30Km results.
Thank you.
Bookmarks