software

we have a invoice spreadsheet which gets firgures fron a another spreadsheet
amp; makes invoice for ex:
invoice column 1= Quantity
invoice column 2= Descriptition
invoice column 3= Price
invoice column 4= Total
Field 1= Name
Field 2= Add
Field 3= City

in the other spreadsheet we have columns with all description of these
column , we like to be able to pick row 36 from other spreadsheet and the
whole info shall be transfered automatically how can we do it?

There has to be a common element to both spreadsheets (Ex invoice # or
something). The common element has to be unique (no other row can have the
same value). Then you could use the VLOOKUP function to pull in all the
other data once you have entered the quot;common elementquot;.

quot;dkquot; wrote:

gt; we have a invoice spreadsheet which gets firgures fron a another spreadsheet
gt; amp; makes invoice for ex:
gt; invoice column 1= Quantity
gt; invoice column 2= Descriptition
gt; invoice column 3= Price
gt; invoice column 4= Total
gt; Field 1= Name
gt; Field 2= Add
gt; Field 3= City
gt;
gt; in the other spreadsheet we have columns with all description of these
gt; column , we like to be able to pick row 36 from other spreadsheet and the
gt; whole info shall be transfered automatically how can we do it?