Extending formulas with gaps in reference

[Guest]

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

 

[Jim Rech]

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
|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

 

[Guest]

Thanks for your reply Jim,
That would work if I were completing the entire process, but I am setting
this up as a template for my co-workers. They can handle copying the web
page and pasting it into the identified sheet, but they will not be able to
do what you are suggesting. If worse comes to worse I suppose I could create
a button to perform that function, but in the meantime I'm still looking for
a direct solution.
thanks again.
ed