Question description:
This user has given permission to use the problem statement for this
blog.
Please i want items listed within the file name m_consumable under "Quantities" should reflect in A_consumables (only the total quantities) under the respective categories Column M that is opening stock of each items "laboratory, Supplier, Production
Solved by D. H. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
03/10/2018 - 06:34
yes
User
03/10/2018 - 06:34
Please am running out of time
User
03/10/2018 - 06:34
can you help me out?
Excelchat Expert
03/10/2018 - 06:35
Welcome to Excelchat,
User
03/10/2018 - 06:35
Thank you
Excelchat Expert
03/10/2018 - 06:35
Do you have a sheet to upload?
User
03/10/2018 - 06:35
yes
Excelchat Expert
03/10/2018 - 06:36
Please load and we can review your situation
User
03/10/2018 - 06:36
that's it
[Uploaded an Excel file]
Excelchat Expert
03/10/2018 - 06:37
OK , file open
User
03/10/2018 - 06:37
Please i want items listed within the file name m_consumable under "Quantities" should reflect in A_consumables (only the total quantities) under the respective categories Column M that is opening stock of each items "laboratory, Supplier, Production
Excelchat Expert
03/10/2018 - 06:39
m_consumable "Quantities need to be totalled and placed in the A_consumables sheet?
User
03/10/2018 - 06:39
yes
Excelchat Expert
03/10/2018 - 06:39
What column row in the A_consumables sheet?
User
03/10/2018 - 06:40
M
User
03/10/2018 - 06:40
opening stock
Excelchat Expert
03/10/2018 - 06:40
Opening stock is column N -correct?
User
03/10/2018 - 06:41
yes N
User
03/10/2018 - 06:41
sorry
Excelchat Expert
03/10/2018 - 06:41
There is a formula there already-not working?
User
03/10/2018 - 06:41
yes
User
03/10/2018 - 06:42
i tried doing it but i couldn't
Excelchat Expert
03/10/2018 - 06:44
Is the SUM intended to use column L and M?
Excelchat Expert
03/10/2018 - 06:44
N6 should sum 25KG CARTON & Laboratory?
User
03/10/2018 - 06:45
yes
User
03/10/2018 - 06:45
in that order
Excelchat Expert
03/10/2018 - 06:46
And column L and M correspond to column F and D in the M sheet?
User
03/10/2018 - 06:47
yes
Excelchat Expert
03/10/2018 - 06:47
Ok, let me work on this in EXCEL and get it back to you
Excelchat Expert
03/10/2018 - 06:47
Please stand by
User
03/10/2018 - 06:49
okay... also i want the Total number of Quantities that will come in (in M_consumables should reflect in A_consumables under the Warehouse section and also that will go out should also reflect under out)
Excelchat Expert
03/10/2018 - 06:50
Ok, lets see where we are after the first question
User
03/10/2018 - 06:50
okay
Excelchat Expert
03/10/2018 - 06:50
this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.
User
03/10/2018 - 06:51
okay
Excelchat Expert
03/10/2018 - 06:51
Please stand by
Excelchat Expert
03/10/2018 - 06:55
Formula is in the first section , but not picking up data?
Excelchat Expert
03/10/2018 - 06:55
25KG CARTON does not match Carton 25 KG (FON)?
Excelchat Expert
03/10/2018 - 06:56
is the first clue
Excelchat Expert
03/10/2018 - 06:56
Is that a match-something that needs to adjust to drop the (FON)?
User
03/10/2018 - 06:57
if you can adjust just go ahead
User
03/10/2018 - 06:58
but i will be happy if you can take both
User
03/10/2018 - 06:58
both the "25 KG CROWN AND FON"
Excelchat Expert
03/10/2018 - 07:00
I can use these rows M 123
Excelchat Expert
03/10/2018 - 07:00
Carton 15 KG (CROWN)
Carton 25 KG (CROWN)
Carton 25 KG (FON)
User
03/10/2018 - 07:00
Yes
User
03/10/2018 - 07:00
thats how i have categorized it
User
03/10/2018 - 07:02
but i want the total of all 25KG should reflect under M
User
03/10/2018 - 07:02
Sorry N
Excelchat Expert
03/10/2018 - 07:02
Can you verify this first section is correct?
Excelchat Expert
03/10/2018 - 07:02
OPENING
25KG CARTON Laboratory 42
Supplier 289165
Production 10
User
03/10/2018 - 07:03
Please with respect of the date
Excelchat Expert
03/10/2018 - 07:03
Date?
User
03/10/2018 - 07:03
yes
Excelchat Expert
03/10/2018 - 07:04
Where does data appear on the A sheet?
User
03/10/2018 - 07:04
scroll to the far left
Excelchat Expert
03/10/2018 - 07:05
FROM: 01/10/18 TO : 01/10/18 ?
User
03/10/2018 - 07:05
yes
Excelchat Expert
03/10/2018 - 07:05
A single day?
User
03/10/2018 - 07:05
Good
User
03/10/2018 - 07:05
yes
Excelchat Expert
03/10/2018 - 07:05
Ok
Excelchat Expert
03/10/2018 - 07:11
Date is not retuning, still working
User
03/10/2018 - 07:11
okay
Excelchat Expert
03/10/2018 - 07:13
It is column D in the M sheet -just to verifyFrom
Supplier
Excelchat Expert
03/10/2018 - 07:14
I think it is working the first section is all ZEROS
Excelchat Expert
03/10/2018 - 07:14
25KG CARTON Laboratory 0
Supplier 0
Production 0
User
03/10/2018 - 07:15
in relation with the date
Excelchat Expert
03/10/2018 - 07:15
10/1/2018 this date
Excelchat Expert
03/10/2018 - 07:15
listed as 1/10/2018 EURO format
User
03/10/2018 - 07:16
i mean if the date changes............ the quantities should also change
Excelchat Expert
03/10/2018 - 07:16
yes
User
03/10/2018 - 07:16
okay
Excelchat Expert
03/10/2018 - 07:21
Ok, I have the first section in and tested with date 31/10/17
Excelchat Expert
03/10/2018 - 07:22
Looks ok
User
03/10/2018 - 07:22
okay
Excelchat Expert
03/10/2018 - 07:23
Next section; can I use this: 25KG BLANK CROWN or do we need helper rows like in M1,2,3?
Excelchat Expert
03/10/2018 - 07:23
Are there variations of 25KG BLANK CROWN
User
03/10/2018 - 07:24
yes
User
03/10/2018 - 07:25
only the Totals of 25KG BLANK CROWN needs to reflect under the that section
Excelchat Expert
03/10/2018 - 07:25
Ok, just 25KG BLANK CROWN
User
03/10/2018 - 07:25
yes
Excelchat Expert
03/10/2018 - 07:29
There are no products listed as 25KG BLANK CROWN?
User
03/10/2018 - 07:29
ye
Excelchat Expert
03/10/2018 - 07:29
There is Carton 25 KG-Blank (CROWN)
Excelchat Expert
03/10/2018 - 07:30
Should I change L9?
Excelchat Expert
03/10/2018 - 07:30
I changed it , it works
User
03/10/2018 - 07:30
yeah change it
User
03/10/2018 - 07:31
oops my time is up
Excelchat Expert
03/10/2018 - 07:31
In the time remaining , I need to get you the sheet
User
03/10/2018 - 07:31
okay
User
03/10/2018 - 07:31
please have you done the other section
Excelchat Expert
03/10/2018 - 07:31
[Uploaded an Excel file]
User
03/10/2018 - 07:31
the in and out
Excelchat Expert
03/10/2018 - 07:32
did only 2 sections, but I think you can follow these 2 examples and complete
Excelchat Expert
03/10/2018 - 07:32
If not - repost, please
User
03/10/2018 - 07:32
how can i re post
Excelchat Expert
03/10/2018 - 07:33
the same way you posted this request.
User
03/10/2018 - 07:33
Please do it and sent through my mail please
Excelchat Expert
03/10/2018 - 07:33
Ask for same Expert, and I will try to pick up
Excelchat Expert
03/10/2018 - 07:33
Ok, I can send via , site support, they have your email
User
03/10/2018 - 07:33
okay
User
03/10/2018 - 07:33
i will be very glad
Excelchat Expert
03/10/2018 - 07:33
Thanks for coming to Excelchat. Feel free to leave any comments or feedback. Have a nice day.
User
03/10/2018 - 07:34
Thanks
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.