[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

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 6

Visit Your Group

----------------------------------
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

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___