Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Data Input Box
Hi Everyone,
This is my dilemma. I am looking for a way to create a data input box that will put data into a spreadsheet one entry at a time and then drop down a cell. I want to put the information into a spreadsheet in a uniform fashion. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Data Input Box
Gary
Don't understand your need. If you enter data in A1 then <ENTER you will drop down to next cell. "Uniform fashion" means what? Gord Dibben Excel MVP On Thu, 15 Dec 2005 22:56:00 GMT, "GaryC" <u16704@uwe wrote: Hi Everyone, This is my dilemma. I am looking for a way to create a data input box that will put data into a spreadsheet one entry at a time and then drop down a cell. I want to put the information into a spreadsheet in a uniform fashion. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Data Input Box
Try selecting your range then hitting Data|Form.
If you need more, you may want to look at John Walkenbach's enhanced dataform: http://j-walk.com/ss/dataform/index.htm may be sufficient And if you want to create your own, then Debra Dalgleish has a get started with userforms: http://contextures.com/xlUserForm01.html GaryC wrote: Hi Everyone, This is my dilemma. I am looking for a way to create a data input box that will put data into a spreadsheet one entry at a time and then drop down a cell. I want to put the information into a spreadsheet in a uniform fashion. -- Dave Peterson |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Data Input Box
I'm sorry to confuse you on this. I would like to have a box that I can input
data that will go to its respective column. The input box will give you 3 or 4 areas to input data and this data will be put into its repsective column. Thanks Gord Dibben wrote: Gary Don't understand your need. If you enter data in A1 then <ENTER you will drop down to next cell. "Uniform fashion" means what? Gord Dibben Excel MVP Hi Everyone, This is my dilemma. I am looking for a way to create a data input box that will put data into a spreadsheet one entry at a time and then drop down a cell. I want to put the information into a spreadsheet in a uniform fashion. |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Data Input Box
Yes. That is it !!!
I really appreciate all of the help. Thanks, Gary Dave Peterson wrote: Try selecting your range then hitting Data|Form. If you need more, you may want to look at John Walkenbach's enhanced dataform: http://j-walk.com/ss/dataform/index.htm may be sufficient And if you want to create your own, then Debra Dalgleish has a get started with userforms: http://contextures.com/xlUserForm01.html Hi Everyone, This is my dilemma. I am looking for a way to create a data input box that will put data into a spreadsheet one entry at a time and then drop down a cell. I want to put the information into a spreadsheet in a uniform fashion. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
How do you transfer data from an input form in excel to an excel l | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |