Hi everyone,
Can somebody please tell me how to consolidate data from several worksheets into one (income statements for several years) into one excel sheet examining the trend by department?
They are not of the same format necessarily, I will need the formula to lookup the first column into each of the years and return the value of the corresponding caption for each year. Eg Should be able to locate say the revenue from each of the year’s excel and return the value of the revenue for that particular year.
Same for all items of the income statement.
Thx in advance,
M.
Can somebody please tell me how to consolidate data from several worksheets into one (income statements for several years) into one excel sheet examining the trend by department?
They are not of the same format necessarily, I will need the formula to lookup the first column into each of the years and return the value of the corresponding caption for each year. Eg Should be able to locate say the revenue from each of the year’s excel and return the value of the revenue for that particular year.
Same for all items of the income statement.
Thx in advance,
M.