Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filtering information
I have a workbook(Excel 2007), with 2 sheets the first is called data
log the second is called input data. The actual data is a list of records for our concern management system, as below A B C D E F G 1 DATE Kanban Part No Part name Colour Fault Action 2 3 23-Aug-09 C654 12548-25-558 Assy wper 5 Blue Ext blister Rejected In Input data I have arranged the cell and formatted them to look like an Access form. Column C, D, E are VLookup from the data in column B. Column F & G have Validation list boxes in each of the cells. Anyway, when I have entered the data in the cell in Input data sheet, I would like a macro attached to a button to goto the data log sheet, find the next free row and input data from Input data to specific cells in data log sheet. Some of this data may be lookup or list boxes. I have tried and tried to do this and have got no where. The data doesn't copy & past well, perhaps I should have tried paste special/ values ? Can anyone help please. Best regards Duncan. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with filtering & inserting information :( | Excel Worksheet Functions | |||
Filtering duplicate information | Excel Worksheet Functions | |||
Filtering Information | Excel Discussion (Misc queries) | |||
filtering out rows with duplicate information | Excel Discussion (Misc queries) | |||
Functions for manipulating and filtering address information | Excel Discussion (Misc queries) |