Hello,
I have a table on worksheet 1 that dynamically copies and pastes to worksheet 2. On worksheet 2 the table is sorted using a vba code and does it automatically when the page is activated.
I want to take the sorted table on worksheet 2 and copy it to a different worksheet (worksheet 3) and add a column to the table from a separate single column table also on worksheet 2 in column N.
The problem I am running into is the table will copy and paste from worksheet 2 and the new column will add but the moment I go to worksheet 1 and then to worksheet 2, the data changes and will no longer dynamically update on worksheet 3 because excel creates a new table number for the table on worksheet 2 every time I activate worksheet 1 and worksheet 2.
Any suggestions?
I have a table on worksheet 1 that dynamically copies and pastes to worksheet 2. On worksheet 2 the table is sorted using a vba code and does it automatically when the page is activated.
I want to take the sorted table on worksheet 2 and copy it to a different worksheet (worksheet 3) and add a column to the table from a separate single column table also on worksheet 2 in column N.
The problem I am running into is the table will copy and paste from worksheet 2 and the new column will add but the moment I go to worksheet 1 and then to worksheet 2, the data changes and will no longer dynamically update on worksheet 3 because excel creates a new table number for the table on worksheet 2 every time I activate worksheet 1 and worksheet 2.
Any suggestions?
