don't replace VBA code

[willelas]

Hi, i have the following code:

Please Login or Register  to view this content.

This code moves some information from sheet2 to sheet3. And then makes a break, so other members also can create their own member.

But my problem is, when one member registrates. The other gets HIS information in their fields. How do i avoid this?

I think this is because of the formula i'm using on sheet2, that i later on move
that formula to sheet3. Because then it's the same and everyone gets that info.

This is one of the formula that is moved: =Sheet2!G18

So how do i avoid this, and is there a smart method to avoid that other members ar affected by anothers information and that they do not have to get his/her info in their fields.

[royUK]

Your code needs some serious tidying up. Try amending your code like this for a more efficient way

Please Login or Register  to view this content.

[BigBas]

I agree with Roy 100%

The macro recorder is a great tool if you need to remember how to do something you have forgotten (ie, how to color a cell, how to delete a row). It is VERY inefficient for creating a functional VBA driven spreadsheet. I suggest looking into some VBA tutorials and chopping that down a bit, then asking more specific questions.

Another option is to post a .zip copy of the workbook you are working with. Provide some specific instructions and someone will likely be able to piece together some code for you.