I am trying to record a few macros but i am finding that because the data has
variables in it i.e. things that change (column/row number, sheet no etc) the
macro stops working. it is unable to apply itself to a number of different
situations and adjust accordingly, for example, where the column number
changes or the number of rows etc. How can i code the macro to allow for many
different variables?

thanks.