How to Transfer Data To Table and Fill in Invoice ?

[krunal123]

WE NEED DATA TRANSFER TO TABLE AND EASY DATA ENTRY ........... SO I WAS FAILLED...
I Don't know how to write vba coding As per my Question

DATA Range : J7:MJ
Table Range : C7:C24

 

[Anthony47]

I could give you 3 lines of code that do the job, but my suggestion is that you record your own macro while:
-start recording the macro
-select the input area (G7:M7?) and Copy its content
-select the first free line in column C
-execute paste-special /Values only
-press the Esc key
-select G7
-stop recording the macro
Then if publish the code we will make the modification to fill not that specific row but "the first available"

To learn how recording a macro: Quick start: Create a macro - Microsoft Support

 

[krunal123]

I could give you 3 lines of code that do the job, but my suggestion is that you record your own macro while:
-start recording the macro
-select the input area (G7:M7?) and Copy its content
-select the first free line in column C
-execute paste-special /Values only
-press the Esc key
-select G7
-stop recording the macro
Then if publish the code we will make the modification to fill not that specific row but "the first available"

To learn how recording a macro: Quick start: Create a macro - Microsoft Support

sir i was also try but not working properly, copy paste after going to next row ............ so this code is not working

 

[Anthony47]

Ok, you are not interested in learning.
So try

Sub LazyMan()
Range("C25").End(xlUp).Offset(1, 9).Resize(1, 4).Value = Range("J7:M7").Value
End Sub

Link it to your button

 

[krunal123]

Ok, you are not interested in learning.
So try

Sub LazyMan()
Range("C25").End(xlUp).Offset(1, 9).Resize(1, 4).Value = Range("J7:M7").Value
End Sub

Link it to your button

Thanks for the Big help....

 

[Anthony47]

Thank you for the feedback (but next time believe me and follow my suggestions, you'll learn more than by copying a ready-made macro )