Copy data to other sheet on basis of condition

[valkrish]

I have 3 sheets in a workbook named Master, Group1, Group2
In master sheet data is spread from column A to column I
I need to copy data from master sheet to Group1 and Group2 on basis of following conditions

i)All such rows in which the value in cells in column H and I is False,
Data to be copied to sheet Group1. Data in column H and I is to be excluded while copying the data, only data in columns A to G is to be copied to sheet Group1, and in sheet Group1 the data is to be placed in Column A to Column G.

ii)All such rows in which the value in cells in column H and I is
a) True and False respectively
b)True and True respectively
Data to be copied to sheet Group2. Data in column H and I is to be excluded while copying the data, only data in columns A to G is to be copied to sheet Group2, and in sheet Group2 the data is to be placed in Column A to Column G.
iii)All such rows in which the value in cells in column H and I is False and True respectively
Data from column A to G is to be copied to column P to column V in sheet Group 2.

[maniacb]

For item ii, do you want both a and b? Where do you want to place the b data below the a data?

[maniacb]

I assumed you wanted the a data below the b data.

Please Login or Register  to view this content.

[valkrish]

Need to exclude the header row while copying.Need the code to copy data from 2nd row onwards and paste in 2nd row onwards.thanks

[maniacb]

Try it now

Please Login or Register  to view this content.

[jindon]

Try

Please Login or Register  to view this content.