Hi,
I have a spreadsheet which is linked to another spreadsheet with raw data input in one tab (TAB 1).
In my main tab (TAB 2) I have used the raw data to perform a variety of checks and conditional formating to make life a bit easier.
My issue is that if I refresh the external source, my main tab gets #ref error, when there is a mismatch between number of rows before/after refresh.
I would like to copy all formulas from row 3 to row nth in my main tab, based on the number of rows in my input data tab.
So for instance, if my input data tab, tab 1 contains 3000 rows of data, I want to automatically or semiautomatically copy the formulas from row 3 to row 3003.
I guess a macro would be the best option for this?
It could very well be a button you can press to run the macro, but the important thing I guess is how would this look like in VBA?
Bookmarks