I was wondering is this is possible in Excel 2000
I currently have a spreadsheet that pulls data from one sheet to the next. For example, one sheet has all data, the other one, when I type a sku in the information appears that was put in the data sheet.
What I want to do, is put a whole bunch of addresses in the data sheet, so that on the master sheet, when I type a sku in, the rest of the address shows up.
Can this be done?