Hello,
I'm new to this forum and it's the first time I can't find a solution to my problem myself (of course I have checked many forum topics but to no avail).
The situation:
I have 2 tables on 1 sheet and want to combine them into 1 or update, as you will.
The table details can be seen in the sample file I attached.
What I would like to do now is compare both tables in that sheet, based on multiple criteria (combination of emp ID, date and a number) and if that combination does not exist in table 1 but does in table 2, a blank row should be added on the same rownumber that contains the data in table 2 (so moving the rest of the cells in table 1 down) and vice versa.
Please view the sample file I attached.
(this is a fictive example, there are more rows and columns in the actual file)
As you can see, the number column is based on the date, if the date only shows up once per emp id, it will give a 1, if it shows up twice, it will show "1" for the first occurrence, "2" for the 2nd occurrence etc etc...
(Original)
Now based on the combination of the date, emp id and number column, I'd like to add blank rows in either table.
(Updated)
As you can see, every "required" row has been shifted down so that the corresponding lines would be on the same row number.
I have no idea how I can do this but I'm guessing this will require vba as you probably can't shift down using a formula.
Thanks in advance.
ps: I have also crossposted, which can be found here: http://www.mrexcel.com/forum/excel-q...lete-list.html
Bookmarks