Working on last populated column

You can approach this type of thing a number of ways... one might be:

Please Login or Register  to view this content.

but it all rather depends on setup etc...use of UsedRange for ex. is open to error and is not therefore always the best best approach
you might opt for an End(xlToLeft) type approach instead but again that depends on specifics of layout which we're not privvy to

edit:
for a robust approach for establishing last known values etc see: http://www.rondebruin.nl/last.htm

Originally Posted by mgcf

Not sure what that code does

If in doubt test... step through with F8
the above code takes the last column of the used range [used rows] and pastes to next column - then applying a values over current content [should it be formulae etc...]

Originally Posted by mgcf

...what if I only want to use a certain number of rows?

If you want help with specifics post a sample file to better illustrate requirements.

OK so assuming formulae should persist in "new" column with prior column being "static", adapting earlier example slightly:

Please Login or Register  to view this content.

the above is just a basic proof of concept

For the dates and consistency it would be simplest to use a formula, eg:

Please Login or Register  to view this content.

For the column references - yes you would remove the $ preceding the reference to G however you would also want to adjust such that the col_index_num incremented also... so:

Please Login or Register  to view this content.

though you could just as easily use an INDEX/MATCH construct

However, what I would suggest [based on the example file] is that given you're returning numerics a SUMIF would be far more straightforward:

Please Login or Register  to view this content.

note in all of the above the hardwired reference to "cat", "dog" etc is replaced by a simple relative cell reference such that you can apply the same formula to all rows without need for modification.

If the "current" column contains the formula suggested previously [should refer to row 2 not 3 - F2: =E2+1] then when the code is run to generate a new "current" column that formula reference will adjust given use of relative references.

It might be worth reading up on relative/absolute/mixed referencing.