Hello
I am struggling with this for the past few days and couldnt find anything that I could relate to in terms of my problem.
I have a spreadsheet with 2 x worksheets....1) PS & 2) Cashflow
Worksheet PS has Unit numbers in Column A (A4:A26). In front of each Unit Number, I have respective Unit Details like Sale Month (MMMYY format), Agreement Value (Price) and then stagewise breakup of the Unit price. So, effectively the Unit price is broken down into 10 installments based on production stages, where people pay particular amount once particular stage is completed.
The Timeline for production process is pre-set i.e. Once you know the Sale Month, all the months for following stages are pre-decided based on preset timelines.
Worksheet "Cashflow" simply shows Unitwise Progress / payment on a calender format i.e. I have Unit numbers (sames as worksheet PS) in Column A (A6:A29) and Column B onwards have Months (in MMMYY format, e.g. Mar-17) as Header in row 5.
On the top of the sheet I have 2 x ActiveX Comboboxes and a command button. Combobox "cboUnit" displays the Unit Number List from Column A and Combobox "cboMonth" displays the Months from the header row.
Once a specific Unit is sold, I want to be able to Select Unit No from first combobox, then select the Sale Month from second combobox and when I click enter, I would like Stagewise Price Breakup Values for the selected Unit from Worksheet "PS" to be copied and pasted into worksheet "Cashflow" in the Row that has the ame unit number in Column A.
Also, When I select the start Month, for example Mar-17, then the value for 1st stage in Price Breakup will fall under Mar-17 and following stage amounts need to fall under relevant months which are preset i.e. Sale Month : Mar-17, then Stage1 will be Sale Month +1, Stage2 will be Sale Month + 2, Stage3 will be Sale Month + 4 and so on.
I have a sample worksheet, but not sure if I can upload it here.
Can someone please help with this. I am unsure of I should search for to find this functionality.
Would really appreciate any help !
Thanks
V
I am struggling with this for the past few days and couldnt find anything that I could relate to in terms of my problem.
I have a spreadsheet with 2 x worksheets....1) PS & 2) Cashflow
Worksheet PS has Unit numbers in Column A (A4:A26). In front of each Unit Number, I have respective Unit Details like Sale Month (MMMYY format), Agreement Value (Price) and then stagewise breakup of the Unit price. So, effectively the Unit price is broken down into 10 installments based on production stages, where people pay particular amount once particular stage is completed.
The Timeline for production process is pre-set i.e. Once you know the Sale Month, all the months for following stages are pre-decided based on preset timelines.
Worksheet "Cashflow" simply shows Unitwise Progress / payment on a calender format i.e. I have Unit numbers (sames as worksheet PS) in Column A (A6:A29) and Column B onwards have Months (in MMMYY format, e.g. Mar-17) as Header in row 5.
On the top of the sheet I have 2 x ActiveX Comboboxes and a command button. Combobox "cboUnit" displays the Unit Number List from Column A and Combobox "cboMonth" displays the Months from the header row.
Once a specific Unit is sold, I want to be able to Select Unit No from first combobox, then select the Sale Month from second combobox and when I click enter, I would like Stagewise Price Breakup Values for the selected Unit from Worksheet "PS" to be copied and pasted into worksheet "Cashflow" in the Row that has the ame unit number in Column A.
Also, When I select the start Month, for example Mar-17, then the value for 1st stage in Price Breakup will fall under Mar-17 and following stage amounts need to fall under relevant months which are preset i.e. Sale Month : Mar-17, then Stage1 will be Sale Month +1, Stage2 will be Sale Month + 2, Stage3 will be Sale Month + 4 and so on.
I have a sample worksheet, but not sure if I can upload it here.
Can someone please help with this. I am unsure of I should search for to find this functionality.
Would really appreciate any help !
Thanks
V