Hi guys,
I have some limited excel experience, but need help setting something up for my Mum.
It is a record of shares she owns and the dividends they have paid her.
I have a workbook with several sheets. each sheet has a table that is a record of an individual stock. Each table has 10 columns.
(If you want to know the columns in order are: Date, Stock Code, Dividend Unfranked, Dividend Franked, Franking Credit, Shares Issued, Issue Price, Cost of Shares, Total Shares, Total Cost)
In each single table the records are listed in date order for that stock. What I need to know is how I can combine all of the data into one "Master Table" which can grab all the rows from all of the tables in their different sheets and put them in one "master table" which lists them by date.
None of the other stuff I've read online has helped. I don't need to manipulate the data, just combine all of the tables into another table in a separate sheet and sort it by date ascending.
Any help will be much appreciated. Thanks!!
I have some limited excel experience, but need help setting something up for my Mum.
It is a record of shares she owns and the dividends they have paid her.
I have a workbook with several sheets. each sheet has a table that is a record of an individual stock. Each table has 10 columns.
(If you want to know the columns in order are: Date, Stock Code, Dividend Unfranked, Dividend Franked, Franking Credit, Shares Issued, Issue Price, Cost of Shares, Total Shares, Total Cost)
In each single table the records are listed in date order for that stock. What I need to know is how I can combine all of the data into one "Master Table" which can grab all the rows from all of the tables in their different sheets and put them in one "master table" which lists them by date.
None of the other stuff I've read online has helped. I don't need to manipulate the data, just combine all of the tables into another table in a separate sheet and sort it by date ascending.
Any help will be much appreciated. Thanks!!
