Very Urgent


New Member
Jul 28, 2010
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...........

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.


New Member
Jul 28, 2010
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

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

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...