Dear All,
I have try to many code but still fail to get the correct code.
I hope to get assistance form you guy if possible
I have a data which i want to separate data key by selected staff into their respective tab "sheet" as sample. My code alway update in the same row and replace the one i have been updated earlier.
My objective is to have the code update in next row as function "deem empty" [emptyRow = WorksheetFunction.CountA(Range("A:A"))].
Your expertise is greatly appreciate
Please refer file attached
Bookmarks