Harlan Grove wrote:
"Alan Beban" wrote...
...

. . . if one is willing to
rename the working range each time additions are made, or otherwise
adapt the formulas to accommodate such additions.

...

Not comfortable showing how to define dynamic ranges? Well, here's one way.

If the data range spans columns A through D beginning in row 2 and spanning
all rows in which column A is nonblank moving down from cell A2. Define Orig
referring to

=OFFSET(WorksheetNameHere!$A$2:$D$2,0,0,
MATCH(TRUE,ISBLANK(WorksheetNameHere!$A$2:$A$65536 ),0)-1,4)


So your formulas don't work if the data range starts in Cell A1?

Alan Beban