so each time i add a set of items to my excel logs for individual consignors my repeat formula goes from the line i am on to 25-30 rows ahead when i only want my formula to take the next 10-15 rows into account. how do i limit the number of rows when i am cutting and pasting my formulas!? thanks!