VBA send data to column in different ws based on criteria

[titantough]

Getting to know VBA, so please bear with me. Your site has been a tremendous saving grace for me. Thank you sooooo much.

I am know trying to learn how to copy data from one column in one worksheet and send to a different column in another worksheet based on value found in yet another column. I have tried a few codes, but obviously have alot to learn.

Example as per attachment.

Worksheet "Invoicing" is for entering estimated week we will invoice for services rendered. It contains the following information:

Column A = client names
Column B = how many weeks client typically takes to pay on invoicing
Columns C : ? (shaved down to C:W for this post) has weekly headers

Worksheet "Cashflow" is for entering data found in "Invoicing" and moving it to the proper weekly column based on the number of weeks client typically takes to pay. It is telling us what week to expect the payment. It contains the following information:

Column A = client names
Column B = how many weeks client typically takes to pay on invoicing
Columns C : ? (shaved down to C:W for this post) has same weekly headers as "invoicing"

What i am trying to figure out is a code that takes data entered into the "invoicing" worksheet, and autopopulates the "cashflow" worksheet with the values in the appropriate columns based on weeks to pay - column B.

I hope i have explained this well enough. I have attached a sample file.

I also thought using a command button called update on the invoicing worksheet, would work okay to put the code

[amulee]

Please try this one

Please Login or Register  to view this content.

[titantough]

Thank you so much!
It works perfectly!