Hi there Experts,
I am new to the forum here and my knowledge to excel formula is limited. So your kind help is greatly appreciated.
I need some help to solve my problem that i have been working on for so long. But couldn't get the result i wanted.
Basically, it is a scheduling of approving or rejecting of request dates. whereby, i will receive the request dates from Google doc form and then i will
extract the data from web into the excel. The data i receive will include the ID, Date request and Remarks.
With the Information in hand, the data will then be "plot" into a schedule (which is a year calender that i have created on excel) base on the ID requested from the web and the ID in the excel.
After plotting, i also want to check if the number requested date exceed the quota set PER DAY, if it exceed, then i have to reject, if its not then approve.
So here comes the problem..
After all the dates have reflected on the calender, I want to get the information from the calender result(which is whether the date is approve or reject) back on to respective ID and Dates requested.
I have attached a example excel for clearer view of my explanation.
Is there any function or macro that can help me achieve what i wanted?
Please help me..
Thank you in advance! =)
Bookmarks