Solved: Transferring Data from a Table

[haddy27]

I am looking to write some code that transfers data from a table into the same spreadsheet over and over.E.g. one line of data in the table (Row 1), each cell (A1,B1,C1 etc) needs to be copied into specific cells in the other spreadsheet, so A1 will always be transferred into D7, B1 into D12 etc.I have a table of data around 300 rows long, so I am looking to go through the data table row by row transferring the data into a single spreadsheet, save that and move onto the next row.Any help would be greatly appreciated!Thanks

[unmarkedhelicopter]

try using the macro recorder and go from there

[rory]

Is the data going into existing sheets or are you creating them for each row?
Are the sheets in the same workbook?
Are the target cells the same for each row of data from your table?

[lucas]

Hey Rory......I thought we were supposed to be answering questions..

Sometimes it Seems like we should be able to see over thier shoulder huh?

[rory]

I think it's only fair someone should answer my questions from time to time!

[unmarkedhelicopter]

Is there a God ?
And what was he doing on the night of Wednesday last ???

[rory]

If He was with me, I bet He felt awful on Thursday...

[rory]

PS Were you following me?

[unmarkedhelicopter]

No, ... but a man from the Inland Revenue was ...