copy data based on cell entry to different spreadsheet

Hi

Here's a couple of links

Here

Here

Here

Hope these get you started....


rylo

Originally Posted by rylo

Hi

Here's a couple of links

Here

Here

Here

Hope these get you started....


rylo

thanx for the reply, but not really what I am looking to do
Here is an example of what the[list.xls] looks like:
\1
In the status column agents enter status/notes of account. What I am trying to accomplish is to have the account #, balance, and date copy over to a [summary.xls] on a shared folder based on the notes entered in the status column. the result should be something like this:
\1
Also, once they start back at the beginning of the list and they change the account status from "payment pending" to "paid" to overwrite the previous entry. Sorry, I know it is pretty complicated and I am still searching for the solution.

Hi
Open both kinad and summary files and run the macro from kinad. If you are satisfied with the result, you can add the filepath in the macro code to summary file so that it gets updated in the shared folder
Ravi

Originally Posted by ravishankar

Hi
Open both kinad and summary files and run the macro from kinad. If you are satisfied with the result, you can add the filepath in the macro code to summary file so that it gets updated in the shared folder
Ravi

thanx, only difference is that i did not need to copy the rows that have "no contact"
i used this to copy into a 'summary' sheet

PHP Code: 

Sub cond_copy()
         Sheets("Sheet1").Select
    rowcount = Cells(Cells.Rows.Count, "q").End(xlUp).Row
    For i = 1 To rowcount
                Range("q" & i).Select
        check_value = ActiveCell
        If check_value = "paid" Or check_value = "payment plan" Or check_value = "payment pending" Then
            ActiveCell.EntireRow.Copy
            Sheets("Summary").Select
            rowcount = Cells(Cells.Rows.Count, "a").End(xlUp).Row
            Range("a" & rowcount + 1).Select
            ActiveSheet.Paste
            Sheets("Sheet1").Select
        End If
    Next
End Sub 


i will use part of your code to copy the a 'summary' sheet into the 'summary.xls' worksheet in the shared folder