software

quot;dkquot; wrote:

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?


Maybe a VLOOKUP formula might be your solution, here's a site that
expalins it very well

www.contextures.com/xlFunctions02.html--
davesexcel------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=537541almost what we want but need different ex; we shall enter in 1 cell row 34
all values only from that row shall in we shall only need to change 1 cell
and all cells shall be changed automatically

quot;davesexcelquot; wrote:

gt;
gt; Maybe a VLOOKUP formula might be your solution, here's a site that
gt; expalins it very well
gt;
gt; www.contextures.com/xlFunctions02.html
gt;
gt;
gt; --
gt; davesexcel
gt;
gt;
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=537541
gt;
gt;


Almost??thats what VLOOKUP does!!

Here's a small example -------------------------------------------------------------------
|Filename: VLOOKUP3.zip |
|Download: www.excelforum.com/attachment.php?postid=4710 |
-------------------------------------------------------------------

--
davesexcel------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=537541according to what we understand vlookup all items details in several cells
which will always pick from those cells but our ex: is we each row has a
different name amp; charges and we have another sheet which is designed for
invoice so if we will put our invoice customer # 35 (ex: dave) all columns
from row 35 shall be copied in different location in invoice and if we put
lcustomer # 99 all columns from row 99 shall be copied in different
location in invoice

quot;davesexcelquot; wrote:

gt;
gt; Almost??
gt;
gt;
gt; thats what VLOOKUP does!!
gt;
gt; Here's a small example
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: VLOOKUP3.zip |
gt; |Download: www.excelforum.com/attachment.php?postid=4710 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; davesexcel
gt;
gt;
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=537541
gt;
gt;

Please instruct we are new

quot;dkquot; wrote:

gt;
gt;
gt; quot;dkquot; wrote:
gt;
gt; we have a invoice spreadsheet which gets firgures fron a another
gt; 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?


were you able to look at the example I posted??--
davesexcel------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=537541no

quot;davesexcelquot; wrote:

gt;
gt; were you able to look at the example I posted??
gt;
gt;
gt; --
gt; davesexcel
gt;
gt;
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=537541
gt;
gt;

It seems link doesn't work

quot;dkquot; wrote:

gt;
gt;
gt; quot;dkquot; wrote:
gt;
gt; we have a invoice spreadsheet which gets firgures fron a another
gt; 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?


I'll give it another try -------------------------------------------------------------------
|Filename: VLOOKUP3.zip |
|Download: www.excelforum.com/attachment.php?postid=4717 |
-------------------------------------------------------------------

--
davesexcel------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=537541