PDA

View Full Version : Solved: Transferring Data from a Table



haddy27
11-07-2007, 09:41 AM
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
11-07-2007, 10:01 AM
try using the macro recorder and go from there

rory
11-07-2007, 10:42 AM
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
11-07-2007, 10:47 AM
Hey Rory......I thought we were supposed to be answering questions..:devil2:

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

rory
11-07-2007, 10:50 AM
I think it's only fair someone should answer my questions from time to time! :)

unmarkedhelicopter
11-07-2007, 11:15 AM
Is there a God ?
And what was he doing on the night of Wednesday last ???

rory
11-07-2007, 01:21 PM
If He was with me, I bet He felt awful on Thursday...

rory
11-08-2007, 09:17 AM
PS Were you following me?

unmarkedhelicopter
11-08-2007, 10:31 AM
No, ... but a man from the Inland Revenue was ...