I have a workbook with different spreadsheets. The Base Sheet has all the information and other spreadsheets within the workbook are linked to the Base Sheet.
I need to have a VBA code that allows me to add a new row by running a macro.
And also when I add data to the newly added row, it automatically does a dynamic update in other spreadsheets which are linked to the Base Sheet, where I have added the new row and the data.
Can someone please help me get this going...I am almost going to pull all my hair out!
I need to have a VBA code that allows me to add a new row by running a macro.
And also when I add data to the newly added row, it automatically does a dynamic update in other spreadsheets which are linked to the Base Sheet, where I have added the new row and the data.
Can someone please help me get this going...I am almost going to pull all my hair out!
