This is a very simple report I need.
I have a database (excel, access or sql) with some items.
They are classified by category and 2 attributes.
What I need is a report that will show a row with a category and then list in columns by attributes the items. If an item has inventory zero or less than zero then it will show the item highlighted in yellow.
The idea behind this is to print the report on a letter size paper (so it can show 5 or 6 columns) be printed, the employee will put a check mark on the square for what is missing and deliver to the warehouse so they can supply the items.
Will prefer that the report is made on Excel, due that employees are more familiar with it.
Décerné à :
24 freelances ont fait une offre moyenne de 4 $ /heure pour ce travail
Hi, I can do it with vba (macro). Please let me know which excel version your users use now so I can write macro accordingly. Looking forward to hearing you, Cuong NH
Hi, I have understood your project, will add a constraint to the excel field and highlight the inventory that is below or equal to zero. I assure you a quality work at the earliest. Regards, Vickrant
I will commence work as soon as you award the project...... Highly proficient in MS Excel, Data Processing, and Admin Support, Accounting , Bookkeeping and Computerised Accounting, ERP, Oracle Queries