I have the following workbook and probably should have this done i
Access, but Excel is problem enough for me right now:

http://www.ashleylandscaping.com/sample.xls

On the "Cust Info" sheet, and when I select a name in the drop dow
list, it fills in the Cust ID number above. When I have a number in th
Cust ID box and click the "Get Customer History" button, It should the
look for that Cust ID # in the three different worksheets named "Jo
History, Invoice History, and Invoice History". It should then copy Th
Column Heading for each of those sheets and any row with a matching Cus
ID.

Ive got other worksheets with macros copying and pasting rows and such
but I couldnt figure out how to copy column heading and the rows. Also
couldnt figure out how to make it paste info without overwritin
previous rows because of the variance in the number of rows that may b
imported from each of the 3 sheets.

Heres what it looks like now:
http://www.ashleylandscaping.com/now.jpg

And the result should look something like this:
http://www.ashleylandscaping.com/want.jp

--
cbr
-----------------------------------------------------------------------
cbrd's Profile: http://www.excelforum.com/member.php...fo&userid=3000
View this thread: http://www.excelforum.com/showthread.php?threadid=49961