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