Copy & Paste
Closed
Bala
-
Updated on Nov 2, 2021 at 01:14 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Nov 3, 2021 at 08:51 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Nov 3, 2021 at 08:51 PM
3 responses
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Nov 2, 2021 at 08:01 PM
Nov 2, 2021 at 08:01 PM
Hello Bala,
Try the following code placed in a standard module and assigned to a button:-
I hope that this helps.
Cheerio,
vcoolio.
Try the following code placed in a standard module and assigned to a button:-
Sub Test()
Application.ScreenUpdating = False
With Sheet1.Range("A2", Sheet1.Range("A" & Sheet1.Rows.Count).End(xlUp))
.Copy Sheet2.[B2]
End With
Application.ScreenUpdating = True
End Sub
I hope that this helps.
Cheerio,
vcoolio.
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Nov 3, 2021 at 01:58 AM
Nov 3, 2021 at 01:58 AM
Hello Bala,
My understanding of your opening post is that you have a range in Column A of Sheet1 which you want to copy/paste to Column B of Sheet2.
The range in Column A of Sheet1 may vary in length but you want whatever the length of the Column A range to be pasted to Column B, Sheet2.
The code above does exactly that but if you have something else in mind then please upload a sample of your workbook to a file sharing site such as WeTransfer or Drop Box then post the link to your file back here.
Please ensure that your sample is an exact replica of your actual workbook showing exact inputs and expected outputs. If your data is sensitive then please use dummy data.
Cheerio,
vcoolio.
My understanding of your opening post is that you have a range in Column A of Sheet1 which you want to copy/paste to Column B of Sheet2.
The range in Column A of Sheet1 may vary in length but you want whatever the length of the Column A range to be pasted to Column B, Sheet2.
The code above does exactly that but if you have something else in mind then please upload a sample of your workbook to a file sharing site such as WeTransfer or Drop Box then post the link to your file back here.
Please ensure that your sample is an exact replica of your actual workbook showing exact inputs and expected outputs. If your data is sensitive then please use dummy data.
Cheerio,
vcoolio.
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Nov 3, 2021 at 08:51 PM
Nov 3, 2021 at 08:51 PM
Hello Bala,
I don't quite follow your second request so it would be easier for us to understand what you are doing if you upload a sample of your workbook as per my post #3.
Thank you Bala.
Cheerio,
vcoolio.
I don't quite follow your second request so it would be easier for us to understand what you are doing if you upload a sample of your workbook as per my post #3.
Thank you Bala.
Cheerio,
vcoolio.
Nov 3, 2021 at 01:32 AM
Thanks for your support.
we need to past sheet2 end row.because Sheet1 have 5 cells only copied and paste same value to match sheet2 "A".