Filling the blank cells based on a criteria

[banerg]

I have a data set with 50,000+ rows.

In col 1, I have zip codes and in col 2 I have B_Codes, in col 3 there is mem_info. For Each given zip and B_code, there are multiple values of mem_info. I want to use pivot table to analyze mem_info using zip & B_code. But the problem is: Zip code value and B_code value are only in the first row.
Eg:
Zip 1 B_Code 1 Mem_info 1a
blank blank Mem_info 1b
blank blank Mem_info 1c
blank blank Mem_info 1d

Zip 2 B_Code 2 Mem_info 2a
blank blank Mem_info 2b
blank blank Mem_info 2b


I want to copy that B_code value to all the rows in the given Zip for the given Mem_info.

I was trying using VBA's xldown function, but due to blankcells in the Zip & B_Code column, I was not able to select the entire column.

I would appreciate your help very much. I am very new to programming. Also, how do you post a sample of your data in this board ( I wanted to post that to facilitate my question). Thanks.

 

[Von Pookie]

Also, how do you post a sample of your data in this board ( I wanted to post that to facilitate my question). Thanks.

Located at the top of every page of the forum:
http://www.mrexcel.com/board2/viewtopic.php?t=92622

 

[banerg]

Thx so much, but the other part of my question was my main problem. Thx anyways.