MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Sub Get_Data() Dim wbk As Workbook Dim destWbk As Workbook Set destWbk = ActiveWorkbook FileToOpen = "K:\Working Data\Loading.xls" Set wbk = Workbooks.Open(FileToOpen) wbk.Sheets(1).Range("A1:IV65536").Copy Destination:=destWbk.Sheets("TotalReq_vs_Bars").Range("A1") wbk.Close End Sub
|Excel Lookup - True if return at least one match||9||44|
|populate some cells after data verification||45||26|
|inputbox for search column and text||1||20|
|VB.net Code to make a TaskPane float in Excel Add-in||2||10|