Hello everyone,
I have some difficulty in finding a solution to have a VBA that copy and paste as values to last empty row of specific range.
I tried this code, but did not work.
I attach sample file for more clarification.
Please Login or Register to view this content.
Thank you so much in advance.
Please Login or Register to view this content.
Last edited by AB33; 08-15-2018 at 05:56 AM.
Hello chergian,
Please upload a more complete sample Workbook, showing us where to copy what from where, and paste to where.
Regards.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
@ AB33,
Don't do this to me. It is hard enough being stupid and absent minded.
How are you keeping buddy?
Regards.
Hi Winon,
Fine mate!
I also feel the same. As I am not as regular as I was once, I beginning to forget VBA.
@AB33, @Winon
Thank you so much for the reply....
I tried AB33 code but it copy to Item C instead to Item A. I attach again the file with more specific information.
Once again thank you for the help.
Hi ! Try this !
As a beginner starter :
PHP Code:Sub Demo1()
Dim V, R&, W
With Sheet1
V = .Range("B1", .Cells(.Rows.Count, 2).End(xlUp)).Value2
For R = 2 To .Cells(9).End(xlDown).Row
W = Application.Match(.Cells(R, 8).Value2, V, 0)
If IsNumeric(W) Then If .Cells(W + 11, 4).Value2 = "" Then _
.Cells(R, 9).Copy .Cells(Application.Max(.Cells(W + 11, 4).End(xlUp)(2).Row, W), 4)
Next
End With
End Sub
Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !
Last edited by Marc L; 08-15-2018 at 11:52 PM. Reason: optimization …
@Marc L
Thank you so much... it works, however it paste the link instead of the values, that's why it resulted to #REF.
How to tweak this code to make it paste as values?
Use this line
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
@YasserKhalil
It works! thank you much... There is one problem when i put the code in my original worksheet, there is an Error "Variable not define"..
Im so sorry i did make the same format of the sample file based on original.
Attach is the file with original format.
Hoping my mistakes is forgivable.
You have changed the structure in the new workbook ..
As for the Sheet1 it is the code name of the worksheet and in your new file it is Sheet45 or you can use it like that
Please Login or Register to view this content.
Originally Posted by chergian
As there is no link in your post #6 attachment …
@Marc L and @YasserKhalil
Thank you so so much... it works perfectly now!!... @Marc L, im so sorry i wasn't able to make a link on the data of the attachment, 'coz in my thought, it will make an error of my attachment. That is why i put a description of my attachment that the data was link to other sheet or worksheets...
Once again thank you so much! this thread was solved!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks