G
Guest
I have a template that collates and summaries data from three data sheets
created by our database.
Each file is saved as a job number followed by GL, L or J. For example,
General Ledger data is exported to a file called 1234GL.xls, Labour data is
exported to a file called 1234L.xls, etc. Each file has only one sheet with
the same name as the file name without the xls extension.
I have destination sheets in a Job Summary Template called "Ledger",
"Labour" and 'JobCard". Macros are triggered when the destination sheet is
updated.
Currently users are taken via a macro to the file directory and prompted to
select a data file. The entire contents of the ActiveSheet is copied to the
sheet allocated to that macro (“Ledgerâ€, “Labour†etc). Unfortunately, the
user must close the three open data sheets before continuing to the next job
summary.
Would it be possible for the user to be prompted for the job number, have
this added to the “GL, “L or “J†and the file selected for them, and the
contents of the ActiveSheet copied to the named target sheet and the data
file closed.
If the prompt is too difficult I would be happy with being able to close the
data file after the data is copied to the named target sheet.
created by our database.
Each file is saved as a job number followed by GL, L or J. For example,
General Ledger data is exported to a file called 1234GL.xls, Labour data is
exported to a file called 1234L.xls, etc. Each file has only one sheet with
the same name as the file name without the xls extension.
I have destination sheets in a Job Summary Template called "Ledger",
"Labour" and 'JobCard". Macros are triggered when the destination sheet is
updated.
Currently users are taken via a macro to the file directory and prompted to
select a data file. The entire contents of the ActiveSheet is copied to the
sheet allocated to that macro (“Ledgerâ€, “Labour†etc). Unfortunately, the
user must close the three open data sheets before continuing to the next job
summary.
Would it be possible for the user to be prompted for the job number, have
this added to the “GL, “L or “J†and the file selected for them, and the
contents of the ActiveSheet copied to the named target sheet and the data
file closed.
If the prompt is too difficult I would be happy with being able to close the
data file after the data is copied to the named target sheet.