Formula to copy data from worksheet if matching data found or adding to blank line if not

[katiedee]

I'm stumped. Nothing I've tried is working. Worksheet "Clients FY18" is to keep a log of all units reported by month for the whole fiscal year by client and company. However, the entire workbook is designed by month only. As an example, the staff completes their activity for clients they served for the month of October. Any units they enter for Company One, Company Two or Company Three should transfer over to the "Clients FY18" tab under the October column. However, that tab will already have some preexisting clients, so a formula is needed to search that worksheet to see if there is an existing "ID" and then add that particular October unit to the October column on that row with the matching ID. If there is no ID found, then it needs to add the client name and ID to the next blank row as well as the company name, as indicated on the corresponding company worksheet name. Each month I will copy the previous "Clients FY18" worksheet to a new workbook for the next month. This is to keep a running total of the fiscal year's units by client and company for the staff as they open their workbook each month. However, I know I have to be cognizant of only copying the previous columns up to the current month as the formulas I have on that worksheet are in the total column, so I don't want to paste over it or have a linked workbook.

Not every client will get a unit and each month new clients are being added.

The original workbook has over 20 worksheets with macros and formulas, but this new addition has got me so confused and stumped, so any help is appreciated. I've played around with the VLOOKUP function, but I have no idea where I'm going wrong, so am starting from scratch on this.

I see I am unable to post an attachment, but it is on the other website in the link below.

https://www.excelforum.com/excel-fo...ata-found-or-adding-to-blank-line-if-not.html