Excel spreadsheets and templates

S

shirley

I would like to create an Excel worksheet template that I
can have populated by data in another spreadsheet.

How can I setup an Excel template to retreive data from
either another a worksheet or spreadsheet, if this is at
all possible. I am currently running Excel 2002 on WinXP.

Any assistance would be greatly appreciated.
 
E

Eric

Shirley,

Well, that's a pretty open-ended question. There are
several ways to accomplish your task. However, you should
explore the use of VLOOKUP and similar functions.

Perhaps a good place to start is Chip Pearson's website at:

cpearson.com/excel

Eric
 
Top