Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autocopy of data filtered by drop down list
I am creating a new form that takes employee expenses. On each line of the
expense form the employee can chose employee paid or company paid from a drop down list. What I have done is created an IF query to copy the data to a corresponding sheet (one titled company paid and the other employee paid), depending on whether company paid or employee paid was chosen, however the part I can not work out how to do is to ensure that when the data is copied to the new sheet that the next available line is used rather than a straight linked cell. Is there anyway to automatically go to the next available line on each sheet when the data qualifies rather than having blank lines inbetween when a straight linking command is used and the IF criteria is satisfied. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking data between sheets using drop down list | Excel Worksheet Functions | |||
Populating worksheet via a drop down list ! | Excel Worksheet Functions | |||
update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) |