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