Hi,
I'm looking for a macro code that will help me format a list that is constantly updated with new data.
The list contains recipes for the product my company sells. The list is each week updated with new recipes or changes in recipes. Today I manully draw a line between each recipe, I have a colum on the the right side of the list calculating the total procentage in the recipe to controll they add up to 100%. If a cell in this column says 100% I would like a macro to draw a bottom line in that cell as well as in all cells in that row.
I have attached a example file to show you what I mean. (Obs I cant use the product name in col A to determine when a recipe starts cause sometimes there are several recipes for the same product - as you see for Prod D in the example).
Thanks for any help,
Martin
Bookmarks