No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
4 Posted Topics
I have a problem about using find method in Excel VBA. Here is my program:- ____________________________________________________________________________ Private Sub CommandButton2_Click() Dim MyProduct As Range Product = Range("F8").Value Set MyProduct = ThisWorkbook.Sheets("Sheet2").Columns("E").Find(what:=Client, LookAt:=xlWhole) [COLOR="Red"]ActiveSheet.Cells(8, 8).Value = MyProduct.Columns("G").Value[/COLOR] End Sub ____________________________________________________________________________ > how can I pull data in Columns(G) to Cells(8,8) >the program …
hai and hello everyone, 1) I have done the macro that can automatically pull data between 2 sheet in the same workbook. The example below, just compare 2 cell and then pull the 4 data to other sheet if true. If i have 100++ data to compare between 2 sheet …
hai, i need help How to do the macro that can 1st check the right(same) name between two excel, than pull out the data ?
I got two excel file in difference location. Both save in sharing folder at company server. 1st excel name is Operation file and the other name is NPI file. Both have Product name, Package, Actual Ytd at Xfer and Actual PML at Xfer. Engineer will key-in the data(Actual Ytd Xfer …
The End.