Data automatically update from 1 sheet to another Sheet. (1 Viewer)

NurulScare

Member
Local time
Today, 17:22
Joined
Jan 6, 2021
Messages
31
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

Well-known member
Local time
Today, 05:22
Joined
Apr 9, 2015
Messages
4,339
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

Member
Local time
Today, 17:22
Joined
Jan 6, 2021
Messages
31
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

..forever waiting... waiting for jellybean!
Local time
Today, 17:22
Joined
May 7, 2009
Messages
19,170
create a Table from your "sheet" and use Power Query to
create an "updated" table.
You only need to Refresh the "updated" table.
 

NurulScare

Member
Local time
Today, 17:22
Joined
Jan 6, 2021
Messages
31
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

..forever waiting... waiting for jellybean!
Local time
Today, 17:22
Joined
May 7, 2009
Messages
19,170
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

Member
Local time
Today, 17:22
Joined
Jan 6, 2021
Messages
31
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

Lifelong Learner
Local time
Today, 02:22
Joined
Mar 14, 2017
Messages
8,738
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
 

Users who are viewing this thread

Top Bottom