Excel 2002: Simple VB script...help!
Posted on 2003-03-31
I've got a spreadsheet which contains 3 worksheets. The main
worksheet is a list of records, and when i complete a task for a
record, i enter YES into a field for that record. After doing that,
i would like that record to automatically be copied to another
worksheet, which would contain all of the records that i have entered
a YES for.
Currently i am doing this manually, by seleceting the record, and
copying & pasting, but this is proving to be tedious, and i know
(think...hope) there is a way to automate this.
Someone provided me with this code, but seeing that i'm VB-illiterate, i don't know how to use it properly.
You can use the Worksheet_Change event to copy a line when a certain range
is changed to YES. It might look like this
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 5 Then
If Target.Value = "YES" Then
This example looks in column E. If you enter a yes, it copies the whole row
to a sheet named YES to the next empty cell in column A.