Hello,

I am using Excel 2002 and I am wondering if this is possible. I get a daily
report from our main frame exporting data in Excel. What I want to do is
have a macro button that will put the month ending data on the last column.
Now I may get about 200 rows of data or 300 rows of data depending upon the
months activity. For example I will have a dialog box pop up after I press
the macro button requesting what is the month end (10/31/2005) then on the
last rows will show 10/31/2005 depending upon the size of the data exported.
Is this possible? Thank you in advance.