Record data from one worksheet to another based on conditions

[sgp]

Hi all

I have macro button that records the data from one worksheet into another. My coding is in a total mess right now! I have the following worksheets:

1 - Input - The information is entered in the template

2 - View - The information is copied through from a macro button based on the order id and Category - I have attached an example which may not make sense but may give the idea to what i'm trying to achieve.

Thanks.

[Bob Phillips]

Please Login or Register  to view this content.

Haven't we already done this one?

[arlu1201]

Should the data be copied to columns E, F & G of your View tab?

[sgp]

Thanks Bob Phillips!

I did do something similar to this but it was through userforms.

[sgp]

Just a quick one - is there a way to inform the user that the data has been transfered? i.e. msgbox

Regards.

[Bob Phillips]

Please Login or Register  to view this content.

[Marcol]

Never saw the replies, I'll post it for what it's worth.
Here's another way
Run this with your button

Please Login or Register  to view this content.