|Everything HP200LX: Knowledge, Products, Service|
COMBINING DATA FROM SEPARATE 1-2-3 FILES INTO A THIRD 95LX 100LX
Lotus 1-2-3's File Combine feature lets you automatically add data from one or more separate spreadsheets into the one you're working on -- without having to manually re-enter the data.
Let's say your a sales manager and have three spreadsheets: EAST.WK1 has sales figures for the East Coast, WEST.WK1 has the West Coast figures, and USA.WK1 will have the total national figures.
To walk through this tip, you'll need to create the three .WK1 files in the same format. Each is a two column spreadsheet with the names of three products in cells A5 to A7 and the corresponding sales figures in cells B5 to B7. Use the following data for the spreadsheets:
EAST.WK1: WIDGETS 3,456
WEST.WK1: WIDGETS 5,890
USA.WK1: Enter WIDGETS, THINGS, and NICKS in A5-A7. Leave B5-B7 blank for now.)
Go to Cell B5 in USA.WK1 and add in the sales figures from EAST.WK1 as follows.
If you followed the steps correctly, the sales figure in USA.WK1 should be the sum of the sales figures in EAST.WK1 and WEST.WK1.
Editor, The HP Palmtop Paper
Copyright © 2010 Thaddeus Computing Inc