Dear Excel Professionals,
Let me ask You a question, can You please help me with how to fill Contract with last row from range with button, attaching photo and file.vba fill contract.jpg
Thank You
Dear Excel Professionals,
Let me ask You a question, can You please help me with how to fill Contract with last row from range with button, attaching photo and file.vba fill contract.jpg
Thank You
You could do it with just formulas
K1
=INDEX(A:A,COUNTA(A:A))
K2
=INDEX(B:B,COUNTA(A:A))
etc.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
AlphaFrog formula works perfectly didn't know that it can be solved just with formula Thank You!
Last edited by tta.akmal; 12-26-2018 at 07:31 AM.
You're welcome. Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks