I'll start by saying I'm a novice and I am using Excel 2000 to do what I thought was a simple function, so I thought. There are two sheets involved here, a Invoice sheet and a School 1 sheet. The purpose of my macro is to copy four various cells from the Invoice sheet to a row in the School 1 sheet, the next time I run the macro it copies those four to the next row and so on..
My issue has been that I need to start the row on row 13, trying not to be superstitious here. The macro will copy to the correct row and cells for the first 3 cells but for the final cell it wants to copy to a cell way down the page. It acts as if the cell is unavailable, I have checked and recheck to make sure target cell empty. What could be preventing the macro to copy? Is there a better way to do this, like I said I'm a novice. Any suggestions would be much appreciated, thank you.
This is my macro: