Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prompt for file name and paste contents of active sheet
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. -- Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and paste contents of one sheet into another | Excel Programming | |||
Macro to paste in the active cell the contents of a cell from another file?? | Excel Programming | |||
Active Cell Copy And Paste Sheet to Sheet | New Users to Excel | |||
Rename active sheet to contents of specific cell | Excel Programming | |||
Copy from active sheet and paste into new sheet using info from cell in active | Excel Programming |