Using .Value property instead of copy paste method to transfer values from one row to next blank row

[anbhavane]

Hello friends..

I want to use Range("Sheet1").value property instead of copy paste method in VBA to transfer values from one complete row to next blank row below. can someone please help in coding.
My range is from (A1:J1)

Regards..

 

[anbhavane]

So are you now saying you want the script to transfer A1 to J1 and A3 to J3
Every time you run the script.
And is this all or do you have more?

Thank you for your reply.. @Fluff has provided the solution I wanted.

 

[Fluff]

Glad to help & thanks for the feedback.

 

[My Aswer Is This]

Thank you for your reply.. @Fluff has provided the solution I wanted.

I must be sleeping or something. Fluff script works with two different sheets.
From Sheet1 to Sheet2
I never saw that request in your original post.

 

[anbhavane]

I must be sleeping or something. Fluff script works with two different sheets.
From Sheet1 to Sheet2
I never saw that request in your original post.

I have changed the sheets as per my requirement. I had an initial idea of the code but was not able to put values serially in rows below.. Fluff's code matched my requirements and I just changed the sheet's name.

 

[anbhavane]

Hello all.. In continuation to this.. I have created a table and want to copy the values from range to table, but the values are getting copied to cells below table. request you to kindly help..
btw I am using following code.

ThisWorkbook.Worksheets("Data").Range("AC" & Rows.Count).End(xlUp).Offset(1).Resize(, 324).Value = ThisWorkbook.Worksheets("Data").Range("AC3:MN3").Value

 

[My Aswer Is This]

Hello all.. In continuation to this.. I have created a table and want to copy the values from range to table, but the values are getting copied to cells below table. request you to kindly help..
btw I am using following code.

ThisWorkbook.Worksheets("Data").Range("AC" & Rows.Count).End(xlUp).Offset(1).Resize(, 324).Value = ThisWorkbook.Worksheets("Data").Range("AC3:MN3").Value

I would think you might be best to make a new posting. This thread is nearly 6 months old.