Re: best way to do it? copy from a sheet to other sheet

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Try =INDIRECT("Sheet1!C"&(ROW()-1)*6+4)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Darius" <Darius@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3A9424FC-9340-470D-B74E-721BEF68D263@xxxxxxxxxxxxxxxx
> hi
> source cells are:
> C4, C10, C16,..., C352
> all of them have fixed 6 steps away from each other.
> Now I want to copy them in another *** within same file but the copy
> values sit in:
> A1, A2, A3, ....
> Best
> Darius


.


Quantcast