| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
best way to do it? copy from a sheet to other sheet
hi
source cells a C4, C10, C16,..., C352 all of them have fixed 6 steps away from each other. Now I want to copy them in another sheet within same file but the copy values sit in: A1, A2, A3, .... Best Darius |
|
#2
|
|||
|
|||
|
Try =INDIRECT("Sheet1!C"&(ROW()-1)*6+4)
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Darius" wrote in message ... hi source cells a C4, C10, C16,..., C352 all of them have fixed 6 steps away from each other. Now I want to copy them in another sheet within same file but the copy values sit in: A1, A2, A3, .... Best Darius |
|
#3
|
|||
|
|||
|
Thanks it works but start from C22 instead of C4, how to make it start from C4?
Best "Bernard Liengme" wrote: Try =INDIRECT("Sheet1!C"&(ROW()-1)*6+4) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Darius" wrote in message ... hi source cells a C4, C10, C16,..., C352 all of them have fixed 6 steps away from each other. Now I want to copy them in another sheet within same file but the copy values sit in: A1, A2, A3, .... Best Darius |
|
#4
|
|||
|
|||
|
Thanks it works now, was because in second sheet I started from row 4,
chanign 1 to 4 sloved the problem Thanks "Darius" wrote: hi source cells a C4, C10, C16,..., C352 all of them have fixed 6 steps away from each other. Now I want to copy them in another sheet within same file but the copy values sit in: A1, A2, A3, .... Best Darius |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Sheet and move to end | Excel Discussion (Misc queries) | |||
| Copy from 1 sheet to another | Excel Discussion (Misc queries) | |||
| How do I copy Page Setups from one Sheet to Another sheet? | Excel Worksheet Functions | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
| relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Linear Mode
