Quote:
Originally Posted by NoSparks
Inv_override is name of cell B17
Can you put into words what you want to happen if B17 has something in it ?
ps: go into the Auto_Open module and uncomment Application.ScreenUpdating = False
so the file will open quicker.
|
Ive fixed the comment error, unprotected the 'order' sheet, and uploaded my attachment again. Please click 'View Group Records' button (c1) repeatedly and notice how the records from the other sheet are deposited in column 'B'.
An invoice number is automatically deposited in B16. However, I have had times when I have wanted to change this. So, I manually type the correct number in B17. It is supposed to override B16.
Post and package is similar, but it works in that case.