Create macro that fills table form, from one row data.

[CiraLoC]

Hi guys,

I have one task that i would like to get some help, if someone is kind enough and have time to take a look.

I attached the file with one manually filled example. In sheet1 i have multiple rows on some data, in sheet2 i have table form and one filled example how the data from sheet1 rows should be distributed in table.

So i need some code to be able to auto create multiple 1000+ tables from respective number of rows in sheet1.

Many thanks in advance!

[Richard Buttrey]

Hi,

See the attached. It uses the following macro.

The macro loop is set to 10. Remove the 10 so that it reads For x = 1 to lrows
1000 rows may take some time so it would be better to create an array in VBA and process the array.

I'll do that a bit later

That said, wouldn't a Mail Merge Labels in Word be preferable?

Please Login or Register  to view this content.

[Richard Buttrey]

Mmmm

Came to look at using a VBA array. It's simple enough to read the data into VBA as an array but building an output array , particularly where merged cells are involved is a little trickier. Needs more thought........

[CiraLoC]

I appreciate your time man. The first solution works fine for me, as far as i saw for this testing purpose. Tomorrow I will put it on some more serious task in terms of much more data. But i think it should do the job.

So don't need to put much more thought into it, unless you want so ofc.

Many thanks!

[Richard Buttrey]

Here's the array macro which of course is much much quicker

Please Login or Register  to view this content.

[Richard Buttrey]

I appreciate your time man. The first solution works fine for me, as far as i saw for this testing purpose. Tomorrow I will put it on some more serious task in terms of much more data. But i think it should do the job.

So don't need to put much more thought into it, unless you want so ofc.

Many thanks!

Glad to have helped and thanks for the rep

[Richard Buttrey]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.