Data automatically update from 1 sheet to another Sheet.

[NurulScare]

Hi guys!

I have 1 sheet linked from external source but the data is real time (Sheet A). So, I want the data to auto copy (update) to another sheet (Sheet B) to keep the data by date. and the data in Sheet B will continue auto update every time Sheet A refresh. means data will continuous update by date in 1 sheet. How can I do that? by vba or micro?

Thank you in advance guys!

 

[Ranman256]

if you mean copy sheetB from source book, and replace it to sheetB in target book,
then record a macro,
delete target sheetB
copy source sheetB
paste to target book
end macro.

 

[NurulScare]

if you mean copy sheetB from source book, and replace it to sheetB in target book,
then record a macro,
delete target sheetB
copy source sheetB
paste to target book
end macro.

less more like that. may I know how?

 

[arnelgp]

create a Table from your "sheet" and use Power Query to
create an "updated" table.
You only need to Refresh the "updated" table.

 

[NurulScare]

create a Table from your "sheet" and use Power Query to
create an "updated" table.
You only need to Refresh the "updated" table.

Thanks. but my "Sheet" is real time since I linked from access. means every time update in access data will overwrite. so I want to copy paste value to another sheet as for record.

 

[arnelgp]

like i said you do not Need to copy paste if you use PowerQuery.
whatever you delete row, add new rows, modify rows, it will be reflected
immediately to the "updated" table.

the catch is you need to translate the sheet into Table.

 

[NurulScare]

like i said you do not Need to copy paste if you use PowerQuery.
whatever you delete row, add new rows, modify rows, it will be reflected
immediately to the "updated" table.

the catch is you need to translate the sheet into Table.

yes, I did it. but every time refresh updated table will overwrite as well. I want the old data remain. when refresh only add new data.

 

[Isaac]

just paste links on sheet2, and autofill to far below what you need - the blanks will show zeros, and slowly fill as sheet1 gets more data