Use the control Worksheet_Change. See related links for a sample macro that will trigger a macro when the cell changes. Modify, as needed, to fit your specific situation.
how to create a excel sheet
Pfa the excel sheet
There is no automatic forumla to copy and paste in excel, unless you write a custom macro. You could use a formula in sheet1 to show the value of a cell on sheet1, like this: In sheet1 put =sheet1!A1
Are you talking about No. of rows in a Excel sheet? If Yes then you can see it yourself by following command: Ctrl+Down Arrow - display total no. of rows. Ctrl+Forward Arrow - display total no. of columns.
A new excel document. In Microsoft excel there is a new page button like in word. Click that to get a new excel sheet. It is effectively a page in excel.
Yes. In Excel, a spreadsheet is called a worksheet.
Draw a button on your sheet, by going to the View menu and picking Toobars and then the Forms toolbar and drawing your button. It will immediately ask you to connect a macro to it and then you can choose your macro. Then when the button is clicked the macro will run.
Add a sheet
They are the same thing, excel is Microsoft's spreadsheet programme.
Select the sheet.
Calculating DSCR in Excel sheet