Hi,

I'd like to create a macro which does the following:

Copy cell value from one sheet to another when the criteria are met. These values can only be placed in specifiec areas in the new sheet and can nog be larger then a given amount. Or rather:

Sheet1:
row 1: #: 800 Criteria:x time: 2
row 1: #: 801 Criteria:x time: 8
row 1: #: 802 Criteria:x time: 2

sheet2: has to contain the following
cell 1(A1): 800
cell 2(A2): 802
Cell 3(B1): 801

However I can not even copy data from one sheet to another with the given cirteria....