Thread: Automatically fill info from another spreadsheet?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Automatically fill info from another spreadsheet?
=Sheet1!A1

"Christine" wrote:

I have two seperate spreadsheets, one inventory (A) and one for customer
orders (B). Is it possible to enter the name of product in spreadsheet (B)
and have the next cell automatically fill in product number from spreadsheet
(A)?
Reply With QuoteReply With Quote