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:
<tbody>
</tbody>
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 1 | Book Name | Excel-1 | |||||||||
Issue Date | 01-12-16 | Version No. | 1 | ||||||||
Subject | Excel Help-1 | Language | E | ||||||||
Nuber of Pages | 250 | Color | Black | ||||||||
Publisher Name | Excel Expert-1 | Publisher Nationality | E | ||||||||
Nuber of copied published | 5000 | Price | $10 | ||||||||
Sheet 2 | Book Name | Excel-2 | |||||||||
Issue Date | 01-12-16 | Version No. | 1 | ||||||||
Subject | Excel Help-2 | Language | E | ||||||||
Nuber of Pages | 250 | Color | Black | ||||||||
Publisher Name | Excel Expert-2 | Publisher Nationality | E | ||||||||
Nuber of copied published | 5000 | Price | $10 | ||||||||
Sheet 3 | Book Name | Excel-3 | |||||||||
Issue Date | 01-12-16 | Version No. | 1 | ||||||||
Subject | Excel Help-3 | Language | E | ||||||||
Nuber of Pages | 250 | Color | Black | ||||||||
Publisher Name | Excel Expert-3 | Publisher Nationality | E | ||||||||
Nuber of copied published | 5000 | Price | $10 | ||||||||
New Sheet | Book Name | Issue Date | Subject | Nuber of Pages | Publisher Name | Nuber of copied published | Version No. | Language | Color | Publisher Nationality | Price |
Excel-1 | 01-12-16 | Excel Help-1 | 250 | Excel Expert-1 | 5000 | 1 | E | Black | E | $10 | |
Excel-2 | 01-12-16 | Excel Help-2 | 250 | Excel Expert-2 | 5000 | 1 | E | Black | E | $10 | |
Excel-3 | 01-12-16 | Excel Help-3 | 250 | Excel Expert-3 | 5000 | 1 | E | Black | E | $10 |
<tbody>
</tbody>