A good place to start understand VBA would be to record some macros while
you use Excel to do what you describe, then look at the code. I'd suggest
that you record the process in parts to keep the code comparatively simple
and easier to understand. Try to keep the recording to one specific task
and avoid a lot of unnecessary selecting and clicking around in the
workbook. Re-record macros that don't work out. Delete or overwrite ones
that are no good. Once you understand the code associated with individual
tasks, you'll be better prepared to understand or build the whole. Record
finding True in column B of sheet 2, then stop the recording. Record copying
a row, then stop the recording. Look at the results. To find the code, from
Excel press, Alt+F8 (Or go to Tools Macro Macros), pick the macro you
recorded. Click Edit.

If you have the VBA help files installed, you can place you cursor on most
keywords in the code, press F1, and Help will open to the article pertaining
to the keyword. If you don't have the VBA help files on your computer, and
intend to do much VBA, I suggest that you get them. The are always (I think)
on the Office CD but are not usually part of the default Office
installation.

--
Bob Kilmer


"Joe" wrote in message
...
Hi Everybody:

I'm a newbie to the whole VBA thing so I was wondering if
somebody could point me towards the right direction for
this. Basically what I want to do is in a Excel
worksheet I want to check if Column B in page 2 has the
word "True" in it. if it does, I want to copy the whole
row. It doesn't seem hard but i'm not too familar w/
VBA. Could someone help me get started?