View Single Post
 
Old 11-06-2016, 10:25 PM
EnG_TeLeCoMm EnG_TeLeCoMm is offline Windows 10 Office 2016
Novice
 
Join Date: Nov 2016
Posts: 2
EnG_TeLeCoMm is on a distinguished road
Exclamation Please help...VBA Team

Dear Sir…

I have visited your prestigious web-site and found a lot of useful information regarding how to learn Microsoft excel. Helping You Excel is the first thing I conclude when I saw your web-site, so here I am.

I am working in a company as a procurement engineer, it named CCE, well I am struggling to create a formula on procurement. I would describe it into short steps:-
1- A purchase requisition is simply, a form need to be filled prior to placing a purchase order, shows exactly items need to be purchased, quantity…etc.
2- Once purchase requisition is made, I need to have an option of converting to Pdf and the LOG/Archive sheet/Tab need to be filled automatically with information within purchase requisition, so it is easy to return back at any time.
3- Once purchase order placed, manually I will add, then the cell becomes green, if there is no P.O entered, the cell-related should flash or becomes red, so it is easy could be visualized and I will push until P.O issued.

Well, I made an excel sheet, attached, showed what I am trying to do, as you are an expert, you will figure out what I need exactly.

Hope to hear from you soon,
I have approached many web forums, but no clue. so, for any reason may conflict with your forum rules, please consider this is the only thread is valid and active.
Regards.


please please help.
Attached Files
File Type: xlsm Template_Log.xlsm (414.8 KB, 9 views)
Reply With Quote