I have several separate workbooks with several different data columns in them. The information that I am interested in from each worksheets is: 1.The date and 2.The Total (Income) for that date.
I want to copy this info onto a separate worksheet. I want the new data to be displayed by date order with Column A displaying the date, column B displaying the income( for that corresponding date) from workbook 1, Column C displaying income from workbook B etc.. Basically I have already constructed individual workbooks for each different source of income. Now I am trying to make an income report displaying each day of work and how much was earnt on that day. I don't know how to use macros or VBA. Hoping there would be a formula that I could use. Any help greatfully appreciated.