12345678910
12345678910
Last edited by 280ZXT; 11-07-2011 at 12:18 PM.
Could you please upload a sample
Thank you so much! As always anu direction is appreciated!
Last edited by 280ZXT; 11-07-2011 at 12:19 PM.
So if i am not mistaken, if a row has Modifications needed as "Y" in column N, it has to go to the "Modifications Needed" section in the Summary tab. And if it shows as "Open", it should go under "Leases Needed", right?
Yes, that's exactly what I am looking for. Below is the code I have come up with (Frankenstein style using everyone elses codes) which may help. I believe we are not declaring the ranges correctly but not sure where our mistake is. If there is an easier way please let me know.
Please Login or Register to view this content.
Last edited by 280ZXT; 11-02-2011 at 12:39 PM.
Please put your code within code tags before the moderators get you. In the meantime, i will look through it and revert.
Your code suggests that there are separate sheets "Need Mod", "Need Leased", however your sample workbook just has 1 summary sheet with 2 sections.
So what is the final output you need? Do you need it in 2 separate sheets as per your code ? Or do you need 2 separate sections in the summary sheet?
I need the output to be all on one page with 2 different sections. The reason my code is written with 2 summary pages is because I dont know how to create it with just one summary page. If there is a way to take my code and then create another final summary page with both 'mod needed' and 'need leased' I would want that... but I'm not sure how to do that.
Thanks!
You have edited the original message. Its tough to recollect what the issue was....is this resolved?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks