Got a sheet where a got several columns of data all cells in column A contains data but in for example column F there is blanks.
The problem I encounter is when I want to autofill column Fand also copy entire column. Because the range varies I need a formula that counts the rows in column A and then copies that range from column F
How should I modify this code string so it copies the number of rows depending on how many there is in column A ?
And how do I modify the autofill formula so it does the same?
I know this is pretty much n00b questions and the answers I found before I had a hard time modifying.
Thanks !
Bookmarks