Hi,
I did check the similar post in this forum at this link http://www.excelforum.com/excel-gene...-last-row.html. However this did not help me.
Column AL should hold the concatenated column values of D and AI. The problem is the last row is not same with every week's file and hence the Column AL should be populated until Column A last row. How can I achieve this?
Thanks in advance.
Hello venkat.ramamoordhy1,
Welcome to the Forum!
Do you have a workbook you can post? It will be easier to develop and test solutions with one.
How To Post Your Workbook
- At the bottom right of the Reply window, Click the button Go Advanced
- At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
- Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
- Click the Select Files button at the bottom middle of the dialog.
- In the new window Find the file you want to upload, select it, and Click Open.
- You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
- Wait until the file has completely uploaded before you exit the File Manager dialog.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks Ross for the quick reply.
I tinkered around further and I was able to get what I wanted.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks