Dear Expert,
I need to add a new column in the spreadsheet as days goes by. Add column in
one day and old data keeps moving to right...
That's, calendar date in column A and new data in Column B and old data
(from Column C) keeps moving from left to right for each working days on and
on.
Excel column can go up to max 255 (around, exact max columns I can't recall).
End column is IV ?? (Anyway, it doesn't matter).
If data hits column IR, I need to do a back-up to save the old data from
column A to column IR.
Can I set a Function (Alert) in Column IS (few columns ahead of IV and one
column later than IR) if data keeps moving to left till hitting the column IR
so that it can run a macro to pop up a msgbox to alert me to back up old data
please ?
If it is blank in IR, function (alert) in IS and thus macro would not be
triggered.
Thanks so much.