[Solved] Macro Help with Calc
Posted: Sun Aug 31, 2008 8:31 am
Hi there I have been working on a Room booking system for about 2 years now. as I am running a commune. http://www.eagledale.co.za
I am looking for a way to automate some of the tasks I am doing.
For this example I will use 2 sheets
sheet1 =Input
sheet2=data store.
I want to use A1 on my input sheet to input a Name.. ok thats easy now here is the trick.
I want a button that takes the name from A1 in the input sheet.. goes to by data store sheet.. makes a new row at the top and paste the name there.. and then go back to my Input sheet and clear A1.
I know it must be possible.. But what would I search for?
Thank you.
Title edited to remove All Caps by Bhikkhu Pesala (moderator).
I am looking for a way to automate some of the tasks I am doing.
For this example I will use 2 sheets
sheet1 =Input
sheet2=data store.
I want to use A1 on my input sheet to input a Name.. ok thats easy now here is the trick.
I want a button that takes the name from A1 in the input sheet.. goes to by data store sheet.. makes a new row at the top and paste the name there.. and then go back to my Input sheet and clear A1.
I know it must be possible.. But what would I search for?
Thank you.
Title edited to remove All Caps by Bhikkhu Pesala (moderator).