I have searched high and low for the answer, but I'm not finding it. So, please help! I am currently using excel 2010.
I have a very simple workbook. It consists of two sheets. Both of which have the same column titles (Company, Year, Catch Copy, URL). The data contained is all text, nothing numerical. The first sheet shows our current clients (titled "current") and the second sheet shows our previous clients (titled "previous"). I want to make a master sheet which combines all the entries on the current and previous sheets. I also want the master sheet to update whenever any new entries are added to either sheet.
Please give me a hand and if any other info would help just ask! Thanks!
Bookmarks