Please help...I need an excel macro that will do the following:
For example, I have Column A (contains the word “ADD” repeating),
Column B(alphanumeric id), all filled with data. The data ends in each
of these columns at row x. Column C will contain a number series based
on the date and ends at row y < x. I would like a macro that finds
where Column C ends, and after the last cell in Column C begins
filling it in with a series starting at z, but the series will be
formatted as follows: <current week’s Monday date in yyyy-mm-dd
format> TEXT-# For example, 2011-11-14 TEXT-0.
By the way, I know there is a non-macro way of doing it, but I need
this to be in a macro.
I have a link Google docs link below to a sample with the before macro
and after macro tabs so show what it is I am looking for.