Enter data from input sheet into panel data sheet

[lazybone]

In the example, I have a purchase order that a customer can order multiple products with just ONE PO number. Now I need a macro to input this data into a paneled database on another sheet. I could only get my macro to copy a signal row of data, but could not figure out how to repeatedly copy the PO number, and customer info. please help!

[Kaper]

Please Login or Register  to view this content.

Check out such prcedure (you could assign it to your rectangle).

in the code above I used asigning, not copying, but of course instead of

Please Login or Register  to view this content.

one could use

Please Login or Register  to view this content.

etc.


By the way - in this database you have redundant data - may be it is worth redesigning? (fir instance doubling PO and both Customer Name and Customer Number).

[Trebor76]

Here's my attempt:

Please Login or Register  to view this content.

Regards,

Robert