automate formula

I have data in my sheet from B6 onwards, I want a macro that if in the B column any Text or value will be there then automatically serial number should be inserted starting from 1 in A column against the B column Text or value & it will be better if in the macro I can input the range of B where...

I lend 1000 on Jan 1 '17 what I want is that if 1 year later there is an opening balance meaning that the loan is not paid off it should automatically charge a penalty of 1% of the loan and the same should be on the next year if there is still an outstanding balance, I have some ideas on how to...

Hello! I just signed up and this place looks like heaven to me right now after hours of sweating and crying over this spreadsheet. I have data for thousands of people. The people all have a name, listed in column A. Then in column B is the date at which they logged their weight on an app. In...