R
Rick Sanderson
Hi,
I have a delivery note generating workbook 'order input', data is entered
into sheet1 and a macro asigns a job number, prints a note and puts all the
data into a list in sheet2.
So sheet 2 contains details of all work done.
Then i have an invoice generating workbook which has a bunch of vlookups so
that the job number is entered into col b then the other cols pull the
appropriate data from 'order input'.
If order input is running and then invoice is opened no problem, however if
invoice is opened alone when it asks to link it takes minutes before being
ready to use.
As i hope to eventually have these two running on separate computers over a
LAN it will become a problem.
What is the best solution to this?
Many thanks,
Rick
PS also when the vlookups find an empty cell they return 0, ive managed to
stop them returning REF by IF A4="","",.....
Any ideas?
I have a delivery note generating workbook 'order input', data is entered
into sheet1 and a macro asigns a job number, prints a note and puts all the
data into a list in sheet2.
So sheet 2 contains details of all work done.
Then i have an invoice generating workbook which has a bunch of vlookups so
that the job number is entered into col b then the other cols pull the
appropriate data from 'order input'.
If order input is running and then invoice is opened no problem, however if
invoice is opened alone when it asks to link it takes minutes before being
ready to use.
As i hope to eventually have these two running on separate computers over a
LAN it will become a problem.
What is the best solution to this?
Many thanks,
Rick
PS also when the vlookups find an empty cell they return 0, ive managed to
stop them returning REF by IF A4="","",.....
Any ideas?