Sales Consolidation

Output format file name:

  • C:\DailySales\Output\EOD_Consolidated_Sales.xlsx

Input file names:

  • C:\DailySales\Input\MonthlySales_East.xlsx
  • C:\DailySales\Input\MonthlySales_West.xlsx
  • C:\DailySales\Input\MonthlySales_North.xlsx
  • C:\DailySales\Input\MonthlySales_South.xlsx

Output file name:

  • “C:\DailySales\Output\EOD_Consolidated_Sales_” + Now.ToString(“dd-MM-yyyy”) + “.xlsx”

Date filter condition:

  • Now.ToString(“dd-MM-yyyy”)