| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data/Form
Excel has has a built in function Data/Form which allows you to scroll
items in the selected columns and make changes if necessary. I have 2 sheets in a workbook named "sheet1" and "parts". I have to go from sheet1 to sheetParts to use Data/Form to change the information in sheetparts then back to sheet1 then back to sheetparts and so on. Question: Is it possible to use Data/Form from "sheet1" and have it Data/Form for "parts" |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data/Form
Hi
not with the build in functionality -- Regards Frank Kabel Frankfurt, Germany "~Alan" schrieb im Newsbeitrag ... Excel has has a built in function Data/Form which allows you to scroll items in the selected columns and make changes if necessary. I have 2 sheets in a workbook named "sheet1" and "parts". I have to go from sheet1 to sheetParts to use Data/Form to change the information in sheetparts then back to sheet1 then back to sheetparts and so on. Question: Is it possible to use Data/Form from "sheet1" and have it Data/Form for "parts" |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data/Form
is there a work around
Frank Kabel wrote: Hi not with the build in functionality -- Regards Frank Kabel Frankfurt, Germany "~Alan" schrieb im Newsbeitrag ... Excel has has a built in function Data/Form which allows you to scroll items in the selected columns and make changes if necessary. I have 2 sheets in a workbook named "sheet1" and "parts". I have to go from sheet1 to sheetParts to use Data/Form to change the information in sheetparts then back to sheet1 then back to sheetparts and so on. Question: Is it possible to use Data/Form from "sheet1" and have it Data/Form for "parts" |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data/Form
Alt F1
Insert User form. From thier you can create your own forms any way you like RK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula (off form) that completes form data based on a result | Excel Worksheet Functions | |||
| excel form. Need data extracted to spreadsheet each time a form co | Excel Discussion (Misc queries) | |||
| Create a form in excel so I can enter data using DataForm | Excel Discussion (Misc queries) | |||
| how to get a data form to fill you own exel sheet (was data-form | Excel Worksheet Functions | |||
| have 3 worksheets, 1 is a form, the other 2 data for the form-wan. | Excel Worksheet Functions | |||
Hybrid Mode
