Export to Another Workbook????

[Guest]

How can I take rows from one workbook and append them to another workbook? Example: I enter mileage for service calls during the week(There could be 5 calls or 50 calls (rows of data)) on a weekly expense spreadsheet. There are numerous calculation performed on this spreadsheet. I would like to take the names, addressess and dates of service calls and place them into another workbook for history purpose. There are many different individuals filling out these service call expense spreadsheets and most aren't capable of copying and pasting the data. Can this be done with a macro? Please note....there is normally not that same amount of rows needed to be copied from the weekly expense spreadsheet. Also, the individuals who complete these expense sheets to do even save them.....they just fill them out and print them and then submitt them to accounting.

 

[Don Guillett]

something like
x=worksheets("history").cells(rows.count,"a").end(xlup).row+1
activecell.entirerow.copy _
worksheets("history").cells(x,1)

--
Don Guillett
SalesAid Software
(e-mail address removed)

How can I take rows from one workbook and append them to another workbook?

Example: I enter mileage for service calls during the week(There could be 5
calls or 50 calls (rows of data)) on a weekly expense spreadsheet. There are
numerous calculation performed on this spreadsheet. I would like to take the
names, addressess and dates of service calls and place them into another
workbook for history purpose. There are many different individuals filling
out these service call expense spreadsheets and most aren't capable of
copying and pasting the data. Can this be done with a macro? Please
note....there is normally not that same amount of rows needed to be copied
from the weekly expense spreadsheet. Also, the individuals who complete
these expense sheets to do even save them.....they just fill them out and
print them and then submitt them to accounting.