Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving a row from one sheet to another
Hi, I am trying to create a spreadsheet whereby the input of
information into a cell on a row will cause the data from that row to be transferred to another sheet. The workbook I am creating is a log for warehouse/ stock discrepancies. The first sheet will contain all the discrepancies as they arise - with a column titled "resolved by" where the person will enter their initials once they have resolved the problem. As soon as this cell is completed, I want that entire row to transferred to the next available row on a "resolved discrepancies" sheet, and to be deleted from the first "discrepancies" sheet. I hope this makes sense! Any help would be much appreciated. I have some limited VBA knowledge but this is beyond my capabilities! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula for moving information from one sheet to another sheet | Excel Discussion (Misc queries) | |||
moving from one sheet to another from a cell of a sheet | Excel Worksheet Functions | |||
moving informatiion from one sheet to a total sheet | Excel Discussion (Misc queries) | |||
moving around a sheet | Excel Programming | |||
Moving sheet | Excel Discussion (Misc queries) |