Hi all,
can anybody tell me how to transfer data from sheet 1 to Sheet 2. please see the attached sample sheet. when i OK button click all the data as per desired transfer to another sheet. i use =ref technique but not possible every time.
also click OK button remove data from PO-Entry ready to for another data record.
all yellow highlighted cell will be removed data.
Bookmarks