I am trying to accomplish the following conditional formatting and need some help please.
In worksheet1, when cells F5-F13=CustomerName, I need the corresponding data from cells D5-F13 (order amount) to be subtotaled in cell C5 of worksheet 2.
Please let me know if this makes sense.
Thanks,
Bookmarks