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.

maybe something like this. just substitute the sheetname and the column you
need. i used sheet1 and column B in this example
this would sum everything from B2 to the last row in column B and put the
total in the next row.


Sub test()
lastrow = Worksheets("Sheet1").Cells(Rows.Count, "B").End(xlUp).Row

Range("B" & lastrow + 1).Formula = "=sum(B2:B" & lastrow & ")"

End Sub


--


Gary


"Alex Martinez" wrote in message
...

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.