Macro erases data inputted

Hi,

I am hoping someone can help me with a quick fix. This macro takes data from one sheet and pastes it into another sheet. Columns B, C and D are all populated from another sheet. I need to enter data in columns E and F with the ability to run the macro and not lose the data inputted in E and F.

To put it simply, I need this macro to run repeatedly without affecting columns E and F.

Thank you in advance.

Please Login or Register  to view this content.

I think this line:

Please Login or Register  to view this content.

is your problem.

The delete method is the same as right clicking the cells and selecting delete, which then gives you the option to shift up/down/left/right. I think by default your code will chose to shift cells left, so columns E and F become columns A and B which are then overwritten in the rest of your code. Try using:

Please Login or Register  to view this content.

instead.