| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transform macro
Please help with a macro to tranfom the ff:
Column B1, C1 .... contains Job Role Column B2, C2 .... contains Course Code Row A3 ... contains UserID B3 ... contains X indicating UserID has been assigned Job Role B1 ans so on. The range may be set A1:T1000 A B C D E F G H 1 SD00:Display SD00:Product_MNG 2UserID SD 03 SD04 3IR_00783A x 4IR_01693B x Must be tranformed to a new worksheet containing UserID and Job Role A B 1IR_00783A SD00:Display 2IR_01693B SD00:Product_MG |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| transform formula | Excel Worksheet Functions | |||
| Transform csv to qif or ofx format? | Excel Discussion (Misc queries) | |||
| Table Transform | Excel Discussion (Misc queries) | |||
| Transform. | Excel Programming | |||
| Transform columns with VBA | Excel Programming | |||
![JA[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
