Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a marco to update my spreadsheet.
My problem is that i am currently manually updating my spreadsheet when
i recieve a payment from student in my class. I am looking for a macro that i can assign to a button which will update the payment coloum with a fixed amount. The marco needs to find the coloum of interest, which is fixed in my spreadsheet, find the next free cell in the coloum and input the value (cost of a lesson) into that cell. It would also be useful to have a similar Marco that allows me to enter data recieved from a input box, into the next free cell in a deffind coloum. Hope you can help Cheers Glynn |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a marco to update my spreadsheet.
Range("A1").End(xlDown).Offset(1,0).Value = amt
change column A and amt to suit. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message s.com... My problem is that i am currently manually updating my spreadsheet when i recieve a payment from student in my class. I am looking for a macro that i can assign to a button which will update the payment coloum with a fixed amount. The marco needs to find the coloum of interest, which is fixed in my spreadsheet, find the next free cell in the coloum and input the value (cost of a lesson) into that cell. It would also be useful to have a similar Marco that allows me to enter data recieved from a input box, into the next free cell in a deffind coloum. Hope you can help Cheers Glynn |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a marco to update my spreadsheet.
Thank you very much, worked like a charm
Cheers Glynn Bob Phillips wrote: Range("A1").End(xlDown).Offset(1,0).Value = amt change column A and amt to suit. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message s.com... My problem is that i am currently manually updating my spreadsheet when i recieve a payment from student in my class. I am looking for a macro that i can assign to a button which will update the payment coloum with a fixed amount. The marco needs to find the coloum of interest, which is fixed in my spreadsheet, find the next free cell in the coloum and input the value (cost of a lesson) into that cell. It would also be useful to have a similar Marco that allows me to enter data recieved from a input box, into the next free cell in a deffind coloum. Hope you can help Cheers Glynn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic update of spreadsheet & automatic update between workboo | Excel Worksheet Functions | |||
Spreadsheet Update | Excel Discussion (Misc queries) | |||
Automatically update spreadsheet from another spreadsheet | Excel Worksheet Functions | |||
Stop marco allert and update link allert when opening spreadsheet | Excel Programming | |||
spreadsheet do not update | Excel Programming |