Tiago Ferreira
New Member
- Joined
- Jan 12, 2013
- Messages
- 22
Hi!
i need help creating a macro that will work in this specific way:
I have a green check picture at the end off 113 rows, every time i click in the green check picture off a row i want it to copy the value off a cell in the same row and then paste it to a range off row´s, let´s say S1 to S113
So, if i click on the green check off row 1, they will copy the contents off cell A1 and paste-it in a available cell in a range off cell´s from s1 to s113.
And iff i click on the green check off row 2, they will copy the content off cell A2 and paste it in a available cell in a range off cell´s from s1 to s113. and this way on...
The objective is this, i´m making a spreadsheet for the hotel where i work, and in the hotel we have 113 room´s, i need to have control off what room´s are available for the client, and how many is not.
So the idea is to have a spreadsheet with all room´s, and when i click on green check picture off a room, automatically will copy the number off that room and paste it in a place where will be listed every room´s that is ok or not ok.
When i right click on the green check picture i choose "assign macro", then what should i put in there to make this work for me?
thank´s in advance
i need help creating a macro that will work in this specific way:
I have a green check picture at the end off 113 rows, every time i click in the green check picture off a row i want it to copy the value off a cell in the same row and then paste it to a range off row´s, let´s say S1 to S113
So, if i click on the green check off row 1, they will copy the contents off cell A1 and paste-it in a available cell in a range off cell´s from s1 to s113.
And iff i click on the green check off row 2, they will copy the content off cell A2 and paste it in a available cell in a range off cell´s from s1 to s113. and this way on...
The objective is this, i´m making a spreadsheet for the hotel where i work, and in the hotel we have 113 room´s, i need to have control off what room´s are available for the client, and how many is not.
So the idea is to have a spreadsheet with all room´s, and when i click on green check picture off a room, automatically will copy the number off that room and paste it in a place where will be listed every room´s that is ok or not ok.
When i right click on the green check picture i choose "assign macro", then what should i put in there to make this work for me?
thank´s in advance