Auto live transfer from excel to excel

May 14, 2011 at 18:48:50
Specs: Windows XP
PREVIOUS REQUEST - http://www.computing.net/answers/office/excel-to-word/10126.html.
Assistance given by Derbyday03 and Humar

Back 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 sheet
Date 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....


See More: Auto live transfer from excel to excel

Report •


#1
May 14, 2011 at 21:25:35
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 workbook" since you can't have a "sheet in the same worksheet"

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!E2

etc.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question