I need this for my IT project.
I have a spreadsheet with list of clients and its types. Names starts at B7 and by running macro i made new clients can be added to the row.
What I am confused with now is that i have other spreadsheet wit invoices where heading is MAINCONTRACTOR and its begin at cell C4.
What i am looking for is that i want to make combo box which will have on that invoice spreadsheet list of clients which is found in the previous clients spreadsheet,the ones already in and it should also be added automatically new clients when added so i can choose in a column whoever contractor i want.
Anyone willing to help?
Please
I have a spreadsheet with list of clients and its types. Names starts at B7 and by running macro i made new clients can be added to the row.
What I am confused with now is that i have other spreadsheet wit invoices where heading is MAINCONTRACTOR and its begin at cell C4.
What i am looking for is that i want to make combo box which will have on that invoice spreadsheet list of clients which is found in the previous clients spreadsheet,the ones already in and it should also be added automatically new clients when added so i can choose in a column whoever contractor i want.
Anyone willing to help?
Please