VBA urgent help needed

[Vbalearner85]

Hi guys..need help on vba for:-Have one consolidation file to consolidate data from different Input file.Column headers are same, Row data can vary for each file ( File path will be office shared drive):-

[MENTION][MENTION][MENTION][MENTION][MENTION][MENTION][MENTION][MENTION][TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64, align: right"]1[/TD]
[TD="width: 64"]"Consolidation" File> "Data" tab - Do Consolidation of different Input files("A" and "B" In"Input folder" in shared drive) by country(Each Input File can have 1-10 countries)
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Input file can vary each month.Each Input file has different number of rows, but fixed number of columns/same headers[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl64"]There should not be any manual invention needed in macro. It should refer to Input files in "Input folder" where "console" file is saved[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]"Report" Tab >Generate reports by country(All for all counties)(Dropdowns>SubDropdowns)- in "Report" tab in same file
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Should grey out unused rows below and format only Report rows,Columns[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Note:- Some numbers in "Data" tab needs to be converted by dividing with FX rate on "FX" tab for the report[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="class: xl63"]Reports generate as selection on Top dropdowns/subdropdowns. If nothing selected in below dropdown,should take as "total" Automatically[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Should add subtotal on End Row(shaded-Grey color) and add borders for subtotals (Top and below border)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Need to covert no for some countries as per "FX" Tab" [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]FX tab will be updated manually by end user

Report tab:-
[TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]Reports to publish as selection on Top dropdowns.If nothing selected in below dropdown,should take as total[/TD]
[/TR]
[TR]
[TD]Should add subtotal on End Row[/TD]
[/TR]
[TR]
[TD]Need to covert no for some countries as per "FX" Tab"
Should grey out unused rows on bottom and unsed Columns toward right

Exceptions Tab-[TABLE="width: 339"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Should list any new sub-brands added for the month[/TD]
[/TR]
[TR]
[TD]Old list can be copied on Right for reference
2.[TABLE="width: 339"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Should list if FX(Forex conversion rate) is missing for any country on "FX" tab[/TD]
[/TR]
[TR]
[TD]Any country for no Fx(Forex rate) Impact has to be updated as 1 by user[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[mole999]

have you considered > https://www.mrexcel.com/consulting-services/ as you appear to be asking for a bespoke build

 

[MARK858]

It is also written more like a college assignment more than a normal question

 

[Vbalearner85]

I am new to forum...so probably went in too much detail..I will break up my problem in parts and then post code by code..thanks for the feedback

 

[MARK858]

It isn't that it is in too much detail, it just looks like a college assignment. If it is then in general we won't write it for the questioner but we normally will offer advice to specific questions.

 

[Vbalearner85]

thanks Mark..will be more succinct for future questions..