vba if column B contains text then copy that cell and Adjacent Cell to bottom row column

**steve2471** · 05-01-2019, 09:52 AM

Hello,

I am trying to cut calls that contain information in column B and also copy the adjacent cell C and insert them to the bottom roll in cells A and B.

Would someone have a VBA code for this?

Also how do you attach a file on this forum?

Before
Stephen yes 58
Stephen 48
Stephen no 15
Stephen 51
Stephen 2
Stephen why 564
Stephen 454
Stephen 15
Stephen yes 12
Stephen 748
Stephen 11
Stephen may 21
Stephen 2
Stephen 5
Stephen no 5
Stephen 5

After
Stephen 58
Stephen 48
Stephen 15
Stephen 51
Stephen 2
Stephen 564
Stephen 454
Stephen 15
Stephen 12
Stephen 748
Stephen 11
Stephen 21
Stephen 2
Stephen 5
Stephen 5
Stephen 5
yes 58
no 15
why 564
yes 12
may 21
no 5

**bakerman2** · 05-01-2019, 10:10 AM

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**sintek** · 05-01-2019, 01:22 PM

Perhaps...

Please Login or Register  to view this content.

**steve2471** · 05-03-2019, 02:27 AM

Thank you this work great.

**sintek** · 05-03-2019, 03:11 AM

Pleasure...If this answers your initial query then please mark thread as solved...

vba if column B contains text then copy that cell and Adjacent Cell to bottom row column

LinkBack

Thread Tools

Rate This Thread

Display

vba if column B contains text then copy that cell and Adjacent Cell to bottom row column

Re: vba if column B contains text then copy that cell and Adjacent Cell to bottom row colu

Re: vba if column B contains text then copy that cell and Adjacent Cell to bottom row colu

Re: vba if column B contains text then copy that cell and Adjacent Cell to bottom row colu

Re: vba if column B contains text then copy that cell and Adjacent Cell to bottom row colu

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Find matching value in one column to copy adjacent cell on same row

[SOLVED] Copy cell down to bottom of adjacent variable list

[SOLVED] If number in Column A matches number in column B - Copy B cell and adjacent cells ?

Need loop to copy value on a column until cell adjacent to it is blank.

[SOLVED] Macro to find the empty cell in a column and copy a adjacent row to another column.

If a cell in column contains a text string, need to extract the data from adjacent cell.

To copy values in a column relevant to text in an adjacent column?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions