Import data from excel spreadsheet in to Excel user form/proforma?

I have a spreadsheet of contractor information (roughly 150 contracts), things like contract ref number, main contractor organisation, contractor department, and payment schedule breakdown. I need to import this information in to a proforma, 1 for each contract. The proforma will then be used as purchase orders. To input the data manually is a lot of work I was wanting to know if there is a quicker way, perhaps a macro, to do this. Any help or tips will be much appreciated.

Thanks.

See there are two ways to do this.

1. Using Excel:

Create a Standard Proforma’s format that does contains Contract’s Ref Number

Then use Vlookup Formula to Import the Necessary Information from Contract’s Spreadsheet.

Ex: if you want to Import Main Contractor Organization then use

=Vlookup(Lookup_Value, table_array, col_index_num, false)

http://www.free-training-tutorial.com/function-vlookup.html

2 Using Winword

a. Create a standard sheet that contains all the data related to proforma
b. Create a standard Word file that contains the format of Proforma

now using mail-mearge feature of Word you can import the information from the Excel Sheet into word file.

http://word.mvps.org/faqs/MailMerge/CreateAMailMerge.htm

finish with mearge and you are done.

you even don’t need to save the final mearged file you can do this mearge at as many time you want.

Hope this will help you.

(*.*)

http://xlxpart.blogspot.com

Main Contractor LLC

Tired of LOUSY service? Try Angie’s List.

Comments are closed