Macro to copy data from one sheet to another and give no. orderly

[Manish_Gupta]

Hello Guys,

I need urgent help in creating a macro for below requirements:

1. Macro creates a new sheet with name “Test”.
2. Now, Macro look for content in “Data” sheet and if there is any data present in Column C then in “Test” sheet it will be marked as 1 in Column B and data should be copied in Column C.
3. If any data is present in Column D of “Data” sheet then in “Test” sheet it will be marked as 2 in Column B and data should be copied in Column C.
4. If any data is present in Column E of “Data” sheet then in “Test” sheet it will be marked as 3 in Column B and data should be copied in Column C.
5. If any data is present in Column F of “Data” sheet then in “Test” sheet it will be marked as 4 in Column B and data should be copied in Column C,
6. If any data is present in Column G of “Data” sheet then in “Test” sheet it will be marked as 5 in Column B and data should be copied in Column C.
7. If any data is present in Column H of “Data” sheet then in “test” sheet it will be marked as 6 in Column B and data should be copied in Column C.

Whenever we run Macro, the “Test” sheet should always be created as new (means old “Test” sheet should be get deleted).

For more clarification please refer the attached Sample file. Please check the “Test” sheet to see how the data should look after macro.

Please let me know incase you need any more clarification.

Thanks,
MG

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Manish_Gupta]

Hello John,

You had surprised me again. This macro is fulfilling all my requirements.

Many Thanks for your help.

Thanks,
MG

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please mark this thread as solved.