Copy data from another but Row formulas should not be changed

[AnilKumar141]

Hi,

I have created a file where daily data will be updated with new data. (Both are same format with same # rows & columns)
As per the below screen shot, highlighted rows are formula.
Can I replace the new data in this file without changing the formula rows.
Both files having same # of rows.

If i copy the data , only rows with out formula to be changed .Can it be done?

 

[Kaper]

Hi, I hope you can use macros.
Such one shall do the job very quickly.
You shall have both files open (is new datatable in a separate workbook? I assumed it is), and file with data to be replaced active.
I also assumed your tables starts with cell A1, and that workbook with new data has has only one worksheet (or data is on first worksheet).

If you are not familiar with macros read this first: How to create, change, copy and delete VBA macros in Excel - especially part "Write or insert code in the VBA Editor"

Sub test()
Dim tarr As Variant, sarr As Variant, i As Long, j As Long, lr As Long, lc As Long
lr = Range("A1").End(xlDown).Row
lc = Range("A1").End(xlToRight).Column
tarr = Range("A1").Resize(lr, lc).Formula
sarr = Workbooks("new_file.xlsx").Sheets(1).Range("A1").Resize(lr, lc).Formula
For i = 1 To lr
  For j = 1 To lc
    If Left(tarr(i, j), 1) <> "=" Then tarr(i, j) = sarr(i, j)
Next j, i
Range("A1").Resize(lr, lc).Formula = tarr
End Sub