#1
|
|||
|
|||
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
|
#2
|
|||
|
|||
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. |
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 |
Need cells to autofill with color | Silver Rain 007 | Excel | 1 | 10-22-2009 08:19 PM |
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 |
Radio (options button) problem | Niros | Excel | 1 | 11-24-2005 09:58 AM |