I will keep it simple:

Range ("Table").Select 'If the range has a name, otherwise
Range ("A1:D8").Select
Selection.Copy
Sheets("Sheet2").Select
Range (A1).select
ActiveSheet.Paste

Succes


"edwardpestian"
schreef in bericht
news:edwardpestian.26ubym_1146003005.6151@excelfor um-nospam.com...

I need a button that when pressed, will take data from one table and
populate it into another table on a different worksheet.

Thanks for any help.

EP


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile:
http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=536188