i was helped by so many people over the last few weeks that i created an
excellent solution to what was a huge problem in our company. now i would
want to hear if my next step is possible. what i did is to create a
quotation in a workbook that automatically number each new one consecutively
with a unique number and a lot more very useful functions you guys helped me
with. so the quote was given to the customer, now he accepts it. what i
would now like to do is to, from the original quote, to instruct the job card
(a new/other work book) to open, give the job card the same number and
entries in the quote. my questions:
1. how do i instruct, from say workbook "quote1487" a new workbook, by the
name of "jobcard1487" to open
2. how do i duplicate 5 or 6 ranges of cells in "quote1487" in the new
workbook "jobcard1487".
thank you