Structured Table References Problem

Use INDIRECT. Something like...

Formula:

Please Login or Register  to view this content.

I presume in your copy/paste you are selecting all the data and headers from your 2nd screenshot and pasting over the whole table in screenshot 1/3 including headers. In that case no, you are changing the headers. It would be like if your name is "Jim" and I took your seat and paced another "Jim" in it...same name, not the same as it was before.

There are a few ways to handle this.

• Copy 1 column of values from screen 2 to the proper column in the table under its header (not pasting over the header).
• Reorder the columns you are copying from (screen 2) so they are in the same order as the table, then past either data only or data and headers
• Reorder the table in screen 1/3 to match column order in screen 2, then paste either data or data and headers.
• (situational) fill your table with formulas to pull in data from the range in screen 2 so data is in the correct column
• (situational) write a macro that basically does one of the first 3 points for you

EDIT: the indirect proposed may work as long as the copied/pasted headers are only changing order in the table and not changing entirely (IE: if "Country" moves from column 1 to 3, fine, but if "Country" is replaced by "Origin" then INDIRECT wont solve the issue)

EDIT2: you may be able to get away with turning manual calc on, doing the copy/paste, then turning calc back on.