Copying Formulas
 

Bernie,
I thought I could modify the Index and Indirect to work, but I can't. They
work fine on a new work sheet.
I should have explained further.
I am trying to move data from sheet named 'payroll entry' AI335, AI338,
AI341, etc to sheet named '28day report' H41, H42, H43, etc (AI334,AI337, AI
340 etc, holds data used for another field in the '28day report', and AI333
, AI336 and so on are used as text fields for headers for the items below
them)
Any Ideas
Thanks
Mike

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Mike,

In sheet2 A1, enter

=INDEX(Sheet1!A:A,ROW()*2-1)

and copy down as far as you need.

HTH,
Bernie
MS Excel MVP


"Michael E. Gibson" wrote in message
...
Is there a way to have copy paste skip rows when copying a formula.
Here's what I am doing
Sheet 1 has data in
A1 data
A2 blank
A3 Data

On sheet 2 I need the data from A1 to go to A1 and the data from A3 to
go to A2 etc.
In an example Sheet 2 A1 reads "=sheet1!A1" Using copy makes the next
line read "=sheet1!A2". How can I make it skip to "=sheet1!A3" in A2?

Thanks
Mike

Copying Formulas
 

Mike,

Here's how you can adapt the INDIRECT suggestion to suit ..

In sheet named: 28day report,
Put in the top/starting cell, ie in H41:
=INDIRECT("'payroll entry'!AI"&ROW(A1)*3-3+335)
Copy H41 down to return as required

The expression: ROW(A1)*3-3
will create a simple number series: 0,3,6,9... as the formula is copied down
while the "+335" is an arithmetic adjustment since the start cell in
'payroll entry' is in row 335

(The expression in H41 is left intentionally unsimplified for easier
understanding)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Michael E. Gibson" wrote in message
m...

Bernie,
I thought I could modify the Index and Indirect to work, but I can't. They
work fine on a new work sheet.
I should have explained further.
I am trying to move data from sheet named 'payroll entry' AI335, AI338,
AI341, etc to sheet named '28day report' H41, H42, H43, etc (AI334,AI337,
AI
340 etc, holds data used for another field in the '28day report', and
AI333
, AI336 and so on are used as text fields for headers for the items below
them)
Any Ideas
Thanks
Mike

Copying Formulas
 

That worked, Thanks Max,

Mike
"Max" wrote in message
...
Mike,

Here's how you can adapt the INDIRECT suggestion to suit ..

In sheet named: 28day report,
Put in the top/starting cell, ie in H41:
=INDIRECT("'payroll entry'!AI"&ROW(A1)*3-3+335)
Copy H41 down to return as required

The expression: ROW(A1)*3-3
will create a simple number series: 0,3,6,9... as the formula is copied
down
while the "+335" is an arithmetic adjustment since the start cell in
'payroll entry' is in row 335

(The expression in H41 is left intentionally unsimplified for easier
understanding)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Michael E. Gibson" wrote in message
m...

Bernie,
I thought I could modify the Index and Indirect to work, but I can't.
They
work fine on a new work sheet.
I should have explained further.
I am trying to move data from sheet named 'payroll entry' AI335, AI338,
AI341, etc to sheet named '28day report' H41, H42, H43, etc (AI334,AI337,
AI
340 etc, holds data used for another field in the '28day report', and
AI333
, AI336 and so on are used as text fields for headers for the items
below them)
Any Ideas
Thanks
Mike

Copying Formulas
 

Good to hear that, Mike ! You're welcome.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Michael E. Gibson" wrote in message
...
That worked, Thanks Max,