Sorry for not being very clear. The data has to do with equipment that we use in our building. So whenever we have a computer that comes into us and we swap the hard drives from one computer (one record in the equipment table) to another computer (another record in the equipment table), we want a script that will circumvent having to copy and paste each value from each field from one record to the other. And the only way we can figure that we do this is to copy the information onto a seperate table, a holding table, then copy the fields from record B over to A, then from the holding table, paste the fields from the holding table to record B.
Essentially, its not really pasting from one layout to another, I'm trying to get the information in one record and copy it over to another record on a separate table.