I am trying to get an excel page to read information from another worksheet,
but miss out every few lines. The problem arrises when I try to copy the
formula down. It does not copy correctly. I need this formula to cover over
1000 lines, so would take too lng to enter it manually. I have tried the
'paste special', 'sequence' tabs etc... but have had no luck. Any help on
this matter would be much appreciated! Thanks

Hi Fiona

You say miss out every few lines. How many lines? How often?
What is the formula you are trying to use?

--
Regards

Roger Govier


"Fiona" wrote in message
...
I am trying to get an excel page to read information from another
worksheet,
but miss out every few lines. The problem arrises when I try to copy
the
formula down. It does not copy correctly. I need this formula to
cover over
1000 lines, so would take too lng to enter it manually. I have tried
the
'paste special', 'sequence' tabs etc... but have had no luck. Any
help on
this matter would be much appreciated! Thanks

Hi Roger

I'm currently using the =sheetname!A3, then =sheetname!A8.

I want the formula to skip 5 lines each time. When I copy it doesn't
continue the formula, instead of going to A13 it goes to A6 then A11 etc....
It seems to understand what I want to do but it's continuing at the wrong
point.

I want to do this so it links to a new workbook not just a seperate sheet,
but I can't seem to link workbooks at the moment, i do = then click to the
open workbook cell I want to link it to and it doesn't do it. I'm not sure
if there is a problem with my settings?

Many thanks for your help

Fiona

"Roger Govier" wrote:

Hi Fiona

You say miss out every few lines. How many lines? How often?
What is the formula you are trying to use?

--
Regards

Roger Govier


"Fiona" wrote in message
...
I am trying to get an excel page to read information from another
worksheet,
but miss out every few lines. The problem arrises when I try to copy
the
formula down. It does not copy correctly. I need this formula to
cover over
1000 lines, so would take too lng to enter it manually. I have tried
the
'paste special', 'sequence' tabs etc... but have had no luck. Any
help on
this matter would be much appreciated! Thanks

I like to do this:

Put this in the first cell
$$$=sheetname!A3
put this in the cell under it:
$$$=sheetname!A8

Select those two cells and drag down as far as I need.

Then select the range
edit|Replace
what: $$$=
with: =
replace all

Since you're pointing at a worksheet in another workbook, you may want to open
both files and build the first formula by pointing and clicking.

Then when you're positive that it works, change the leading = to $$$= and copy
it to the second cell.

Then fix that cell's address.

And drag down.



Fiona wrote:

Hi Roger

I'm currently using the =sheetname!A3, then =sheetname!A8.

I want the formula to skip 5 lines each time. When I copy it doesn't
continue the formula, instead of going to A13 it goes to A6 then A11 etc....
It seems to understand what I want to do but it's continuing at the wrong
point.

I want to do this so it links to a new workbook not just a seperate sheet,
but I can't seem to link workbooks at the moment, i do = then click to the
open workbook cell I want to link it to and it doesn't do it. I'm not sure
if there is a problem with my settings?

Many thanks for your help

Fiona

"Roger Govier" wrote:

Hi Fiona

You say miss out every few lines. How many lines? How often?
What is the formula you are trying to use?

--
Regards

Roger Govier


"Fiona" wrote in message
...
I am trying to get an excel page to read information from another
worksheet,
but miss out every few lines. The problem arrises when I try to copy
the
formula down. It does not copy correctly. I need this formula to
cover over
1000 lines, so would take too lng to enter it manually. I have tried
the
'paste special', 'sequence' tabs etc... but have had no luck. Any
help on
this matter would be much appreciated! Thanks





--

Dave Peterson

Hi Dave, that is fantastic! That has totally solved my problem. Thanks for
you help.

"Dave Peterson" wrote:

I like to do this:

Put this in the first cell
$$$=sheetname!A3
put this in the cell under it:
$$$=sheetname!A8

Select those two cells and drag down as far as I need.

Then select the range
edit|Replace
what: $$$=
with: =
replace all

Since you're pointing at a worksheet in another workbook, you may want to open
both files and build the first formula by pointing and clicking.

Then when you're positive that it works, change the leading = to $$$= and copy
it to the second cell.

Then fix that cell's address.

And drag down.



Fiona wrote:

Hi Roger

I'm currently using the =sheetname!A3, then =sheetname!A8.

I want the formula to skip 5 lines each time. When I copy it doesn't
continue the formula, instead of going to A13 it goes to A6 then A11 etc....
It seems to understand what I want to do but it's continuing at the wrong
point.

I want to do this so it links to a new workbook not just a seperate sheet,
but I can't seem to link workbooks at the moment, i do = then click to the
open workbook cell I want to link it to and it doesn't do it. I'm not sure
if there is a problem with my settings?

Many thanks for your help

Fiona

"Roger Govier" wrote:

Hi Fiona

You say miss out every few lines. How many lines? How often?
What is the formula you are trying to use?

--
Regards

Roger Govier


"Fiona" wrote in message
...
I am trying to get an excel page to read information from another
worksheet,
but miss out every few lines. The problem arrises when I try to copy
the
formula down. It does not copy correctly. I need this formula to
cover over
1000 lines, so would take too lng to enter it manually. I have tried
the
'paste special', 'sequence' tabs etc... but have had no luck. Any
help on
this matter would be much appreciated! Thanks





--

Dave Peterson