Posts by mrmmickle1

mrmmickle1 · Jul 24th 2014

Re: Position Chart in Range

You can also size a chart to a specific Cell that you have previously sized:

Code

Sub AddChart()


        Dim Shname As String


          Shname = "Sheet1"
    
            With Cells(2, 2) 'B2
                    Sheets(Shname).Shapes.AddChart msoTextOrientationHorizontal, .Left, .Top, .Width, .Height  
            End With
    
 End Sub

Display More

mrmmickle1 · Jul 16th 2014

Re: Copy info from other workbook from cell

Try this:

=CONCATENATE(VLOOKUP(A1,'C:\Users\Folder\[employees.xlsx]Sheet1'!A:D,2,FALSE)&" ",VLOOKUP(A1,'C:\Users\Folder\[employees.xlsx]Sheet1'Sheet1!A:D,3,FALSE))

You can put that in a hidden column then you can have two formulas in column 3 or 4 that will extract the first and last name

something like this =LEFT(A1,FIND(" ",A1)-1)

and this =MID(A1,FIND(" ",A1)+1, 99)