Filling Excel forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bestofanil@gmail.com - 15 Nov 2006 10:50 GMT

I have to fill Excel forms form a data given in rows & colums. Every
time I use to copy & paste.

To fill one form I have details in many colum of single row and again
second form from other row & its colum.

It take a lot of time in filling hundreds of form.

Is there any way to fill these forms at once from a data in other excel
file.

Pls help.

Anil

Reply to this Message

Max - 15 Nov 2006 13:33 GMT

Not very sure, I'm afraid, based on what has been posted.

Perhaps you could use either VLOOKUP or INDEX/MATCH to extract data from
your source table

Browse Debra's nice coverage on VLOOKUP or INDEX/MATCH at her:
http://www.contextures.com/xlFunctions02.html
VLOOKUP

http://www.contextures.com/xlFunctions03.html
INDEX/MATCH

There's also some sample workbooks available for d/l & study

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

>I have to fill Excel forms form a data given in rows & colums. Every
> time I use to copy & paste.
[quoted text clipped - 10 lines]
>
> Anil

Reply to this Message