Column A = list of invoice numbers
Column B-Z = information relating to each of those numbers.

Is there any way to make a new worksheet, type in some selected invoice
numbers into a column, and have the sheet populate the rest of the rown
information form the other worksheet?

I was thinking it would work something like this:

- 2 worksheets "WS1" and "WS2"
- WS1 is populated, WS2 is blank

Then on WS2:
- Type in a number in A1 in WS2
- Cells B2, C2, D2, etc. would look on WS1 for the value in A1 then
populate themselves with the value in the cell XX columns over. So WS2
cell D2 would look on WS1, find the WS2 cell A2 number on WS1, then
populate WS2 cell D2 with the information 3 cells to the right of the
cell that number was found in.


--
makega
------------------------------------------------------------------------
makega's Profile: http://www.excelforum.com/member.php...o&userid=29876
View this thread: http://www.excelforum.com/showthread...hreadid=495805