Add Unique Values from each column on one Sheet to Another Database sheet

Hello,

I need a macro that will logically add the new data from Sheet("Summary") to my Sheet(database_ST").

Summary Sheet:
Summary.PNG

Each Column in Sheet("Summary") will have its own uniquie identifier, which matches with Row 1 on other Sheet("database_ST"), however the data may change - meaning that more Columns can get added (i.e. Stock_XXX a new one can appear) or some removed, and the order in which they apear can change, or the random spacing between the columns at some points may appear in different spots... also more rows of Data might be added if the User changes the Lookback period and as we move into new days.

I need a macro that will dynamically go through each colomn in Summary, if the Unique Identifier (row 6) is not in Database_ST, then add it and all of its data, and if the unique identifier is already in the database, add all new dates and it's data.

Database Sheet:
db.PNG
Restriction: If Summary Sheet Cell A2 = "don't add today" then macro won't add today's data. it leaves it as is these will likely be formulas linking to an API streaming today's data.

Is this possible? any help would be really appreciated.

Thank you for your time.

Not sure I get this right.
Maybe try

Please Login or Register  to view this content.