Copying data range from a variablew workbook to static workbook

[singhpab]

i am new to excel and also to Excel forum.
i need to update data for a similar set of cells of one workbook from a similar set of cells from another workbook, on a monthly basis. could someone please help me with a simple macro.
Thanks and help much appreciated in advance.

-Singhpab

[akhileshgs]

Have a look at this post. Is this enough for you?

[singhpab]

Thanks for the reply. but i was looking for sometime which copies data from a additional month's tab of a statically formatted workbook to another statically formatted workbook (with only one tab). here we can say it is a data update for different tables. the range of the table does not change any time.
Thanks again for your help on this.

[akhileshgs]

How about this?

Sub openAndCopy() 
    Dim wbCopy As Workbook 
    Dim wsCopy As Worksheet 
    Dim rngCopy As Range 
    Dim wbPaste As Workbook 
    Dim wsPaste As Worksheet 
    Dim rngPaste As Range 
     
    Set wbCopy = Workbooks.Open(ThisWorkbook.Path & "\Source_Workbook.xlsx")    'change path 
    Set wsCopy = wbCopy.Worksheets("Source Tab Name") 
    Set rngCopy = wsCopy.Range("a:av").EntireColumn    
    Set wbPaste = Workbooks("Destination Workbook.xlsm") 
    Set wsPaste = wbPaste.Worksheets("Destination tab name")  'paste to different sheet? 
    Set rngPaste = wsPaste.Range("a1")  'change this if needed 
     
    rngCopy.Copy 
    rngPaste.PasteSpecial xlPasteValues 
    Application.CutCopyMode = False 
    Workbooks("Source_Workbook.xlsx").Close SaveChanges:=False 
     
 
 
End Sub  

[singhpab]

Thanks Aki Bhai , but request you to help me in understanding this. As when i gave the path with the complete book name it throwed an error 424 on me.