Hi Doc,
I am not sure you really need to know what has been added, but you do need to know what the last "Data" entry row is. Knowing the last row you can copy from A2:B2 down to the last row, overwriting the existing formulas would not matter, I assume.
Range(A2:B2).copy
Range Paste (A & LastRow: B & LastRow)
Would that work? You can find last row GoTo Special LastCell.
Thanks,
David
________________________________
From: Doc <dcorio@zitomedia.net>
To: ExcelVBA@yahoogroups.com
Sent: Saturday, April 14, 2012 1:58 PM
Subject: [ExcelVBA] Request for Guidance
Greetings to the group from a new member! Name is Doc in north-central PA.
It's been a long time and several versions since I worked with VBA, and I'm finding myself a little lost. Okay - a LOT lost!
I don't want someone to just write this for me - I would like a little help steering in the right direction.
In Excel 2007 I have a data sheet consisting of several thousand lines of data from a database. The first two columns (A & B) are formulas that determine items from the rows of data. Column C is empty. When the data is refreshed, there may be anywhere from 1 to 25 new rows of data added.
The VBA I've been trying (and failing) to work would do the following:
Determine how many new rows of data were added (data starts in column D)
and
copy the formulas from the last existing cells A & B to the new rows.
Very much appreciate any help with this
Thanks!
Doc
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar