Ok lets say I go with keeping all my data in one huge sheet. What is the
easiest way to get all rows of data from my first sheet into my customer
quote database sheet. Right now it is just grabbing the first line, but
I sometimes enter more than one quote in the first page, so I may have
up to 20 lines. Right now in the code I have

----myAddress = "C6,B10,C10,D10,E10,F10,G10,H0,I10,J10,K10"-----

Do I have to enter each row in, so I would basically have 20times the
numbers to enter, or is there a string I could enter???

I need to go from B10:K10 to B34:K34

Thanks


--
mount_mordor
------------------------------------------------------------------------
mount_mordor's Profile: http://www.excelforum.com/member.php...o&userid=26879
View this thread: http://www.excelforum.com/showthread...hreadid=401134