View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default 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?