Hi,
I have a workbook (wb) named "PM Master.xlsx". The wb contains two sheets: "PM Rollup" and "PM Template".
"PM Rollup" contains over a hundred rows and each row is a roll-up of a single project.
"PM Template" is a template sheet that has been formatted for a user to enter their detailed information for a single project.
The goal is to push out a uniquely named Project Entry file, from the "PM Template" to each project manager, and have it populated with three of the cells already populated with the correct data.
I am new to VBA, but here are the specifics on what I would like to do with VBA:
Run script from "PM Master.xlsx"
VBA script prompts for ID # (Note: this is the unique identifier I assigned to each row in the "PM Master.xlsx" file).
VBA makes a copy of the "PM Template" sheet and renames it as a new workbook using a name created by concatenating the cell values of the following columns of the row indicated from the ID entered:
----- "PM", "ID#", "Project Name"
VBA then copies the cell values of the indicated columns in that row and pastes them into specific cell locations of the newly created workbook, as follows
____ Value in "PM" gets pasted to cell C8 of the new file
____ Value in "ID#" gets pasted to cell C5 of the new file
____ Value in "Project Name" gets pasted to cell C6 of the new file.
VBA saves and closes the newly created file.
Note: It would be nice to run this as a batch as well so that I can knock out all the file creations at once. However, the critical factor is how to add a file after the batch has run; after all I don't want to overwrite existing files when I only need to create a single file. I guess the ideal would be to have both options available (Batch or Single file based on ID#). However, if I had to choose one, I would choose the single file creation version.
I searched and tried to solve this from existing knowledge captured in previous postings but there are just to many moving parts in this for a VBA novice like myself to figure this out.
Thank you in advance!
Bookmarks