copy from worksheet in another worksheet with rule

**iscar_marius** · 07-13-2009, 07:53 AM

I have 2 worksheets : "version" and "final".
In final worksheet, I have in column H starting with H2 some cells with text. I can have until 99 cells.

I need to copy this cells into "version" worksheet, in row 3 starting with range D3 and 3 rows to the right ...

"final" worksheet........................................."version" worksheet
data from range H2.......................................data to range D3
data from range H3.......................................data to range G3
data from range H4.......................................data to range J3
etc...............................................................etc.

I need to do this automatically, can you help me with code ?
I attached an excel file to this post.

**StephenR** · 07-13-2009, 07:57 AM

Like so?

Please Login or Register  to view this content.

**iscar_marius** · 07-13-2009, 08:06 AM

This is exactly what I need

Thanks a lot!

**iscar_marius** · 07-13-2009, 08:42 AM

I have some problem with this code

If I have only one cell with data ( H2 from final worhsheet) , I have an error.
Please open new attached file.

the error is from this line:

Please Login or Register  to view this content.

**StephenR** · 07-13-2009, 08:44 AM

Change the previous line to:

Please Login or Register  to view this content.

**iscar_marius** · 07-13-2009, 09:11 AM

Thank you!

**StephenR** · 07-13-2009, 09:15 AM

You're welcome.

**zacky** · 12-21-2009, 06:06 AM

can somebody explain how this code works? because i need something like this but much simpler. meaning even though mine is from a different worksheet, once i input a data from sheet1:A2, it will automatically updated on sheet2:A2, its just that mine has more data vertically.

thanks in advance