*VERY NICE* 👌🏻 Please make one where...... 1) We have both Purchase & Sale on same Sheet, so we can just scroll down to see & have 12 Tabs for 1 YEAR & IMPORTANT FOR STOCK TO KEEP AUTO UPDATING ON TO NEXT MONTH (Hope you understand) 2) Freeze the ITEM List so when we scroll the dates & Item Name is always is visible 3) Need to Add Damage Item, IF we have 10pc Total , but 1pc is damaged & 9pc are Good, THIS IS VERY IMPORTANT TO MENTION Please add that coloum 4) Most Important, in Dates coloum when I put 5pc sold, for Computers I need to add the Inv # For Eg: If I sold 5p. COMP on 10th want it to show in next Coloum 2pc Comp sold to Inv# 1, 1pc Comp sold to Inv# 2 2pc Comp sold to Inv# 3 & so on .... How would we be able to add coloum for that
Dear sir I have something request for you how you minus both sheet formula please explain again... because am trying but not showing currently answers.. otherwise everything is awesome sir.... thank you
Assalamualaikum w b. Hope doing well. I have follow your sheet, it's amazing, very nice bro, I have some query in Vlookup, getting N/A, Could you please help me out and how? Masalam
❤ All the best
Thanks for this video tutorial, so when saving the how do you do it mostly when there's an incomings, outgoing and balance in hand
Good teaching 😊
Thank you Sir, Very good information how to add if we have 100+ items.
OUTSTANDING
Excellent
Mashaallah ❤❤
THANK U BROTHER
ZABAR 10 WERE NICE
Thanks
good information
Thank u
Good sir
English version please , though good am excellent demo
Sir ap Please yeh jo sheets bnai hain in ko kisi drive mein rakh k link send kr sakty? Ya mujy email kr sakty ? Thanks for your knowledge
*VERY NICE* 👌🏻
Please make one where......
1) We have both Purchase & Sale on same Sheet, so we can just scroll down to see & have 12 Tabs for 1 YEAR & IMPORTANT FOR STOCK TO KEEP AUTO UPDATING ON TO NEXT MONTH (Hope you understand)
2) Freeze the ITEM List so when we scroll the dates & Item Name is always is visible
3) Need to Add Damage Item, IF we have 10pc Total , but 1pc is damaged & 9pc are Good, THIS IS VERY IMPORTANT TO MENTION Please add that coloum
4) Most Important, in Dates coloum when I put 5pc sold, for Computers I need to add the Inv #
For Eg: If I sold 5p. COMP on 10th want it to show in next Coloum
2pc Comp sold to Inv# 1,
1pc Comp sold to Inv# 2
2pc Comp sold to Inv# 3 & so on ....
How would we be able to add coloum for that
Will try to find time for this soon.
Jabar dast
Thank u dear.
Dear sir I have something request for you how you minus both sheet formula please explain again... because am trying but not showing currently answers.. otherwise everything is awesome sir.... thank you
I am also facing same issue
👏
Can you please upload this excel sheet to download
In aur out dono ek hi sheet me kar sakte hai kya sir
Yes dear.
Assalamualaikum w b. Hope doing well. I have follow your sheet, it's amazing, very nice bro, I have some query in Vlookup, getting N/A,
Could you please help me out and how?
Masalam
W.salam. iferror is used with vlookup to solve that issue
Sir jab hum new month banathi he to stock of hand per tagher nah atha
Stock on hand next month me opening stock bn jyga
could i get the sheet
Via whtsapp
Sir can you provide this excel file
Ye formula kam nhi kar rha hai jo in hand stock nikhalne wala
Jb outgoingstock sheet me jain to total ka formula dobara lagain.. phir msla nae hoga..
Sir mai dubara kosish kiya but nahi aa rha hai plz explain kre
Sir, date wise how to make excel stock report
We need to input pivot table
Or use filter.
@@tutorialsforUrduHindi please send a link how to use filter for date wise stock sir
Ea sir cansa year version he
2019
Her version me kam kre ga
like
Vlookup lga rhe h , #name araha h
Iska pdf bhejiyega sir
Sir download file link dijiye
By product size record show nahi hota
Mtlb.
Kuch b nazar nhi arha
Sir please apna whatsaap number rey day.
Mujhy aik issue Aa raha hai
Plz Sir
03472076960