I need to automate the creation of a pivot table from a csv file. I
create the pivot table once a week, and the number of records in the
csv file increases each time. I have not had much success in creating a
macro that includes a statement to go to the end of the data to
accomodate the increased number of rows. Can anyone assist with the
correct vba statement?


--
johnson748r
------------------------------------------------------------------------
johnson748r's Profile: http://www.excelforum.com/member.php...o&userid=37093
View this thread: http://www.excelforum.com/showthread...hreadid=569689

Here is one good way to find the last row with data in it:
LastRow = Cells.Find(What:="*", After:=[A1], _
SearchOrder:=xlByRows, _
SearchDirection:=xlPrevious).Row

HTH

Charles_Chickering
"johnson748r"
wrote in message
...

I need to automate the creation of a pivot table from a csv file. I
create the pivot table once a week, and the number of records in the
csv file increases each time. I have not had much success in creating a
macro that includes a statement to go to the end of the data to
accomodate the increased number of rows. Can anyone assist with the
correct vba statement?


--
johnson748r
------------------------------------------------------------------------
johnson748r's Profile:
http://www.excelforum.com/member.php...o&userid=37093
View this thread: http://www.excelforum.com/showthread...hreadid=569689