Your welcome, some others may have some VB code if you were inclined to
have a more sophisticated solution.

cmarsh wrote:

Thanks. Just never thought to work from the top of the sheets.

"Bob I" wrote:


You could select the two applicable sheets, insert a row at the top to
push the current items down and enter data once and fill in both.

cmarsh wrote:


I have 3+ worksheets in one workbook. Can I enter a row of information in
the "All Orders" worksheet and automatically have that info populate the
"Installed" or "Pending" worksheet depending on whether there is an installed
date?