LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 202
Default Copy Values to another Sheet Q

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy values generated by conditional formula in one sheet to the other work sheet as values ramana Excel Worksheet Functions 1 October 5th 05 01:04 PM
copy values generated by conditional formula in one sheet to the other work sheet as values bobby Excel Discussion (Misc queries) 1 October 5th 05 12:18 PM
how to find and copy values on sheet 2, based on a list on sheet 1 evanmacnz Excel Programming 4 February 7th 05 08:33 PM
how to copy values to another sheet C. Thies Excel Programming 1 July 2nd 04 02:08 AM
How do i compare values from two sheet and copy & paste if values match? rozb Excel Programming 0 March 5th 04 12:06 AM


All times are GMT +1. The time now is 12:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"