Saving output to another Excel spreadsheet (Excel 2010)

[Apache_sim]

I use a bespoke program which generates an excel report one week or one month at a time (not anually).
From the report produced I have written some code to extract the number of times a session is booked but not used and to identify how many days sessions were run from teh avialbe working days in that month. The output I am then manually copying to another spreadsheet to capture the anualised data. Will VBA allow me to open another spreadsheet, find the next empty row and paste the data, save and close teh document?
If so I wopuld appreciate a steer.
Regards
M

[JOHN H. DAVIS]

Can you share your code with us?

[russc2541]

copy what you need then add

Please Login or Register  to view this content.

manipulate, format, paste, etc then

Please Login or Register  to view this content.

for more detail, include a sample of your data in a spreadsheet attached to your post. once we see what you have and what you want, we can give more detail about how to get there.

[Apache_sim]

I hope I have got this correct.
The attached file is an example of the repoert produced via a third party software package.
The VBA produces the sessions that were not booked or booked but not used where the start times are 08:00, 09:15 etc.
I would like to extend the VBA to copy this data to another workbook. so that each time I run this report the outpu goes onto a new row in the other workbook.
I hope that makes sense.

Thanks
M

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

I added code to your original to copy to a workbook I created called Other Workbook.xls Sheets("Sheet1"). Hope that helps.