i have billing number in pivot table.i have another sheet which has billnumber and amount i want to lookup the amount to another column beside the pivot. any suggestions
I want a formula to get eaches from pack description for example 18 for kitkat,for polo 27. Can you help me
PACK
Eaches
KIT KAT 4 Finger 18(18x37.3g) N3 IN
18
NESTLE CEREGROW BIB 24x300g IN
24
CERELAC STAGE 1 Rice BIB 24x300g N3 IN
24
CERELAC STA1 WheApp Poshan BIB24x300g IN
24...
i want to get data by entering shipment number get the start date and end date customer name location and timings which are all in nov sheet.hyd dc time is in dc column customer timings are there in cd colums. gr number is from gr column.
distance from km shheet based on towns
I want to copy the data into different sheets based on the name as criteria
I have pasted the data of one customer i want the data to paste the data of all customers
for one customer one sheet
I select the item code from e column in stock intake i dont have issue in f column stock in take but enter in stock out in g column i have to check whether is quantity avaible in H col in investory sheet
Can u please give any solution for this
Regards
Mohandas
This file is for tracking the inventory for the manufactuing products
I have 3 sheets
1 RM (Raw Material)
2 PM (Packaging Material)
3 FM (Finished Material)
I have to select in the FM the raw material which is multiple may be more than 1 and pacaking material which also can be the multiple...
Dear Sir,
I want to do validation
I have 3 sheets
1 RM
2 PM
3 FM
I want to do data validation on F column in FM SHeet where i have enter the quantity which has to check in PM sheets whether it has quantity or not ,If not it has to give the message
Please help
I Have many sheets which has the brand name and averages. I want data from all sheets into one sheet and sheet name as columns heading can any one help me
Regards
Mohandas
I have in this sample file 3 sheets called town1, town2,town3
Which has category of oulets namely supermarkets and so on
I have another sheet called summary in which this town data needs to be updated
Please help me getting the data from that sheets as sheet name and outlet category as...
I have 2 sheets one is pack and another is brand. I was trying to sum the brand basis brand names in b column and quantity in ge columns from pack sheet to brand sheet. There was issue in blanks cells which is giving wrong numbers. Please help me in this issue
Regards
Mohan