Leave A1 blank ..
means just that, not to enter anything into A1

.. not 100% sure what I'm doing with B2... etc

Why not take a look at this sample file which shows you
how the earlier set-up should look like, and working fabulously:

http://www.freefilehosting.net/download/3hg3d
Order Lines to new sheet.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"MB_HCAthleticTrainer" wrote:
Thanks for the response. I tried to follow what you did, but I must've
goofed somewhere. I copied that formula into sheet 2 A2. Do I leave the row
part blank or should I select something for that? Also, I'm not 100% sure
what I'm doing with B2. You said to copy B2 to I2 and I dont know why/where
I would do that. Are you saying to take the information from sheet1 and copy
it into sheet2 starting in B2? I tried that and it didn't work, but again,
I'm sure I've missed something.