Hi all,

I have a report that needs to be filled and printed.
500 of those reports.
Data for them is in a sheet in form of a table.

What I need to do is to take a row from one sheet, put the data in another
sheet in correct places, print it, take next row, print it etc.

Any idea how can I do it using Excel only ?

Plan B is to make an application that using automation will do it using
those 2 sheets.
But I would prefer to do it simple as possible.

I would appreciate any concepts.

Best Regards
Pawel

Why not just use Mail Merge in Word?

Pees wrote:

> Hi all,
>
> I have a report that needs to be filled and printed.
> 500 of those reports.
> Data for them is in a sheet in form of a table.
>
> What I need to do is to take a row from one sheet, put the data in another
> sheet in correct places, print it, take next row, print it etc.
>
> Any idea how can I do it using Excel only ?
>
> Plan B is to make an application that using automation will do it using
> those 2 sheets.
> But I would prefer to do it simple as possible.
>
> I would appreciate any concepts.
>
> Best Regards
> Pawel
>
>

Maybe this stuff from Debra Dalgleish's site:
http://contextures.com/xlForm03.html
and maybe...
http://contextures.com/xlForm02.html

Pees wrote:
>
> Hi all,
>
> I have a report that needs to be filled and printed.
> 500 of those reports.
> Data for them is in a sheet in form of a table.
>
> What I need to do is to take a row from one sheet, put the data in another
> sheet in correct places, print it, take next row, print it etc.
>
> Any idea how can I do it using Excel only ?
>
> Plan B is to make an application that using automation will do it using
> those 2 sheets.
> But I would prefer to do it simple as possible.
>
> I would appreciate any concepts.
>
> Best Regards
> Pawel

--

Dave Peterson

Thanks, very helpful links

> Maybe this stuff from Debra Dalgleish's site:
> http://contextures.com/xlForm03.html
> and maybe...
> http://contextures.com/xlForm02.html
>
> Pees wrote:
>>
>> Hi all,
>>
>> I have a report that needs to be filled and printed.
>> 500 of those reports.
>> Data for them is in a sheet in form of a table.
....
>> Pawel
>
> --
>
> Dave Peterson