I'm very new to macro writing in Excel .. but I need the formula for a button.
I want this button when pressed to copy the value in cell C2 to cell F2 and copy some static text (eg button name ) to cell G2
Then .. next time the button is pressed .. it does the same thing .. copies data in cell C2 but this time to cell F3 ( or whatever is the next available row in column F ) and so on .. each time the button is pressed .. thus building up a column of numbers in column F
How do I do this please
thanks
I want this button when pressed to copy the value in cell C2 to cell F2 and copy some static text (eg button name ) to cell G2
Then .. next time the button is pressed .. it does the same thing .. copies data in cell C2 but this time to cell F3 ( or whatever is the next available row in column F ) and so on .. each time the button is pressed .. thus building up a column of numbers in column F
How do I do this please
thanks