motherteresa
Board Regular
- Joined
- Nov 11, 2010
- Messages
- 81
A school I volunteer at has a number of workbooks that need to be updated. They basically need updated formulas, vlookup, etc. So, I have created a new template with all that stuff in the background. This forum has been so helpful in that work so far.
Problem is, all the data, names, etc have to be moved from the old workbooks to a new one...one for each student using the new template.
So, say we have "StudentA_old.xlsm." I need to copy certain cells of info from several pages in 3-5 sheets in that workbook into the template which will then need to be saved as something like "StudentA_new.xlsm." I just need the data input by the user to be copied and pasted, absolutely no formulas or formatting.
Is there a way to do this? Each worksheet has several pages running vertically. The cells with the info in them are in the same place on each page. Same is true for the new template.
Yikes! that looks convoluted now that I read it. Any help would be most appreciated!!
Problem is, all the data, names, etc have to be moved from the old workbooks to a new one...one for each student using the new template.
So, say we have "StudentA_old.xlsm." I need to copy certain cells of info from several pages in 3-5 sheets in that workbook into the template which will then need to be saved as something like "StudentA_new.xlsm." I just need the data input by the user to be copied and pasted, absolutely no formulas or formatting.
Is there a way to do this? Each worksheet has several pages running vertically. The cells with the info in them are in the same place on each page. Same is true for the new template.
Yikes! that looks convoluted now that I read it. Any help would be most appreciated!!
