but when pasted into excel the information is only in every third row.

Wouldn't one answer be to delete the empty rows between the rows of data?
You can do that by selecting the first column of data/empty rows and do an
{F5}, Special, Blanks. OK. This selects just the empty cells. Then use
Edit, Delete, Entire Rows.

--
Jim
"expect_ed" wrote in message
...
|I am cutting a report from a web page and pasting it into a sheet in excel.
| I then reference the report and perform some relatively complex formulas
in
| another sheet. The report can contain from 20 to 150 rows of onformation,
| but when pasted into excel the information is only in every third row. I
| want to replicate my formulas but when I try the replication either
|
| A. Extends for every row, or
| B. If I select multiple rows of data and then replcate it makes an exact
| copy of the formula without adjusting the references.
|
| I have used method A and simply deleted the unrequired inserted rows, but
| everytime I make a change to the formula it requires that I redo the
manual
| deletion process.
|
| Is there a way to force the replication to adjust the refences for every
| third row?
|
|
| Any suggestions greatly appreciated.
|
| thanks
| ed