Copying from one workbook to another

[Dennis T. Holm]

Hey

I have a problem... I've got an assignment to make something stupid in VBA
and never tried VBA before so im a beginner at this....

MY problem:

Im searchin through a workbook with only one worksheet. LIKE THIS:

With Worksheets(filename).Range("A1")
For i = 1 To 500
If Left(.Offset(i, 0), level) = level Then

**** THIS is where i want to copy the stuff i just found to
match into a new workbook and/or worksheet until i=500 and save it to a new
file BUT HOW****

End If
Next
End With

It's probably a simple problem, but still i hope somebody can help me with a
simple answer ....


Thanks in advance ..

Dennis

 

[Shauna Kelly]

Hi Dennis

This is a newsgroup for using VBA with Word. I suggest you ask your
questions in one of the Excel newsgroups.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word