copying a row that meets certain criteria to another worksheet.

**jjin** · 02-08-2013, 01:09 AM

Hi guys,

Somehow I cannot figure out how to copy a cell that contains type 'BB' in column X, to a table in sheet 1.

Please see attached the sample excel file below.

CHeers,

**jraj1106** · 02-08-2013, 01:19 AM

Hi

Try this:

Excel sample file.xlsm

**jjin** · 02-08-2013, 02:56 AM

Hi jarj1106,

Can we make it automated? instead of using a command button?
Say, if the cell value chagnes to BB or else, the table in sheet 1 automatially updates the chagnes?? without manually clicking the button?

Cheers,

**SDCh** · 02-08-2013, 03:20 AM

Change "Private Sub CommandButton1_Click()" to "Worksheet_SelectionChange(ByVal Target As Range)"

But you will need to modify it, because if sheet1("type").value change from i.e "BB" to "AA", it will not automatically change the result on sheet2.

add this code :

Please Login or Register  to view this content.

**jjin** · 02-08-2013, 03:54 AM

Thanks SDCH and jraj1106, I think that will do

Cheers.

copying a row that meets certain criteria to another worksheet.

LinkBack

Thread Tools

Rate This Thread

Display

copying a row that meets certain criteria to another worksheet.

Re: copying a row that meets certain criteria to another worksheet.

Re: copying a row that meets certain criteria to another worksheet.

Re: copying a row that meets certain criteria to another worksheet.

Re: copying a row that meets certain criteria to another worksheet.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions