Penstrokes
New Member
- Joined
- Jan 30, 2005
- Messages
- 8
If I have a text name in C3 and the commission amount paid in c4, can I recall that amount for that text name in a different spreadsheet in the same workbook?
This name and $ amounts will be listed several times within one spreadsheet, and I need to create something that will recall those amounts each month. Something that I don't have to manually do each month.
Can that be done on Excel or do I need to learn access?
Thanks for any suggestions! I've totaled the monthly commission amounts for all clients and vendors, now my client wants to see how much each vendor pays each month (when they might sell to 2 or 20 different accounts).
Donna
This name and $ amounts will be listed several times within one spreadsheet, and I need to create something that will recall those amounts each month. Something that I don't have to manually do each month.
Can that be done on Excel or do I need to learn access?
Thanks for any suggestions! I've totaled the monthly commission amounts for all clients and vendors, now my client wants to see how much each vendor pays each month (when they might sell to 2 or 20 different accounts).
Donna