Excellant that worked great and the vb made it easier! ok so how do i get it
to use the next line down of customer info. i tired to use a loop but to no
avail! and could i assign this to a custom made button on the tool bar?

"UofMoo" wrote:


Hi Rick,

If you just have a summary line you want copied, you could use vlookup
in the invoice spreadsheet to just pull the data you want from the
other two spreadsheets.

=vlookup(lookup_value,table_array,col_index_num,ra nge_lookup)
where
-lookup_value is the company ID or some common data
-table_array is the data to look up the lookup_value in (other sheet
reference)
-col_index is the column to return (ie, sales column etc from other
sheets)
-range_lookup should be false unless your lookup data is sorted

If you want to use VB you'd probably want to look at something like
this:
Sheets("custinfo").Range("A1:A6").Copy _
Destination:=Sheets("invoice").Range("C2")


--
UofMoo
------------------------------------------------------------------------
UofMoo's Profile: http://www.excelforum.com/member.php...o&userid=26485
View this thread: http://www.excelforum.com/showthread...hreadid=397603