Excel Macro to Populate table from Data

K

Kam

Hi,

First of all thanks a ton for all help in the past. I need again help on
some excel macro, which can Populate table from Data for selected customer
codes.

I have one huge excel database, which includes lot of data in columinar
form. Under excel worksheet called "CSOP" I have data of similar nature as
per below but I can't paste in here as don't have enough space therefore I
have given small example. In this worksheet data starts from Column A & Ends
in Column Z.

Column A Column B ColumnC Column D
Customer Code Cus Name Charge Type Charge Desc
130LPL13025 ASDA ALL All Collect Charges
IHI Inland Haulage
Import
BAS Basic Ocean
Freight
CAF Curreny
Adjustment Factor
BAF Bunker Adjustment
Factor

Above pasted table is an small example as mentioned earliesr I have data
which starts from Cloumn A ends to Column Z.

Now What I want is under seperate work sheet, when I select customer code
say in this case 130LPL13025 then macro should populate data table (Which
should include data from column A to column Z) for the same customer using
data in worksheet "CSOP".

The reason I want this macro bcoz I don't want people to go into database &
search for specific customer.

I would be very very greatful if any one of you can please help me to make
this macro as I need very badly.

Please let me know if you need anu more details.

Best Regards,
Kam.
 
K

Kam

Hello,

One more thing I forgot to mention. In CSOP worksheet one customer can have
5 rows, 6 rows & so on....

Best Regards,
Kam
 
K

Kam

Hello,

Can anyone please help to prepare below macro...I would appreciate if you
can please let me know if you need any further information...

Thanks & Best Regards,
Kam.
 
K

Kam

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.
 
K

Kam

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top