I have two sets of data which contain some (43) columns in common.
I would like to refresh the shared columns in dataset 1 with dataset 2 (as dataset 2 will be updated daily)
I'd like to be able to do this by clicking a 'refresh' button in dataset 1 which then has it's data refreshed by using dataset 2.
Column A in both datasets is a unique ID. Lets say there are 9 ID's in both as of yesterday (there are hundreds, but this is an example) 1,2,3,4,5,6,7,8.9
If dataset 2 now contains ID # 10,11 and 12 when refresh button is clicked, these rows will need to be added to the bottom of datasheet 1. ID's 1-9 will need to still be refreshed.
Do the columns need to be in the same order in both datasets for a refresh to work, or can we just look for column names and match, regardless of the order?
Thanks in advance and if any more info is required please ask
I would like to refresh the shared columns in dataset 1 with dataset 2 (as dataset 2 will be updated daily)
I'd like to be able to do this by clicking a 'refresh' button in dataset 1 which then has it's data refreshed by using dataset 2.
Column A in both datasets is a unique ID. Lets say there are 9 ID's in both as of yesterday (there are hundreds, but this is an example) 1,2,3,4,5,6,7,8.9
If dataset 2 now contains ID # 10,11 and 12 when refresh button is clicked, these rows will need to be added to the bottom of datasheet 1. ID's 1-9 will need to still be refreshed.
Do the columns need to be in the same order in both datasets for a refresh to work, or can we just look for column names and match, regardless of the order?
Thanks in advance and if any more info is required please ask
