Can we use the Customized Tool Bar in another file.

Example:

If I created a Tool Bar with Name: "PSL" While using from Tools Menu with
Customized Option.

Can I use the above Tool Bar "PSL" in another file.


Please do the needful on the above case.

Narayan PSL

What happened when you tried it?

PSL wrote:

Can we use the Customized Tool Bar in another file.

Example:

If I created a Tool Bar with Name: "PSL" While using from Tools Menu with
Customized Option.

Can I use the above Tool Bar "PSL" in another file.

Please do the needful on the above case.

Narayan PSL

--

Dave Peterson

Hi,

Could u please help me on the following issue:

If I given item code in A1 as 123 then B1 should display as "PEN":

I need to execute the Item Name in a cell B1 when I enter the Item Code in A1.

Examples:

If I given item code in A1 as 123 then B1 should display as "PEN"
If I given item code in A2 as 124 then B2 should display as "PAPER"

Like this I have 18 Item Code were there.

Please help on this.

Thank You,
PSL

You need to create a 2 column table that lists the code number and the
corresponding item name:

................F.............G
1.........Code........Item
2..........123..........Pen
3..........124..........Paper
4..........125..........Book
5..........126..........Chair

Then, use this formula in B1:

=IF(A1="","",VLOOKUP(A1,F$2:G$5,2,0))

Copy down as needed.

Biff

"PSL" wrote in message
...
Hi,

Could u please help me on the following issue:

If I given item code in A1 as 123 then B1 should display as "PEN":

I need to execute the Item Name in a cell B1 when I enter the Item Code in
A1.

Examples:

If I given item code in A1 as 123 then B1 should display as "PEN"
If I given item code in A2 as 124 then B2 should display as "PAPER"

Like this I have 18 Item Code were there.

Please help on this.

Thank You,
PSL