I have data coming into a tab with multiple rows for columns A->L. Additionally, I have some formulas entered into columns M->O to parse out the information found in column L.
What I am needing assistance on is having the macro update by carrying the formulas in M, N, and O to the very bottom, which will vary based on the number of rows which has data.
Can anyone help me with this? Thanks.
Could we see your workbook?
Desensitize it if necessary. The formulas and layout are the important bits to provide a solution here.
BSB
Why do you need a macro for this? If you structure your formula to test for an empty cell, it wont show anything until the cell is filled.
=IF(A2="","",your-formula)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Perhaps the easiest solution is to convert to data range to a table. Include columns A->O in the table. As new rows of info are added in columns A -> L the formulas in columns M ->O will automatically populate down and calculate.
Thanks for your replies. This aspect will work just fine for what I am trying to implement.Originally Posted by FDibbins
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks