How to map number of sheets one line per sheet into one sheet

abbani

Board Regular
Joined
Feb 15, 2016
Messages
58
3 excel sheets similar in format each is like a form containing info about one book.

1 excel sheet is required to contain the 3 sheets data having one line per sheet

Please help in a VB code to do the above,
Thanks

Case:

Sheet 1Book NameExcel-1
Issue Date01-12-16Version No.1
SubjectExcel Help-1LanguageE
Nuber of Pages250ColorBlack
Publisher NameExcel Expert-1Publisher NationalityE
Nuber of copied published5000Price$10
Sheet 2Book NameExcel-2
Issue Date01-12-16Version No.1
SubjectExcel Help-2LanguageE
Nuber of Pages250ColorBlack
Publisher NameExcel Expert-2Publisher NationalityE
Nuber of copied published5000Price$10
Sheet 3Book NameExcel-3
Issue Date01-12-16Version No.1
SubjectExcel Help-3LanguageE
Nuber of Pages250ColorBlack
Publisher NameExcel Expert-3Publisher NationalityE
Nuber of copied published5000Price$10
New SheetBook NameIssue DateSubjectNuber of PagesPublisher NameNuber of copied publishedVersion No.LanguageColorPublisher NationalityPrice
Excel-101-12-16Excel Help-1250Excel Expert-150001EBlackE$10
Excel-201-12-16Excel Help-2250Excel Expert-250001EBlackE$10
Excel-301-12-16Excel Help-3250Excel Expert-350001EBlackE$10

<tbody>
</tbody>

 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Forum statistics

Threads
1,212,938
Messages
6,110,789
Members
448,297
Latest member
carmadgar

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
Back
Top