Hi, i'm a noobie with macros but I need help with the following.
Excel 2010
2 reports, both opened in the same instance of excel
I add information including formulas into workbook 1
I add information and formulas into workbook 2 including adding additional columns to match columns in workbook 1
The trouble I have is when I copy the table from workbook 2 into a position below the table on workbook 1, manually it works fine... but the macro I have been recording will not do it, often giving different results (but generally leaving some information out or the whole sheet can be blank).
I've tried looking this up to find the answer but nothing has helped. Can anybody help please?
Excel 2010
2 reports, both opened in the same instance of excel
I add information including formulas into workbook 1
I add information and formulas into workbook 2 including adding additional columns to match columns in workbook 1
The trouble I have is when I copy the table from workbook 2 into a position below the table on workbook 1, manually it works fine... but the macro I have been recording will not do it, often giving different results (but generally leaving some information out or the whole sheet can be blank).
I've tried looking this up to find the answer but nothing has helped. Can anybody help please?