Required: 1. Highlight rows containing multiple copies of a particular invoice number. eg an invoice's details may be display on 2 or 3 rows. These rows will be highlighted in light blue. Alternate groups of rows need to be highlighted a different colour (see examples attached eg Row 2 has the invoice displayed only once so requires no highlight, Rows3-4 has the invoice displayed 2 time, rows 5-7 has the invoice 3 times. ) In column H the total products value for that invoice number is required displayed on the last row containing that particular invoice number. The formula/rule will be needed so that it can applied to new worksheets or clear instructions provided on how to implement the necessary formulas.
-> Excellent Programmer
-> 4+ years of experience in VBA programming, PDF designing and Excel Macro Development
-> Will provide high quality product.
-> I have a Master degree in Computer Application and kind of a workaholic.I just love working
-> Good Analytical and Problem Solving Skills
Happy to Help
Lal
$16 AUD em 3 dias
5,0 (8 avaliações)
3,4
3,4
3 freelancers estão ofertando em média $17 AUD/hora for esse trabalho
Hi,
I have more than 14 years of VBA/Excel exp and I am expert in this kind of work.
I have completed more than 250 projects. Please look at the feedback left by my employers to know more about my work.
Waiting for your positive response.
Thanks.