I have three workbooks, A, B, and C.

A has a list of names indicating those I should move from B to C.

I am writing a macro inside A to do this. I just want to open/reference B and C, and be able to scan everything in A against everything in B, and any time I come across a match, cut the row from B and append to the end of C.

I am running into problems just getting the workbooks to be opened/referenced properly, let alone everything else

for example I am trying this to get the last row in C to use but it's giving me trouble

```
path = "C:\MyPath\"

bBath= path & "B.xls"
cPath= path & "C.xls"

Set bBook = Application.Workbooks.Open(bPath)
Set cBook = Application.Workbooks.Open(cPath)

k = 1
While cBook.Sheets("SomeSheetName").Row(k, 1) <> ""
    k = k + 1
Wend

```