Forum home » Delegate support and help forum » Microsoft Excel Training and help » Create a new workbook for each row in a shared work book

Create a new workbook for each row in a shared work book

ResolvedVersion 2016

Tue 22 Jun 2021, 15:07 Delegate Bhakti said...

Bhakti has attended:
Excel Advanced course

Create a new workbook for each row in a shared work book

Is it possible to create a new workbook for each row in a shared work book, in a specific layout?

Wed 23 Jun 2021, 09:42 Trainer Jens said...

RE: Create a new workbook for each row in a shared work book

Hi Bhakti,

Thank you for the forum question and thank you for the nice feedback.

I am happy that the course was useful.

It is not an easy task to create a new workbook for each row in a shared work book, but it can be done, but only with some advanced VBA.

I will need to have Advanced VBA knowledge. Unfortunately it cannot be done with the macro recorder.

I found a link here with the code you need but the code need to be amended to fit your data structure and also how you want the multiple created workbooks structure to be.

https://stackoverflow.com/questions/26565206/creating-a-new-workbook-for-each-row-in-an-existing-workbook

I hope the link will be useful.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Wed 30 Jun 2021: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Use the Format Painter to copy formatting more than once in Excel

The format painter tool provides a quick and easy way to copy formatting from one cell to another in Word.

The only problem is that if you click the Format Painter once to turn it on, you can only click and drag over a single cell or adjacent range of cells; then the Format Painter turns itself off automatically.

If you want to copy formatting to cells or groups of cells that are not adjacent to each other, double-click the Format Painter - this way you will be able to copy formatting to multiple cells.

When you have finished using Format Painter, press the Esc key or click on the Format Painter button once to turn it off.

View all Excel hints and tips

Create a new workbook for each row in a shared work book

Create a new workbook for each row in a shared work book

RE: Create a new workbook for each row in a shared work book

Excel articles

Excel tip:

Use the Format Painter to copy formatting more than once in Excel