Moving data from one worksheet to another

Hi, I need to move entrie rows from one worksheet to another when work is in progress. I search first & found this post. What is VBA & is it possible for me to do??

Thanks Nadine


http://www.excelforum.com/showthread.php?t=650558

Originally Posted by vanchi233

I need a formula that will allow complete row information to be moved to another sheet upon status change.....

ex


name last name status etc etc

when changing from p to n under status the row should then be made visible on the other page

The reply was...

Originally Posted by ilyaskazi_01

This will require automation code through VBA and cannot be done with Excel formulas...
...

VBA is Visual Basic for Applications which is a programming language that Excel uses (as does Word, Powerpoint, etc.). It's hard to tell based on what the information you gave as to whether it can be done with formulas or requires VBA. In general, anything that can be done with formulas can also be done with VBA but not visa versa.

You have a working spreadsheet tab where data is inputted and upon the completion of a row of data, you want that row of data to be moved to (copied or cut?) to another spreadsheet (workbook or tab?). Will the rows of data be finished sequentially or could row 5 be completed before row 3? Anything else we should know?

ChemistB

Hi, After lots of searching I have found some code (on here) that will nearly do want I would like. I'm just not sure how to change it. I don't know how to attach the code for you to see.

What I have is 2 workbooks which contain, Orders & Dispatch worksheets. I have in the Orders worksheet a cell with a dropdown box containing Order, Dispatch & Final Dispatch. What I would like to do is when I choose Dispatch the row is copied to the Dispatch worksheet and when I choose Final Dispatch the row is cut to the Dispatch worksheet.

The rows of data could be finished in any order.


Thanks N

Hi,
I don't want to be rude so incase anyone replies (Fingers crossed you do ) I'm not in work until Thurs 31st July so I won't be able to reply till then.

Thanks N

Okay, when you come back, if you can post the code (See link here on how to bracket it http://www.excelforum.com/misc.php?do=bbcode#code ) that would be appreciated. Depending on the code, it might go into a module, workbook module or worksheet module. I'd have to see the code.

ChemistB

Hi, this is the code, i've borrowed from someone else.

Private Sub Worksheet_Change(ByVal Target As Range)
  On Error GoTo errhand
  Application.EnableEvents = False
  If Target.Cells.Count = 1 And Target.Column = 4 And Target.Value = "Processed" Then
    Target.EntireRow.Copy Destination:=Sheets("Processed").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)
    Target.EntireRow.Delete
  End If
errhand:
  Application.EnableEvents = True
End Sub

Thanks. Can you recommend anywhere to learn this? I've got loads of stuff that would benefit from being more automated.

Nadine