Hi can anyone help providing me the VBA code to extract data from trial balance and adding the expense to day1 to day31 column in a consolidated spreadsheet. Ken_555