Copy values from cell in active row, paste in first empty cell in spesified column.

**Test123Test** · 02-19-2012, 02:10 PM

I tried solving this myself but my VBA knowledge is limited. I've attached a dummy workbook to explain in more detail.

NOTE: When I say "copy - paste", it's not neccessary to actually copy and paste... "x.value = x.value" will do.

Thanks guys.

**watersev** · 02-19-2012, 03:43 PM

hi Test123Test, sort of that:

Please Login or Register  to view this content.

**Test123Test** · 02-19-2012, 04:21 PM

Originally Posted by watersev

hi Test123Test, sort of that:

Please Login or Register  to view this content.

This works just as I wanted, thanks a lot!
However I figured I need to rearrange the Worksheet a bit. Is there a way to make the BM show up in BW, BQ in BX and BU in BV?

Thanks again

**watersev** · 02-19-2012, 04:35 PM

Please Login or Register  to view this content.

explanation:
.Offset(0) - active row BM cell value
.Offset(, 4) - active row BQ cell value
.Offset(, 8) - active row BU cell value

You can change their order to achive different values placement

**Test123Test** · 02-19-2012, 05:20 PM

Alright that works neatly, thanks again for all the help, it's much appreciated
Cheers

Copy values from cell in active row, paste in first empty cell in spesified column.

LinkBack

Thread Tools

Rate This Thread

Display

Copy values from cell in active row, paste in first empty cell in spesified column.

Re: Copy values from cell in active row, paste in first empty cell in spesified colum

Re: Copy values from cell in active row, paste in first empty cell in spesified colum

Re: Copy values from cell in active row, paste in first empty cell in spesified colum

Re: Copy values from cell in active row, paste in first empty cell in spesified colum

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions