I have a series of datasets that are of differing lengths and would like to apply a formula to a neighbouring column.

If i record a macro then the pasted formula is automatically pasted to the length of the column in the dataset within the original spreadsheet within which i recorded the macro.

How do i customise this macro so that it only applies the formula in B:x if there is data within A:x?

Thanks in advance :-)