Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2006

Tip: Looking for answers? Try searching our database.

Is there a way to copy every 4th cell

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Chrisinct - 07 Jul 2006 15:21 GMT
I am working with imported data and I need the information in every 4th cell
for a different worksheet.  How can I do this.
Bob Phillips - 07 Jul 2006 16:01 GMT
Ctrl-select with the mouse, then copy and paste.

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> I am working with imported data and I need the information in every 4th cell
> for a different worksheet.  How can I do this.
Domenic - 07 Jul 2006 16:04 GMT
Assuming that Sheet1, A2:A100, contains the data, try the following...

1) To return every 4th cell, starting with the first cell in the range...

C2, copied down:

=INDEX(Sheet1!$A$2:$A$100,ROWS($C$2:C2)*4-4+1)

2) To return every 4th cell, starting with the fourth cell in the
range...

C2, copied down:

=INDEX(Sheet1!$A$2:$A$100,ROWS($C$2:C2)*4)

Hope this helps!

> I am working with imported data and I need the information in every 4th cell
> for a different worksheet.  How can I do this.
Chrisinct - 07 Jul 2006 16:26 GMT
Thanks Domenic.  This worked well.  The first answer was too difficult
because I have a few thousand entries to sort through but your formula worked
well.

> Assuming that Sheet1, A2:A100, contains the data, try the following...
>
[quoted text clipped - 15 lines]
> > I am working with imported data and I need the information in every 4th cell
> > for a different worksheet.  How can I do this.
Don Guillett - 07 Jul 2006 22:03 GMT
helper column>this formula copied down>filter on result>copy
=MOD(ROW(1:1),2)=0
or adapt this

Sub SelectEveryOtherRow()
Dim rng1 As Range
Dim rng2 As Range
For Each r In Range("a1:a21")
   If r.Row Mod 2 = 1 Then
       If rng2 Is Nothing Then
           Set rng2 = rng1
       Else
           Set rng2 = Union(rng2, rng1)
       End If
       Set rng1 = r
   End If
Next
rng2.Copy Range("g1")
End Sub

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>I am working with imported data and I need the information in every 4th
>cell
> for a different worksheet.  How can I do this.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.