Very Urgent

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...........
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Kashif4frnd

New Member
Joined
Jul 28, 2010
Messages
2
Actually I want to paste data in other sheet like we received the data like ...

In columns ID Name DOD DOB

These are headings of the columns 1 but there is no limit of columns.
and also in headings have data like this

ID Name DOD DOB
A1 David 18-02-1995 18-02-1975
A2 John 14-05-1996 15-05-1974

And I want to make sheet like this via macro code.

CMD ID Filed Name Field Value

These are the headings of the other sheet.

And I want to make like this.

CMD ID Filed Name Field Value
C A1 Name DAVID
C A1 DOD 18-02-1995
C A1 DOB 18-02-1975
C A2 Name John
C A2 DOD 14-05-1996
C A2 DOB 15-05-1974

Please help to make this macro I know how to run macro but I Stucked in this I make a macro before but So I am not able to do this.So Help me.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,717
Messages
5,833,288
Members
430,202
Latest member
Faizal5zl

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top