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
Bookmarks