Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need code to copy/move data between sheets
I am hoping someone can point me in the right direction. I have a sheet called Log and a sheet called Completed Log in an Excel 2007 workbook. I have check boxes in Column B of the Log sheet to signify if the line is complete. There could be one item that is completed or there could be ten items. I would like to create a Macro that checks each line for a marked check box. Copy the information from Column D to Column L of the Marked row on sheet Log to the next open row starting at column B in the sheet Completed Log. After the information has been moved to the Completed Log, I would like to remove the completed lines in sheet Log, uncheck the box and move the remaining lines on the Log sheet up to fill the spaces. Thank you in advance. Ron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy or Move row on condition to different and/or multiple sheets | New Users to Excel | |||
move or copy sheets doesn't copy format | Excel Worksheet Functions | |||
Cannot Move or Copy Sheets | Excel Discussion (Misc queries) | |||
How do I copy and move selections of data to other sheets? | Excel Worksheet Functions | |||
copy/move sheets within workbook | Excel Discussion (Misc queries) |