Sheet Update

[RichardJ]

I have two sheets of data in same file:

Sheet 1:
AB followed by 7 coloums of data
CD followed by 7 coloums of data
EF followed by 7 coloums of data
GH followed by 7 coloums of data
IJ followed by 7 coloums of data

Each day some or all of these entries
are added followed by 7 coloums of data
for each AB or CD etc.

Sheet 2: Relates only to BC and GH entries.

If on the sheet1 BC and GH are added for any
day then I want Sheet 2 to automaticaaly capture
the whole data from sheet 1 and add BC ad GH
as two additional rows including all 7 coloums of data.
If 3 additional entries are made on any day which are not
BC and GH, then there are no added lines on sheet 2
for that day.

 

[BrianB]

Sounds like a simple Data/Filter/Autofilter will do the job in place. Or perhaps a pivot table, depending on your needs.

Whatever you do, even if using a simple formula, a new column with a formula something like :-
=IF(OR(A1="BC",A1="GH"),"Yes","No")
will separate the entries.

If you really need to transfer the entries elsewhere, a simple copy & paste of the filtered range will do it.