formula linking "like" text
I have a workbook (Client Fees) with several sheets. Each sheet represents a
different client's auction fees (I sell on consignment on several sites). I import my invoice each month from the auction sites and convert it to a spreadsheet format. I need an external formula that will link the matching text in the new invoice to the same text in the Client Fees workbook. I need to eliminate having to put the client's names next to each entry in the invoice, sort it and then add it to the corresponding Client Fees worksheet. Hope this makes sense! Thanks in advance! Jennifer |
All times are GMT +1. The time now is 07:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com