Transferring Data

[Irfaan Kahan]

Hello All

I'm a VBA amateur, but am familiar with the (very) basics. Currently, I'm trying to copy a data range (table values) from one workbook to another. The problems I'm having are as follows:
1. I need to copy only the non - blank cells within a given range I specify.
2. I need to then paste these values into an identical table in another workbook. However, I must begin the paste procedure at the first blank row in the second workbook.

I've been googling for a few hours now with no luck (close - but no cigar) - and being a noob the excel help file is a little over my head.

I don't have a problem opening workbooks or copying and pasting in general using vb, but this specific problem has me in a bit of bother.

Thank you in advance

 

[SteveO59L]

Use the board search for lastrow

 

[Irfaan Kahan]

Thank you

I had a look, but the topics with titles that seemed relevant didn't help me much - perhaps I missed it.

Here's what I've done so far, but no luck:

'Copy non blank cells in range:
ActiveWorkbook Range("A1:l34").End(xlDown).Row.Copy
Application.ScreenUpdating = False
Application.DisplayAlerts = False
'Paste values into first blank row:
            Workbooks.Open ("C:\Users\KahanI\Desktop\Sales Tool\DO STUFF\MASTER CONTROL.xlsx")
            Sheets("2011_Summary").Select
                Range("A1").Select
                Selection.End(xlDown).Select
                ActiveCell.Offset(1, 0).Select
                Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
                :=False, Transpose:=False
            
            'Workbooks("MASTER CONTROL.xlsx").Save
            'Workbooks("MASTER CONTROL.xlsx").Close
Application.DisplayAlerts = True
Application.ScreenUpdating = True