The vlookup is very quick even with around 300 plus customers.

Sorry when I refered to the control box I just meant the data you need
to drive the invoice.

I agree the use of data validation list is a good idea for Customer
names etc

The Sales tab could be by month and it will still be quick. I added a
marco to mine to send the invoice if there was a valid e-mail address
which saves time.


VBA Noob

juliebythesea Wrote:
Thank you. I've never used the control box, but I looked it up and looks
like
it will do the trick. Question: Won't this become cumbersome with a
large
customer list (say 50 to 100)? I've used data validation lists which
the
control box seems similar to. What is the difference?

juliebythesea

"VBA Noob" wrote:


Hi again,

I did this simple sheet to give you a clearer idea

http://cjoint.com/?hoix2CYurg

VBA noob


--
VBA Noob

------------------------------------------------------------------------
VBA Noob's Profile:
http://www.excelforum.com/member.php...o&userid=33833
View this thread:
http://www.excelforum.com/showthread...hreadid=561345




--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=561345