Creating a Master Sheet for A Text-only Workbook

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!

That is incredible and I would love to know how you did it! I have played around with Macros and VBA, but I am still very new. So, a detailed explanation would be great. I may ask you some follow up questions to fully understand!

Again, you have done some amazing stuff here and I'm fully impressed. Thanks for your help!

That is excellent and no rush! Totally blown away. I'm sure you can imagine how long I tried to find the answer myself and didn't come anywhere near it!

Originally Posted by xladept

Hi Kyde,

Welcome to the Forum

See if this works for you:Attachment 352644

*Do you need instructions?

Hi Forum Guru xladept ....
i also need your help .... can you help me.
is about similar but do know how to make it done ....

Zulfaizan, you should start your own post and then you might get advice from many more people.

Hey xladept,

I'm working more in the file now and I realized that the undo button doesn't work. I am assuming that the macro causes things to be overwritten and essentially cancels out the possibility of the undo button. Am I right or is there a way to get the undo button working? If not, I will keep going and hope I don't mess up too bad!

The normal undo function is what I'm talking about.

I input text into a cell on the child pages (current or previous). Once I hit the enter key or tab key to go to another cell, the undo button goes dim and cannot be used. Is this normal? Sorry for my explanation before being a little confusing.

I don't want to waste your time. You have already helped so much! So, I would say if you are looking to challenge yourself for some crazy reason, go for it! I am not perfect, so I do use the undo button from time to time.

Hey, no worries! I will just become better data enterer! Thanks for trying!