Skip blanks and copy data from other worksheets

**legendkiller420** · 10-20-2010, 02:07 PM

Hi All,

I have 4 worksheets named "Main","Kevin","chris" and "Alan"
Only some cells in the B column are updated in the "Kevin","Chris" and "Alan" worksheets and some are blank. Please find attached the sample file for ur refernce.

Could anyone help me by providing a macro to copy the data from B column from the 3 worksheets and paste it in the B column of "Main" excluding the blank cells . If any cell in the column B is blank in the other sheet, the "Main" worksheet also should be blank...

Thanks in advance for spending ur time in it..

**Charles** · 10-20-2010, 02:40 PM

Hi,

Copy this code to a module. It should populate the values to the "Main" worksheet.
This is based on each worksheet being formated the same.

Please Login or Register  to view this content.

**legendkiller420** · 10-21-2010, 01:43 AM

Hi Charles,

Thats Really good and it is working..I juz gave an example with the small table and the only 1 column to be worked..In fact, i need the code for the large table..I mean the column "G","H" want to be populated in the main from the rest of the book..I thank u for providing me such a valuble piece..am new to the forum..so is there anyway of marking "GOOD" or "EXCELLENT" some kinda stuff to add reputation to the contributors for providing me answer