Nested For Loop + If Statements Error

Hey Guys!
I am currently a new member to the forum, but long I have been getting help from the community. It feels finally very nice to be an official part of the group

I came across a problem today while I was trying to establish a VBA code to do the following:

I have 12 sheets of detailed records, each comprises of some SAP outputs (13 columns: year/month/exact date/x/x/x/definition/x/x/process definition/financial value/x/x; with x's being irrelevant).
I am trying to filter them through their "month" and its financial value if it is above a limit stated at the first (homepage) worksheet.

I tried to establish a nested for loop (dual) and implement a conditionality within to check if "month" and "financial value>Blabla": and search for all existing worksheets in the workbook. Simultaneously, through the use of a row counter, the suitable data will be posted on the homepage worksheet with relevant headlines.

I am already getting some nicely sorted headlines but no relevant data are being published in the homepage worksheet.

Please Login or Register  to view this content.

As I have stated before, the code above results with properly placed headlines and table headers (thanks to i=i+1), but no relevant data from wsheets. Also the wsheets contain records compliant with the finValue and month variables.
I have tried every possible nested loop structure (do-while etc.) but had no better results. I guess the problem lies within my noobness :D
I am looking forward to getting needed help from you experts !

Thank you sincerely,
Cinarbe


Edit: After JosephP's warning I am adding other 2 links of my question, posted elsewhere.
I apologize for it.
http://answers.microsoft.com/en-us/o...7-196cfb0f63dd
http://www.mrexcel.com/forum/excel-q...ml#post3307086

hi and welcome aboard, but I'm afraid your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).