Copy from a form to anouther sheet

Hello,

I'm probaly going to confuse everyone with this as it is confusing me I havn't made a what is to me a complecated spread sheet in a long time.

What I'm trying to do is set up a Marco that a user will activate by pressing a botton, this Macro will copy data from a data entry sheet that I have created into a table onto a new row.

For example:

Copy from sheet 1 cells C5, C9, B22, D22, F22, B27, D27, F27, C33, E33 Ect

to Sheet 2 into cells A-Q* (*=new row number)

So far I created a simple Macro that indiduly copyed the data from the cells to there new locations, then clears the contents from the old cells.

Can you please help me with this I just can't figure it out.

Regards

RMHarrison

So what is the issue you are facing with the code that you created? You can post it here.

You didnt give me all the cell references, but i guess you can add them in.

Please Login or Register  to view this content.

Put this code in a standard module.