MACRO: Add formula's across row if criteria is met

Giganews Newsgroups
Subject: MACRO: Add formula's across row if criteria is met
Posted by:  SteveT
Date: Wed, 29 Aug 2007

Hello !,

In effort to reduce size of lookup, dependent workbook, I would like to have
formulas placed across columns A:F in dependent worksheet if 2 cell values
criterias are met.

A1 = find first row in 'Source' worksheet where criteria value is met column A
B1 = find last row in 'Source' worksheet where value is present column F

column A 'Source' worksheet = date value
column F 'Source' worksheet = final update for row.

Trying to keep question simple, hopefully not to simple.

thanks for any help,
Steven / Dallas

Replies