staticbob
Well-known Member
- Joined
- Oct 7, 2003
- Messages
- 1,079
HI,
I have 2 pages in a spreadsheet. I would like to automate copying data from one to another.
Firstly, I need some code to add to an existing button that will copy the task list from A6:Azzz (could be A6:A20 could be A6:A4544) and paste this onto a new page in A2:Azzz
I then need some code that will copy the report date and actual %ages from the progress report to this new page. This will be done weekly so evetually this new sheet will show where we were upto on each report date. This data could be pasted into the next available column, if the reports are done in date order. Sometimes these will be done retrospectively so I need to ensure that it will paste into the correct place.
Thanks in advance.
I have 2 pages in a spreadsheet. I would like to automate copying data from one to another.
Firstly, I need some code to add to an existing button that will copy the task list from A6:Azzz (could be A6:A20 could be A6:A4544) and paste this onto a new page in A2:Azzz
I then need some code that will copy the report date and actual %ages from the progress report to this new page. This will be done weekly so evetually this new sheet will show where we were upto on each report date. This data could be pasted into the next available column, if the reports are done in date order. Sometimes these will be done retrospectively so I need to ensure that it will paste into the correct place.
Thanks in advance.
Derby Uni PR.xls | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | SiteName | MarkeatonCampus-UniversiyofDerby | ||||||
2 | ProjectNumber RelatedProgrammeRevision | E32012 ConstructionProgrammeRev1st | ||||||
3 | ReportDate | Average | Actual | |||||
4 | 12/12/2003 | 5% | 11% | |||||
5 | Activity | StartDate | FinishDate | Schedule | Actual | Slippage (Days) | ||
6 | ErectHoardingtoSiteBoundary | 24/11/200308:00 | 26/11/200317:00 | 100% | 100% | 0 | ||
7 | Locate&MarkExistingServices | 24/11/200308:00 | 26/11/200317:00 | 100% | 100% | 0 | ||
8 | ErectionofExternalScaffold | 08/12/200308:00 | 19/12/200317:00 | 50% | 100% | -5 | ||
9 | SetupSiteCompound | 05/01/200408:00 | 07/01/200417:00 | 0% | 100% | -3 | ||
10 | AsbestosRemovaltoRearBays | 20/11/200308:00 | 05/12/200317:00 | 100% | 100% | 0 | ||
11 | AsbestosRemovaltoFrontBays | 08/12/200308:00 | 28/01/200417:00 | 13% | 100% | -33 | ||
12 | ExcavateforNewDrainage | 08/12/200308:00 | 09/01/200417:00 | 20% | 100% | -20 | ||
13 | LayPipes&ConnecttoExisting | 07/01/200408:00 | 14/01/200417:00 | 0% | 0% | 0 | ||
14 | Backfill&MakeGoodGround | 05/01/200408:00 | 23/01/200417:00 | 0% | 0% | 0 | ||
15 | StripOutRedundantServices&Sanitaryware | 08/12/200308:00 | 19/12/200317:00 | 50% | 100% | -5 | ||
Progress Report |