Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How do I create a button (say on sheet #3) that will change the incomin
data link from either sheet 1 or sheet 2 On sheet #3, I am importing data from either sheet #1 or #2 dependin on circumstances. Both sheet #1 and #2 are duplicate layouts, bu different data. ex: (assume cell info) From Sheet #1: Item Est Qty: Manuf. Model Description 1 3 ABC 1234-AB Widget 2 4 ABC 1-234-DF Nugget 3 6 ABC 237-TD Contraption From Sheet #2: Item Est Qty: Manuf. Model Description 1 4 ACME 99-874 Really big widget 2 2 ACME 98-564 Really big Nugget 3 1 ACME 96-226 Really small Contraption and by clicking the button, sheet #3 will either import the data fro sheet 1 or 2. I consider myself very proficient in excell formula's but I have no done control or VBA Programming. In addition is it possible that the button will change its labe depending on which data is being utilized? See Temp file. Thanks B Attachment filename: temp.xls Download attachment: http://www.excelforum.com/attachment.php?postid=37932 -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Control Button | Excel Discussion (Misc queries) | |||
Counting, command button and programming in VB | Excel Discussion (Misc queries) | |||
Control box and button | Excel Discussion (Misc queries) | |||
Command Button vs Control Button | Excel Programming | |||
Programming behind a button | Excel Programming |