Automatic extend row in workshet.
 

Yes:

Based upon your recent historical experience, estimate the number of records
generated on a typical day.

Multiply that by the number of days for which you are preparing.

Finally add a 17% margin.
--
Gary's Student


"Rao Ratan Singh" wrote:

Sir/Mam,
I m using worksheet for my Sales entry, which uncertain that how many row it
will need for the coming days.

Is there any formula.