Insert Column with vLookup formula

Hi Forum,

Once again I find myself turning to this great forum to try to find a solution to a VBA question I have. I'm wanting to insert a column onto a spreadsheet that contains a vLookup formula. Right now I have the following code, which copies select columns from one worksheet ("SiteMaster") and copies the columns to a second worksheet ("HSmSchedule"):

Please Login or Register  to view this content.

I want to add the following vLookup

Please Login or Register  to view this content.

into column B on the second worksheet ("HSmSchedule"), but I only want the formula to be copied to rows that contain values copied into column A on the second worksheet. Anybody have any ideas on how I can make this happen? Thanks!

Never mind...I simply added the vLookup to the master worksheet ("SiteMaster") then copied the values like I did with the other columns. Sorry for the wasted thread!