Vba

[Ransick]

I have this table...

And i want to include a macro when click the "SAVE" buttom to do the following:

• Select the text in (E8:S8);
• Cut the VALUES only;
• Paste it in (E10:S10);

As E8:S8 is some kind of input line, next time that want to save the information, the macro shall past the input in the next available line, which it is (E11:S11) and so on...

Can some you guys help me out?

 

[mrhstn]

Did you try powering up the macro recorder to see what it gave you?

 

[Ransick]

Yes.
The paste special, as i just want to cut the values and not all the information, it is not working... and i can not do the exercise of saving it to the next available line.

 

[Fluff]

How about

Sub CopyValues()
   Range("E" & Rows.Count).End(xlUp).Offset(1).Resize(, 15).Value = Range("E8:S8").Value
   Range("E8:S8").SpecialCells(xlConstants).ClearContents
End Sub