Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automate form filling
Is it possible in excel to have a form on sheet 2 that gets populated with data from sheet 1.
What i am hoping to do, but dont know how, is fill sheet 1 with data contained in about 6 or 7 columns into a sheet/form housed in sheet 2 at the press of a button. What i am planning to do is fill sheet 1 with data housed in 7 columns titled as an example A Model B Range C Manufacturer and fill these up using a form. There is about 60 at the moment but this number might grow/reduce details change etc etc and when required click a button run a macro or whatever that will take this data again as an example from row 6 and fill a sheet/form or sheet 2 so i can print this sheet of and take to an external agent to carry out the work. |
#2
|
|||
|
|||
Quote:
Named Ranges: To name a range, select the data in column A, and in the top left-hand corner (where you'll see A1) type in a name for the range - i.e. "Model" then press Enter. Do this for each of your columns of data. Data Validation: On Sheet2 click on a cell where you want the dropdown and under Data (in Excel 2007 - Tools, I think, in Excel 2003) select Data Validation. Under Allow, select List and for the Source, type in "=Model" (or whatever you named your range). Do this for each of the three named ranges you created on Sheet1. Doing this will allow you to fill in data on Sheet1 and select it later on from dropdowns in Sheet2. If this doesn't suit, let me know, because as you say, there is also the macro option, plus a number of other ways depending upon how automated you would like it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automate opening an add-in form | Excel Discussion (Misc queries) | |||
Filling in a Gov't Form | Excel Discussion (Misc queries) | |||
Form Filling | Excel Discussion (Misc queries) | |||
use VB code IF to automate filling in 11 columns | Excel Discussion (Misc queries) | |||
Filling in a form from a list | Excel Discussion (Misc queries) |