new sheets created with a template and populated with data when conditions are met

[rskay14]

I have a workbook with three sheets: Collections, Client and Interest
New sheets created from a range in Sheets("Interest"). The range in Sheets("Interest") holds the client names.
Then the template in Sheets("Client") is copied and pasted into the new sheets

For each new sheets cell B6 holds the client name and .Range("A10:A1317") holds the dates
Sheets("Collections").Range("D10:D1317") holds the dates and .Range("D8:WC8") holds the Client Names
if Sheets("Collections").Range("D8:WC8") = new sheet.cells(6, 4) then
if Sheets("Collections").Range("D10:D1317") = new sheet .range("A10:A1317") then
copy the value in Sheets("Collections").Range("D10:WC10").offset(0, 3) to new sheet .Range("C10:C1317")
end if
move down on row and repeat the steps

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[SamT]

Please Login or Register  to view this content.

Edit to Add: now I come back and see that the ranges in your code do not match the ranges in your text.

[rskay14]

after the new client sheet is filled by setting value of cell B6 in new sheet same as Sheet tab name, i need to populate the other cells in the new client sheet as well.

Sheets("Collections").Range("D10:D1317") holds the dates
Sheets("Collections").Range("D8:WC8") holds the Client Names

if Sheets("Collections").Range("D8:WC8") = new sheet.Range(B6) then (Client name matches)
if Sheets("Collections").Range("D10:D1317") = new sheet .range("A10:A1317") then (Date Matches)
copy the value in Sheets("Collections").Range("D10:WC10").offset(0, 3) to new sheet .Range("C10:C1317")
end if

do this until all data on Collection Sheet is posted in each client worksheet. Also when new data is input it should append if new and update if modifying.

[SamT]

That is an xlsx book. There is no code in an xlsx book.

[rskay14]

excel file reloaded as xls book

[rskay14]

Excel with code

[SamT]

I added colors to the workbook. In Sheet Collections the Source Cells are different colors. In sheets test1 and test2, the destination cells match the colors in Collections.

Is this what you want?

[rskay14]

yes that is what i want

[rskay14]

I need help for the macro to automatically fill in the fields when i have more than 20 customers.