| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple inputs from "Input Box"
I want to get multiple entries to paste to another sheet. I have the
following input box working to request one entry. Can anyone tell me how to use the same box for multiple requests to append to "Sheet1"? Also, if entry is wrong, I need to just return them back to the input box. Please forgive any mistakes, I just had brain surgery...Really!! Market = Application.InputBox("Enter your market") Sheets("Daily_info").Select Range("A1").Select Selection.AutoFilter Selection.AutoFilter Field:=18, Criteria1:=Market, Operator:=xlAnd Range("A1").Select Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select Selection.Copy Sheets("Sheet1").Select ActiveSheet.Paste |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| "read" inputs past end of file | Excel Discussion (Misc queries) | |||
| When I input "25:03" as a time, it reads "1:03" | Excel Discussion (Misc queries) | |||
| Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
| Is there a function like "Data Table" for multiple Inputs | Excel Worksheet Functions | |||
Threaded Mode
