Copy completed list to another sheet ?

hi there. you can use 2 methods here. but before you do that, convert Work task A1:C6 to a Table first. just click on A1 and press CTRL + T. that gives you a dynamic range where you don't have to constantly change the range. the first method is via an array formula. in cell A2:

Formula:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

same as the other 2 formulas in B2 and C2:

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

the other is through something called worksheet event. it triggers a macro after a particular worksheet is activated.

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Press CTRL+R to ensure Project Explorer window is on the left
5. Edit > Paste the macro into the right window that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:[*]Select the Work Completed worksheet[/list]
by the way, do mark threads as "Solved" once it answers your question. you can refer to my signature on some guides.