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]

1	"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)
	Input file can vary each month.Each Input file has different number of rows, but fixed number of columns/same headers
	There should not be any manual invention needed in macro. It should refer to Input files in "Input folder" where "console" file is saved
2	"Report" Tab >Generate reports by country(All for all counties)(Dropdowns>SubDropdowns)- in "Report" tab in same file
	Should grey out unused rows below and format only Report rows,Columns
	Note:- Some numbers in "Data" tab needs to be converted by dividing with FX rate on "FX" tab for the report
3	Reports generate as selection on Top dropdowns/subdropdowns. If nothing selected in below dropdown,should take as "total" Automatically
	Should add subtotal on End Row(shaded-Grey color) and add borders for subtotals (Top and below border)
	Need to covert no for some countries as per "FX" Tab"
	FX tab will be updated manually by end user Report tab:- Reports to publish as selection on Top dropdowns.If nothing selected in below dropdown,should take as total Should add subtotal on End Row 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- Should list any new sub-brands added for the month Old list can be copied on Right for reference 2. Should list if FX(Forex conversion rate) is missing for any country on "FX" tab Any country for no Fx(Forex rate) Impact has to be updated as 1 by user <colgroup><col></colgroup><tbody> </tbody> <colgroup><col></colgroup><tbody> </tbody> <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> </tbody>

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[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..