I need to distribute the daily dollar amount for each merchant from "DAILY DEPOSITS" onto each merchants individual sheet for that date.
On the daily DAILY DEPOSITS sheet, the date and amount is changed everyday.
For example on the "DAILY DEPOSITS" sheet ACCENT BRIDAL(C4) had $1.00(D4) for 10/06/12. I need this to be reflected on the "ACCENT BRIDAL" sheet showing a deposit of $1.00 for 10/06/12 in cell C98.
If anyone can give me any help on this I would highly appreciate it.
Thanks
Bookmarks