two spreadsheets, how do I copie information from one to another.

I have two spread sheets, one uses a macro to move rowes to an archive file. The other spreadsheet is set up for job costing information.
The rows that get archived in the first spreadsheet have some information that I would like to copy to the costing spreadsheet. ie: work order number, descriotion, date issued and date closed.
Is ther a way to do this through a formula?
If so can you show me an example?

Thanks

Matt

Why not incorporate it into the current macro?

Please Login or Register  to view this content.

Do I have to attache the June Spreadsheet to Reised test run? or just have the two open?

I just tested it with them both opened. If you want to incorporate the June spreadsheet then the code will have too be changed to reflect that.

I tried the code, but it would not work for me.

What did not work? How did you run it. Note the name change. Were both workbooks open?

Yes both were open.
I copied the code and pasted to the macro
Runtime error "9" I think

Which line is highlighted?

runtime error 9
subscrip out of range

Run the code from the VBE. When it errors, which line is highlighted?

ActiveSheet.Cells(ActiveCell.Row, 2).Copy Workbooks("June[1].xls").Sheets("Sheet1").Range("A" & Rows.Count).End(3)(2)

On testing I can't reproduce the error. On your sample files Workbook June[1] has a Sheet1. Does the current one have a Sheet1? Is June[1] an xls or xlsx? That might be the reason.

it's June.xls not June [1].xls

Does it work when you change the June[1] to June in the code?