how to insert rows including data from another sheet in same workbook

[roofi]

Hi Experts,

This forum has always been beneficial for me with regard to excel problems.
here attached my sample workbook alongwith a question in it. please review and solution will be highly appreciated.

thanks
Abdul Rouf

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

Not sure which Column had the Scholarship

[roofi]

Dear John,
Thank you for quick response.

please apply this code on my sample sheet and reattach if not inconvenient.

thanks

[JOHN H. DAVIS]

Copy of example-1.xls (218.5 KB)

[roofi]

Dear John
Your code returns code error 400. please review

thanks

[JOHN H. DAVIS]

The code worked when I tested it without error. Not sure it does exactly what you want. Do you have any sheets which are hidden?

[roofi]

No dear no hidden sheet. i am opening the same sheet attached by u.
please check

[JOHN H. DAVIS]

I tested it again twice and it worked? No errors.

[roofi]

ok thanks brother. sorry to bother you........

[JOHN H. DAVIS]

You're not bothering me. I just can't duplicate your error. Sorry, I couldn't help you further. I hope you find a solution.

[roofi]

dear John,

sorry there was problem at my end. your code is working thats nice..........
but it still need some update. please review my question inside the sheet.

thanks

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[roofi]

thank you John

you are a great contributor. sorry but your professional approach made me greedy to ask more questions on this sheet.
your code working now but there is one thing to update i mentioned in the worksheet.

thanks
Roofi

[JOHN H. DAVIS]

Try this:

Please Login or Register  to view this content.

[roofi]

Dear John
you are great. its solved now.
just one thing that in colum "A" new serial no should be generated starting from 1

[JOHN H. DAVIS]

Ok, then maybe:

Please Login or Register  to view this content.

[roofi]

Dear John,
I have been using your code. it is perfect and serving the purpose but i need one change in it. Please be appreciated if solved.

I want to use this code in a seperate workbook and extract data from other workbook. format is same.

thanks