Update 2nd worksheet with new/changed data from first

[cdub]

Hello Gurus! I have muddled through with your examples and have a very rough solution for my task but I'm hoping to find a way to clean it up and make it easier to work with. I will be turning the task over to a newbie and they will not understand my rough work. I am a computer tech but can only just muddle through any programming.

I have one Excel 2010 Workbook with two Worksheets. "Phonelist" has five columns: Name, Email Address, Phone, Cell Phone and Birthday. "SDBM" is a sub-set of the PhoneList. The PhoneList changes from time to time, either with new additions or changes to existing data and when this happens, I want to automatically update "SDBM"

What I do now: (1) If I have NEW data, I enter ONE new name at a time in the PhoneLIst-- in the last row. (2) I jump to "SDBM" and click a button that runs a script that copies over the Name and Birthday fields from the last row of the PhoneLIst. If there is more than one new row, I have to jump back and forth as it will ONLY copy the last entry. (3) Then from SDBM I click a button that runs another macro that sorts the newly added row and places it in order by birthdate. The Age column is then filled in automatically. (4) I then have to format Worksheet "B" because my font and alignment is off. (5) Back to Worksheet "A" to run a Sort macro to place the new entry in alphabetic order by name.

What I would like to do is to update the PhoneList with ALL changes at one time then:

1. Sort the PhoneList so that the newly added data is in alphabetic order.
2. Compare PhoneList and SDBM. If there is new or changed data, update SDBM.
3. Sort SDBM so that the newly added data is in age order.
4. Calculate and populate the AGE field for the newly added rows in SDBM. Right now it is a complicated mess.
5. Make sure that font and alignment are set so that it is ready to be printed.

I have found various examples here and in other forums and have tried to piece them together for my purposes but most are too complicated for me at this point and I'm running out of time. If I was to continue doing this task I could keep working on it while using my current ugly procedures but, the new person will be very confused and frustrated, I'm sure.

Any help would be greatly appreciated. You will be helping a good cause and teaching me a few things too!

Thanks in advance!

[RudiS]

The 5 requests are not too difficult to automate. I do have one question? Q#2... How is the PhoneList compared with SDBM? Is it only with a single column like email (which is a unique field) or is there any other requirements to take into account?

[cdub]

Actually the data that copies from the PhoneList to SDBM is column A, the name field and column E, the birthdate field.
SDBM gets weird then, I have a column that is pre-filled with the current date (Hidden), and a column that calculates exactly how old the person is...years and days and then a column with the birth month. The data in SDBM is then sorted by (1) the birth month and (2) the exact age. So, SDBM shows the persons name, their birthdate, how old they are and it is all sorted by date. I know, weird. If I could just figure out how to do the simple part, the compare and update of SDBM and copy of the name and birthday, sorted by date, I'd be more than happy. Thank you so much for your help!

[cdub]

I've attached a copy of what I have. Thanks!

[RudiS]

Hi,

Here is an updated workbook with the functionality I *assumed* you need. I have remodeled the entire workbook; cleaned up the formulas (and removed the hidden columns which are no longer needed), removed the extra buttons and updated the code to do ALL sorting and transferring in one go.

Basically, you can add all the necessary names to the birthday list, and continue to add new names to it along the way. The Sort and Transfer button will replace the list in the SDBM list with the names in the birthday list each time you click the button. The SDBM list will be sorted according to the Month and Birthday content after the transfer.

Give it a try and see if it is doing what you need....

[cdub]

You are AMAZING! Thank you so very much! I can only hope that with more practice I can learn to this.

[RudiS]

Good to know its working for you...