Jeremy;215789 Wrote:
I have a spreadsheet with 2 work books that I am trying to carry the
data
from sheet 2 to sheet 1. Below is an example. This needs to be
automated
because there are about 200 rows.
Thanks you
Sheet 2
A
1
2
3
4
5 Frank
6
7
8
9
10 Bob
11
12
13
14
15 Sam
16
17
18
19
20 Henry
Sheet 1 would look like with formula
A
1 Frank
2 Bob
3 Sam
4 Henry
If the data is always every 5 rows in sheet2 and you start in A1 on
sheet1 enter in A1
Code:
--------------------
=indirect("sheet2!"&"A"&row()*5)
--------------------
and pull down as needed
--
Pecoflyer
Cheers -
*'Membership is free' (
http://www.thecodecage.com)* & allows file
upload -faster and better answers
*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile:
http://www.thecodecage.com/forumz/member.php?userid=14
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=59280