I am using a macro to carry out a repeated task which includes copying a
selection of data into a separate worksheet . I then want to create a
formula with the copied data to create further info in another column.
However, how can I tell excel to copy the formula into all the rows which
hold the records, but only for those rows that do hold records. The number of
records copied into the worksheet can vary each time and I only want the
formula replicated in the rows of copied data. Hope this makes sense. Can
this be done and how do I do this?