Search results

Hi.. I want to export current status of a cargo from website with selecting a option from dropdown and put the value from A1 cell and then search, after this the current status export in excel column B1 and so on. After this the vba search the same thing with the value of A2 . For Examaple...

I have to bold entire row in multiple sheets based on if A column have Grand Total

Hi Bosco.. We have rate according to slab of weight for example: For 40" container Weight : 10000 20000 23000 26000 26000 & above Rate 100 200 300 400 500 Now if we have 2 container of 40" with weight of 22000, then the rate will be apply as 200...

Hi.. Bosco Thank you so much for share such a great formula and this is working also after some alteration in formula as per my need. Altered Formula ...

thank you so much for your reply .. but i have container nos with heading of 20 & 40 like given below Port Name Place of Delivery Container (20'') Container (40'') Gross Weight PIPAVAV KATHUWAS 0 2 20518 PIPAVAV KATHUWAS 0 1 8694 PIPAVAV KATHUWAS 0 4 14080 PIPAVAV KATHUWAS 1 0 3069...

Vletm please find attached

ok sir

For example I have a data for calculate shipping cost First field is port name & other is weight slab like below Port Name Place of Delivery Weight Slab 10000 23000 26000 & above 10000 23000 26000 & above - - Container Size 20 20 20 40 40 40 - - - Rate Rate Rate Rate Rate Rate PIPAVAV...

Dear All, Whenever i save any excel file , this is going to close and reopen with recovery mode version 1. please suggest.

Please find attached sheet

First i have created multiple sheets based on one column data with the help of report filter in pivot (Like Person Name) after this i create a copy of all tabs separately and attached in personalized mail to concerned person. So please share if any solution for time saving.

Simple way: Just right click on sheet name and choose select all sheets. after this you have to changed in one sheet , all sheets will changed

try Data > Text to Columns and delimiter. Use ; as delimiter. after break data in column copy and paste special transpose.

I have required some data by vlookup array. Problem is two column is in left side of lookup value column and two or more column is in right of lookup value column. Please suggest the combination formula for left & right value by vlookup array.

I have to make a format in which some data is fix & some are variables. So i want to fill the variable data of format through excel detail & make format copy as per the serial no.

Long way of the same Please find the attachement