I am having trouble with two things:
Thing 1: I have created a auto calculating inventory sheet for my business. It shows inventory cost ,Profit and quantity on hand. When you enter quanity sold it totals up sales and profit, If the Item is sold out and not avaliable anymore and I have to remove the line item.When I remove the item it subtracts from the inventory cost and profit . Is there a way to make the profit totals where it does not subtract when removing a line item

Thing 2: I am trying to build a spread sheet in the same workbook when I enter a key word in the cell it will auto copy from sheet1 all the info for the keyword into the row on the new work sheet