Code to extract a row based on cell value in another table and paste that row elsewhere

**ZeDoctor** · 01-17-2020, 12:30 PM

Sorry for the longwinded title, So I've got say a table with country names all down column A and values in columns B-H. I want to to scan column A of Table2 to see if any country exists in table2 and table1 and if it does, cut that row A-H from table1 and paste in above table1.

Hope that makes sense

Cheers Guys,

Daryl

**Pepe Le Mokko** · 01-18-2020, 03:23 AM

Administrative note

Welcome to the forum

missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

Code to extract a row based on cell value in another table and paste that row elsewhere

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Code to extract a row based on cell value in another table and paste that row elsewhere

Re: Code to extract a row based on cell value in another table and paste that row elsewher

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Excel VBA Code adapt paste location based on variable in reference cell

[SOLVED] VB Code to copy and paste range to certain sheet based on cell Value

Code to take data from one workbook and paste in another based on cell information

[SOLVED] VBA code to copy/paste rows conditionally based on cell value in column

extract data based on four criteria in excel sheet or VBA code to extract

VBA code to copy and paste range based on separate cell value

Extract text string from cell based on conditions and paste results in another cell.

Bookmarks

Bookmarks

Posting Permissions