Hi All
I have a range of data, say A2 to A1000. This range will always start from A2 but can end before A1000 or indeed after it as the spreadsheet refreshes from an external source.
I need automate and be able to copy a formula from the contents of cell B2 all the way down and adjacent to where the last cell is populated in column A.
many thanks
pukks