Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-02-2009, 01:21 AM
IG&H IG&H is offline autofill data using keywords or button clicks Windows XP autofill data using keywords or button clicks Office 2007
Novice
autofill data using keywords or button clicks
 
Join Date: Dec 2009
Posts: 1
IG&H is on a distinguished road
Default autofill data using keywords or button clicks

i have been asked to create an excel spreadsheet for users with little or no experience of excel, the idea is that the user either clicks on a button and it fills in multiple cells with pre defined data or enters a keyword which automaticly fills in multiple cells with pre defined data, i have experience of excel but very limited knowledge of visual basic, so really im just wondered what would be the easiest and simplest way of doing this, i dont mind researching a topic myself but as i said im unsure of what would best suit my situation, i have tried looking at drop down lists and combo boxes etc but got a little lost and didnt really get anywhere, i have uploaded where i have got to so far, its simple enough it has buttons which copy and paste data from one sheet into the master db (dist board) sheet, the only problem is the users could have 100 dist boards for every customer, so whenever i copy the db sheet to say db(1) it copies the buttons fine, but they always want to copy the data into db and not the new db(1) sheet, as obviously thats what the vb script is telling ti to do, if that makes any sense, any help would be appreciated
Attached Files
File Type: xls Deviation Schedule (New Template).xls (178.0 KB, 24 views)
Reply With Quote
  #2  
Old 01-17-2010, 08:08 AM
BjornS BjornS is offline autofill data using keywords or button clicks Windows Vista autofill data using keywords or button clicks Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

Hi, a little unsure exaclty how you want your workbook to work, I have a suggestion in another direction. Se attached example. Go to sheet "db". Place the cursor in Cell E44 and select a error type using the drop down list (I just added this for "Cabling" and "DistBoard"). In the column F the Code is calculated automatically. I formatted down to line 100.

You could still have use of you buttons at the top of sheet "Db", by giving the user a possibility to read the error codes more clearly than in the drop down list. At each sheet ("Cabling" etc) you could have only one button "Back to main page".

The drop down list are using data at lines 1-41 in sheet "db" ("Data / verify"). Those lines are hidden. Unfortunately the data must be on the same sheet, and therefore I think the best way is to have them at the top and hide them.

I didn't care much about formatting in the attached file. Just a little quick example to show the possibilities.
Attached Files
File Type: xls Deviation Schedule (New Template) ver 2.xls (197.5 KB, 4 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help on option button active X aligahk06 Excel 0 11-03-2009 11:39 PM
autofill data using keywords or button clicks Need cells to autofill with color Silver Rain 007 Excel 1 10-22-2009 08:19 PM
autofill data using keywords or button clicks no send / receive button or functionality gooduser1 Outlook 2 04-24-2009 08:54 AM
Run Outside application from toolbar button Richard Harison Word 3 12-20-2005 03:22 PM
autofill data using keywords or button clicks Radio (options button) problem Niros Excel 1 11-24-2005 09:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:27 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft