Kaniguan1969
09-20-2014, 09:19 PM
Hi Expert,
I have a requierement to check, validate and add records from workbook to another workbook.
1. working file workbook with macro codes that perform all the process. This is my main excel file with buttons.
2. The incoming workbook that contains all incoming data given by a user that handle the incoming materials its a fresh data.
3. status summary workbook this is coming from other group that contains records monitor if it is already transacted in the system. the status column that contains Done and Not yet.
My requirements is
1. how could i the check or compare the data from workingfile workbook if that particular tracking#, model, total and labels is exist in Status summary workbook. if exist i have to validate if the status is "Not yet" have to change the status at working file workbook as INTRANSIT" while if the status is "Done" change it with "RECIEVED".
2. the incoming data will be dump to working file workbook at the last empty row. before that i have to check if the tracking number is already exist to working file, if exist nothing will happen but if not yet exist i have to dump those tracking no and others details to working file workbook.
3. the same process with number 1 to check the records if exist and validate the status. if done or not yet.
Hoping the requirements is clear and well defined. Thank you very much.
By the way, just created a sample data for these 3 workbook into one workbook under 3 worksheet as reference.
attached is a sample data.
I have a requierement to check, validate and add records from workbook to another workbook.
1. working file workbook with macro codes that perform all the process. This is my main excel file with buttons.
2. The incoming workbook that contains all incoming data given by a user that handle the incoming materials its a fresh data.
3. status summary workbook this is coming from other group that contains records monitor if it is already transacted in the system. the status column that contains Done and Not yet.
My requirements is
1. how could i the check or compare the data from workingfile workbook if that particular tracking#, model, total and labels is exist in Status summary workbook. if exist i have to validate if the status is "Not yet" have to change the status at working file workbook as INTRANSIT" while if the status is "Done" change it with "RECIEVED".
2. the incoming data will be dump to working file workbook at the last empty row. before that i have to check if the tracking number is already exist to working file, if exist nothing will happen but if not yet exist i have to dump those tracking no and others details to working file workbook.
3. the same process with number 1 to check the records if exist and validate the status. if done or not yet.
Hoping the requirements is clear and well defined. Thank you very much.
By the way, just created a sample data for these 3 workbook into one workbook under 3 worksheet as reference.
attached is a sample data.