Hey guys! This is my first post here, i'm a rookie to VBA and need some help on something that i've been battling for weeks now.

I have a workbook with several sheets. Each sheet contains two tables which will be updated regularly, including having rows added and deleted. The tables use the vlookup function to retrieve data from another workbook.

Column E on both of the tables contains dates of birth. I need both of these tables to update according to this column every time each of their records are updated. Primarily the updates will be row additions and subtractions.

In order to use the vlookup i need each new row inserted to contain the formulas from the neighbouring rows. These formulas (in columns B, C, D and E) retrieve information from the external source based on the value entered in column A.

I have code that accomplishes both of these tasks, but when combined they interfere with each other and cause problems. I need to find out how to achieve these two things simultaneously.

This is the code for the autosorting.

Please Login or Register  to view this content.
In this code the first table is a range named 'SRPCurrent' (Which is cells A3:U21) and is being sorted according to the range named 'SRPDOB1' (which is the fourth (E) column of that first range, namely E3:E21).

The second table is a range named 'SRPStarter' (A25:U43) which is being sorted according to 'SRPDOB2' (E25:E43)

I have tried several methods of inserting new rows into these tables, but they've all gone wrong somewhere.

The actual files contain data personal to my company's customers so if I were to provide an example document I would have to create a dummy spreadsheet for that file to retrieve data from so hopefully i've given enough information here. Failing which i'll do just that!

Any help would be appreciated thanks!