MACRO HELP

[HAWKS2002]

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

 

[Richie(UK)]

Hi HAWKS2002,

Welcome to the board.

Is the data that you are transferring from sheet1 to sheet2 the only data on the sheet? If so, consider using the 'UsedRange' property rather than a specified range such as A1:H200.

HTH