Mark_N_Jen
New Member
- Joined
- Jun 23, 2005
- Messages
- 4
I sell on consignment on multiple auction sites. In my workbook, I have a sheet for each client for whom I sell with each months individual fees. Once a month, I download an invoice detailing new listing fees, gallery fees, final value fees, etc for each item I have listed. I convert it to an excel file. How can I add each individual rows' information to the proper client's sheet without having to do it manually?
The new invoice and the workbook sheets both have the item title in common. Is there a formula to get the invoice to "recognize" the same item title in my workbook and automatically link to the correct sheet?
Thanks much to whomever my knight in shining armor ends up being!
Jennifer
The new invoice and the workbook sheets both have the item title in common. Is there a formula to get the invoice to "recognize" the same item title in my workbook and automatically link to the correct sheet?
Thanks much to whomever my knight in shining armor ends up being!
Jennifer