I have recorded a macro where I have taking certain data from one sheet and formatting it in a different format on another sheet. I used the "select current region" to select the data to be transferred to the second sheet(For example A1:H200). When I update the original data sheet the and the macro only picks up the range A1:H200 when in fact I want the macro to pick up the extra data. (The range will constantly change). How do I modify the macro so that it will pick up all the relevant data automatically.
Thanks
Thanks