Hello,

It would be great if you can please let me know if this is possible by
preparing macro. Appreciate your reply.

Best Regards,
Kam.

"Kam" wrote:

Hi,

Thank you very much for your reply but in our organisation we don't have
Excel 2007. We are still using 2003 therefore there is any possibilites of
preparing excel based macro to populate table from Data based on Customer
Code as I mentioned earlier..

Best Regards,
kam.

"Herbert Seidenberg" wrote:

Excel 2007 (only)
Here is an example with this type of data structure.
Populate with your data, modify and/or
upload your file he
http://www.mediafire.com/file/wygjmtwmxmj/07_28_09.xlsx
.