Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating form on sheet 1 and having info move to sheet 2
Please help....
I am creating a "form" on sheet one and inputting text in 5 cells Column A Column B ex. Input Serial #: ____________ Input location: ____________ etc... How can i get the text in those column b cells to move over to sheet 2 in a columnar spreadsheet. Ideally my thought is to have a "button" you would press that would say "complete" and then the data from those 5 cells would move to sheet 2 columns a-f row 1, and then those 5 cells would clear in sheet 1 to be able to enter more data in those same 5 cells which would move to columns a-f row 2. Hope this is clear enough for you to understand, if not just ask for further clarification. Thanks! -- Thanks, Sharon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Annual Wages Sheet to pick up info from Time Sheet | Excel Worksheet Functions | |||
Move data to new sheet - rename sheet based on criteria ? | Excel Discussion (Misc queries) | |||
Finding Info from sheet 1 and removing only those rows from sheet | Excel Discussion (Misc queries) | |||
move rows of data seperated in a sheet to a sheet with no separat | Excel Worksheet Functions | |||
TAKING INFO FROM ONE SHEET AND PRODUCING A LIST IN ANOTHER SHEET | Excel Discussion (Misc queries) |