Thread
:
Macro Copying Rows That Change Dynamically
View Single Post
#
2
Posted to microsoft.public.excel.programming
Gord Dibben
external usenet poster
Posts: 22,906
Macro Copying Rows That Change Dynamically
See Ron de Bruin's site
http://www.rondebruin.nl/tips.htm
Browse through the section on Copy/Paste/Merge examples
Gord Dibben MS Excel MVP
On Fri, 28 Sep 2007 10:07:01 -0700, Bill Lowry <Bill
wrote:
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.
Reply With Quote
Gord Dibben
View Public Profile
Find all posts by Gord Dibben