populate multiple worksheets in one workbook
 

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?

populate multiple worksheets in one workbook
 

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?

populate multiple worksheets in one workbook
 

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?

populate multiple worksheets in one workbook
 

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?