Combine Data from different workbooks

**zplugger** · 04-20-2009, 02:31 PM

Let me know if you want to write the details straight to a master journal , yes if this can be done. Can you write too a workbooks that is closed? Will I be able too do the same with my 2 day form. All I need is the info that is on page 4

**zplugger** · 04-20-2009, 03:15 PM

one other thing, could I merge my oneday into my twoday for one book?

**royUK** · 04-21-2009, 03:28 AM

Originally Posted by zplugger

one other thing, could I merge my oneday into my twoday for one book?

Try this updated book, I have changed the code & design. The invoice body is now populated using Data validation. You can add to the product list & it will be inluded automatically in the drop down.

**zplugger** · 04-21-2009, 03:20 PM

Thanks royUK I will input it into my form now, its nice too have help from a expert.

**zplugger** · 04-21-2009, 03:49 PM

This layout is better than nice royUK, here is a dumb question how did you make the list box in the rows. I want too change my hole invoice now LOL. Just not sure how too do the list box?