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.

Hello,

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

Best Regards,
Kam

"Kam" wrote:

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.

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.

"Kam" wrote:

Hello,

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

Best Regards,
Kam

"Kam" wrote:

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.

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

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
.

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
.