Hi all,

How can a create a sheet2 that will be populated by copied data from
sheet1? Sheet1 will contain all data and new records will be entered
manually into this sheet. Whenever sheet2 is opened, it's populated by
copying each row in sheet1 that its cell F (for example) matches a
pattern.

Pseudocode:

select a row
while true
set cell F as activecell
if text in activecell == "School"
then
copy current row's record to clipboard
append record in clipboard to sheet2
go to next next row in sheet1
else
go to next row in sheet1
endif
repeat loop


Any help will be appreciated. Thanks in advance

~j2dizzo


--
j2dizzo
------------------------------------------------------------------------
j2dizzo's Profile: http://www.excelforum.com/member.php...o&userid=22016
View this thread: http://www.excelforum.com/showthread...hreadid=489770