MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by MO on February 02, 2001 3:55 PM

Hello, I have a fairly large spreadsheet with lots of formulas. The formulas are exactly the same for every so many rows. I just use fill down to copy to so many different rows. Obviously as the spreadsheet gets bigger it ends up being slower. Is there a way to input a formula just once to apply to so many rows, but display results in the relevant row, that will actually speed it up.
Also the workbook is shared, and everyone inputs data in it. The formulas sometime confuse people, Is there anyway to hide them, The usual method of protecting wont work, as it shared by many people who need to input it?
Thankyou in advance for your help.

Posted by Carl B on February 05, 2001 10:27 PM

Have you considered using VBA? all the formulas would then be off the sheet but still manipulates the data, whereas you could have a small loop that calculates the data and then posts it in the Active row in a certain column.