Kashif4frnd
New Member
- Joined
- Jul 28, 2010
- Messages
- 2
Hi Everyone,
I need one help Becaue I want to create Macro. Please help me it's very urgent.I want to create macro which help me to create Parameter sheet.Actually My parameter sheet would be like this that I received many files to create Parameter sheet.What is in it that I received changes from client side there is no limit of columns and rows.I received data like this.
Example : ID Name DOD DOB
A01 | David | 18-02-1985 | 18-02-1996
A02 | Harry | 18-07-1956 | 18-03-1995
These are sample sheet which I received from Client Side After received the file I have to add seperate sheet and after that I have to make Parameter sheet on the seperate sheet like this.
Example:- CMD | ID | FieldName | Field Value
C | A01 | Name | David
C | A01 | DOD | 18-02-1985
C | A01 | DOB | 19-02-1996
I have to paste also Field Name with value for every ID .So I Need a Macro code for this Because in the received file there is no limit of columns or rows. So Please suggest me for this.
Thanks a lot...........
I need one help Becaue I want to create Macro. Please help me it's very urgent.I want to create macro which help me to create Parameter sheet.Actually My parameter sheet would be like this that I received many files to create Parameter sheet.What is in it that I received changes from client side there is no limit of columns and rows.I received data like this.
Example : ID Name DOD DOB
A01 | David | 18-02-1985 | 18-02-1996
A02 | Harry | 18-07-1956 | 18-03-1995
These are sample sheet which I received from Client Side After received the file I have to add seperate sheet and after that I have to make Parameter sheet on the seperate sheet like this.
Example:- CMD | ID | FieldName | Field Value
C | A01 | Name | David
C | A01 | DOD | 18-02-1985
C | A01 | DOB | 19-02-1996
I have to paste also Field Name with value for every ID .So I Need a Macro code for this Because in the received file there is no limit of columns or rows. So Please suggest me for this.
Thanks a lot...........