Hi,
Hope you can assist me.
I have workbook for leave application. I used userform for the data entry which I already sorted out through help of great people here too. However, my concern now - if I want to click a command button "Update", I want the data entry from "Sheet 4" to populate in Sheet 5 which is the leave request template/form that contains the same data in Sheet 4 except that it is arranged as formal leave template to be attached and send out through Outlook.
I used Vlookup in sheet 5 to capture the equivalent data in Sheet 4, however, since my code in data entry every time I do a data entry, it will insert a new row in row 2 where old data will move down. And not sure why the formula in my vlookup when it is not constant with $ (e.g. $A2) still moved and does not just capture just the data in row 2.
attaching and sending the file, I got no problem too. Just this one, I can't sort out now.
Thanks in advance.
Hope you can assist me.
I have workbook for leave application. I used userform for the data entry which I already sorted out through help of great people here too. However, my concern now - if I want to click a command button "Update", I want the data entry from "Sheet 4" to populate in Sheet 5 which is the leave request template/form that contains the same data in Sheet 4 except that it is arranged as formal leave template to be attached and send out through Outlook.
I used Vlookup in sheet 5 to capture the equivalent data in Sheet 4, however, since my code in data entry every time I do a data entry, it will insert a new row in row 2 where old data will move down. And not sure why the formula in my vlookup when it is not constant with $ (e.g. $A2) still moved and does not just capture just the data in row 2.
attaching and sending the file, I got no problem too. Just this one, I can't sort out now.
Thanks in advance.
