Where to start?
 

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

Thanks for any help.

E

--
edwardpestia
-----------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...fo&userid=3380
View this thread: http://www.excelforum.com/showthread.php?threadid=53618

Where to start?
 

Hi Edward,

As a starting point, turn on the macro recorder while you perform the
required steps manually.

This will provide you with base code which can be edited to enable more
generic application. If you experience problems with such editing, post back
with details.


---
Regards,
Norman


"edwardpestian"
wrote in message
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

Where to start?
 

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

Where to start?
 

Hi Edward
Add a shape to your page to represent your button, eg a small circle.
Right click on the shape and assign a macro to it.

Macro could be ...

sub DataShift ()
Set Sh1 = Sheets("Nameofsheet")
Set Sh2 = Sheets("Nameofsheet2")

Sh2.range("A1:A20") = Sh1.range("C1:C20").value

end sub

edwardpestian wrote:
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