Thank you very much! I have viewed and tried several different videos and this is the one that works for my project. Very well presented, easy to follow and excellent subject knowledge
Great video. I was wondering if you have another video that would help hard code specific cell in multiple sheets. I am trying to hard code prior month numbers while leaving the formula for future months (keeping historical numbers). Thanks
How can I assign values that includes the formats like if it is bold. For example cells(1,2).value=cells(1,1).value but it must include the bold format from cells(1,1).
Hi, can you please explain how we can change the range to select cells A1:H1 and down to the last row (so when there are new rows of data added these aret's excluded)? Thanks :)
First of all thanks a lot for this, Second I got a question: I wrote this code and it keeps giving me an error that the size of the copy area and the paste area are not the same. but if I just use the copy-paste method, it works perfectly. could you pls help me out. Sub copy() eRow = Sheet5.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row Sheet4.Range("a4", "d23").copy Sheet5.Cells(eRow, 1).PasteSpecial (xlPasteValues) End Sub
Thank you very much! I have viewed and tried several different videos and this is the one that works for my project. Very well presented, easy to follow and excellent subject knowledge
Great video. I was wondering if you have another video that would help hard code specific cell in multiple sheets. I am trying to hard code prior month numbers while leaving the formula for future months (keeping historical numbers). Thanks
this was a life saviour :") THANK YOU SO MUCH
Thank you so much for this video...!
How can I assign values that includes the formats like if it is bold.
For example cells(1,2).value=cells(1,1).value but it must include the bold format from cells(1,1).
thank you
I want to paste the value in the cell I clicked on, not cell A15, how do I code it?
Sir kindly let me know how i paste special multiple times at constant interval of time
Thank you, really help me
thanks this is very useful
Hi, can you please explain how we can change the range to select cells A1:H1 and down to the last row (so when there are new rows of data added these aret's excluded)? Thanks :)
Hi, create a Dynamic List and use the name that you have assigned to you Dynamic List as the Range.
First of all thanks a lot for this, Second I got a question: I wrote this code and it keeps giving me an error that the size of the copy area and the paste area are not the same.
but if I just use the copy-paste method, it works perfectly. could you pls help me out.
Sub copy()
eRow = Sheet5.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
Sheet4.Range("a4", "d23").copy
Sheet5.Cells(eRow, 1).PasteSpecial (xlPasteValues)
End Sub
Because u have merged cell, it won't work in merged cell
Thanks ... Thanks.
Presumably the second macro will not give you the number formatting unless you had already applied those by the earlier Copy and Paste Values macro.