script to copy from one workbook to another
Hi guys
Hope someone can help? I have experience with excel but not the VBA and macro side of excel. Basically I have 10 Teams each with their own excel workbook used to record daily figures. The last sheet on each workbook has their running total for the month. All I want is a new workbook that can copy the monthly table from each teams workbook into the new workbook for comparison. Does anyone know if this can be done? I was also hoping to be able to have sheets rename themselves based on data in a cell on the sheet itself? The monthly total sheets name would remain the same.
Thanks
Mark
Last edited by Gr8er1mark; 01-13-2012 at 03:35 PM.
This is easily doable. Why dont you attach a sample workbook with some dummy data so we can help you better.
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi Thank you for prompt reply. I have uploaded some example sheets of what it is I would like. There will be 10 sheets 1 for each team recording same data as Team A.xls. I would like the "Month Total" sheets for each team to be displayed on the Service Totals.xls. There will be a template sheet for each team to start a fresh for each calendar month. The first sheet on this will request the first working date of the month and will then calculate the date for all the remaining sheets and I would really like each date found in each of the sheets cells to be the name of each sheet. Hpoe this makes sense? Thanks for your help.
So ideally, you will need 1 macro that will rename each tab in each team sheet to the corresponding date, right?
And the 2nd macro will consolidate the data in the month totals tab to the service totals file. Where would these files for Team A to Team J (10 teams) be located? Would it be on a shared folder or some path where the macro can open it from?
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Yep you've got it bang on. The sheets will be in a shared network folder.
Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Don't waste our time by duplicating posts. I've locked the other post & I'll leave you to solve your own problems if you think so little of our time
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks