Macro Copying Rows That Change Dynamically
I'm writing a macro for Excel that will copy large ranges of data and paste
into a new worksheet preserving the historical data. The number of rows to
copy changes dynamically on almost a daily basis.
Is there a function that can be written into a macro to change the range
selectiion each time new data is available. Each row is a transaction record.
|