PREVIOUS REQUEST - given by Derbyday03 and HumarBack again with the gatepass situation. Sorry didn't get back last time, this was due to major changes in the organisation/job shuffles and the vehicle entry proceedures (which coincidentally, have now change back to what it was LOL)A few changes now in our request. Word document changed to an excel document.Overview: As a vehicle arrives it is booked in on an excel sheetDate in A5 and every vehicle book in on at line i.e A7 to F7. This will be time, veh reg, etc.and the info saved.This then needs to be sent to a gate pass sheet in the same worksheet which is made in to a vehicle pass and printed off.The information needs to be placed in cells of the gate pass sheet as follows:A5 to C2, A7 to E2, B7 to C3, C7 to E6, D7 to C4, E7 to E5, F7 to C6.Once on the sheet a shortcut to print the sheet off and then clear irself ready for the next vehicle information.Is this possibe.
25+ Sample Delivery Note Templates – PDF, DOC, Excel It is highly essential for a company to ensure that the products sold are rightly delivered to the customers entitled to those goods. These are confirmation templates that ensure that a purchased product was dispatched without breaching.
![Gate pass format in excel download Gate pass format in excel download](/uploads/1/2/5/5/125503999/546349558.png)
Re: This then needs to be sent to a gate pass sheet in the same worksheet which is made in to a vehicle pass and printed off.I assume you mean 'sent to a gate pass sheet in the same work book' since you can't have a 'sheet in the same work sheet'From your description, it seems pretty straightforward.If the data entry sheet is named, for example, 'Vehicle Info', and the gate pass sheet is named, for example, 'Gate Pass', just use:=Vehicle Info!A5 in Gate Pass!C2=Vehicle Info!A7 in Gate Pass!E2etc.