Copy Cells from One Sheet to Another

[Jrub]

Hi All,

I need top copy cells which have data in them into another sheet in different locations. The following codes works for columns which are adjacent to each others:

Please Login or Register  to view this content.

BUT:

-When I include

Please Login or Register  to view this content.

**** hits the fan, as I just want to copy the "K" coloum start at row 3 to E on the new sheet???

Can anyone help me out? I attached the file below:

Help Me Please.xlsm

Basically, I'm trying to pool select data from multiple sheets into a single sheet........and it's KILLING me....

[benishiryo]

hi Jrub. if your last row is 100, this code is going to give you "K3100"

Please Login or Register  to view this content.

because it adds K3 & 100. you probably know that because your series of codes seem to have include a letter. so maybe

Please Login or Register  to view this content.

i didnt try the rest of your codes.

[Jrub]

I see the error of my ways, thanks so much- It was driving me crazy.

[Naja]

Hello Jrub,

Your codes seem interesting. Can you please explain the reason you created this macros? What do you want exactly?
Plus, can you please attach the Excel workbook with the modifications you made. If possible.

Thank you vey much