Do you have one form in sheet 1 and you want to fill the form with data from
sheet 2, then maybe print the form, then repeat the process with the next
row of data in sheet 2? What do you mean by "categories"? Post back and
provide more detail about what you have and what you want to do. Certainly
what you want to do can done with either formulas or VBA. HTH Otto
"Doug" wrote in message
...
Hi,

I have to fill out several hundred forms with certain unformation,all the
forms are identical and have catagories. The information to be filled in
is
contained in another worksheet,this information is in rows.
I have set up a filter in the forms worksheet hoping to paste the required
information in,one catagory at a time.However as the filtered information
is
"hiding" other cells i am unable to do this.
So my question is ; Is there a way to paste into a filtered selection,if
not
is there another way i can do this?

Sheet 1 FORMS

A B C
1 Name
2 Prod 1
3 date
4 address
5 size
6 weight

Sheet 2 DATA
A B C
1 Name John
2 Prod 1 Hammer
3 date june 1st
4 address London
5 size 1 mtr
6 weight 3Lb


Any help appreciated.

Doug