Kaniguan1969
10-16-2014, 05:59 PM
Hi,
I have an excel file worksheet (WorkingFile) that i would like to update the cell value in a particular column. The data is coming from different workbook that comprise from diff supplier. There are specific column in supplier workbook that i would like to copied and paste to my workingfile workbook. attached a sample data create a a worksheet for my workingfile and 2 supplier worksheet. the filter sheet contains the control. one is a drop down list that will filter records of workingfile base on supplier. update button this will update the cells that i would like to automate. Any help is very much appreciated. Thank you.
I have an excel file worksheet (WorkingFile) that i would like to update the cell value in a particular column. The data is coming from different workbook that comprise from diff supplier. There are specific column in supplier workbook that i would like to copied and paste to my workingfile workbook. attached a sample data create a a worksheet for my workingfile and 2 supplier worksheet. the filter sheet contains the control. one is a drop down list that will filter records of workingfile base on supplier. update button this will update the cells that i would like to automate. Any help is very much appreciated. Thank you.