Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What code could I use to achieve the following:
I wish to copy the values in H25 of the activesheet, to an area of a sheet called "summarry". The area it paste-special values to depends on the Index of the original active sheet eg. If my active sheet was Index 2, then I would copy to D5 on the Summary, if the Index was 3 I would copy to D6; then D7 if Index was 4 etc My Summary sheet will be Index 1, at least thats my understanding of sheet indexes. I will have up to 53 sheets in totals (1 for each week of the year + summary sheet) Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) | |||
how to find and copy values on sheet 2, based on a list on sheet 1 | Excel Programming | |||
how to copy values to another sheet | Excel Programming | |||
How do i compare values from two sheet and copy & paste if values match? | Excel Programming |