Keeping Appended Data In Sync After Data Connection Refresh

schnide

New Member
Joined
Feb 14, 2008
Messages
24
I have a table with two columns in Excel:

AB
1United KingdomLondon
2United States of AmericaWashington DC
3FranceParis
4SpainMadrid
5JapanTokyo

<tbody>
</tbody>

Column A is populated by an external data connection from a CSV file. Column B is data that I then manually append with metadata, directly in Excel.

This is all fine until additional data is added to the CSV file. When I refresh the data in Excel, it pushes down column A only and so column B becomes out of sync:

AB
1United KingdomLondon
2United States of AmericaWashington DC
3ItalyParis
4FranceMadrid
5SpainTokyo
6Japan

<tbody>
</tbody>

..and of course the metadata is wrong.

Can anyone suggest a way to setup the sheet so that column B will dynamically push down when new rows are added, like so?

AB
1United KingdomLondon
2United States of AmericaWashington DC
3Italy
4FranceParis
5SpainMadrid
6JapanTokyo

<tbody>
</tbody>

..so that I can continue to add the metadata and keep it synced up? My guess is that there probably isn't a way since Excel wouldn't know how to handle a row being removed if an entry present in the CSV file was no longer there on a subsequent refresh.

However, all thoughts welcome (and appreciated as always)!
 
Last edited:

Forum statistics

Threads
1,082,641
Messages
5,366,713
Members
400,915
Latest member
NFlem

Some videos you may like

This Week's Hot Topics

Top