Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extending formulas with gaps in reference
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extending formulas with gaps in reference
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extending formulas with gaps in reference
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 "Jim Rech" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Excel - Automatically Extending Formulas | Excel Discussion (Misc queries) | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
Reference Formulas | Excel Worksheet Functions | |||
Formulas not extending in lists | Excel Discussion (Misc queries) | |||
Transpose Column With Gaps to Row With No Gaps? | Excel Discussion (Misc queries) |