Move Data from one sheet to another

[hjohnson75]

Hello

I have a pipeline report that includes 2 worksheets. I would like the contents of a row moved once a status is changed to "Complete". Would this be a macro? or VBA code? Either way I need help understanding what i can do to get this to automacially update for my operations group.

Thanks so much for your help.

[arlu1201]

VBA and Macro code is the same.

Do you want the data transfer to happen on the click of a button?

[hjohnson75]

Wow that was fast thanks. I really just want the data to move either after they save the sheet or maybe after they select the status? I will refer to what you think i easier for an older user community.

Thanks

[arlu1201]

Try this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose Tools | Macro | Macros
Select a macro in the list, and click the Run button

You can also insert a button on the main sheet and assign the macro to the button. You can ask the users to fill up the status, then click on the button to trigger the move.

Alternatively, instead of using a button, you can also assign a shortcut key to the macro so that it can be triggered whenever they press the key.