HomeХобби и стильRelated VideosMore From: Excel For Freelancers

Create This AMAZING Excel Application that Tracks Purchases, Sales AND Inventory [Part 1]

5116 ratings | 384587 views
Learn The Excel Dashboard That Launched My Career Here: http://bit.ly/BestExcelDashboard Download Your FREE Workbooks From either of the following links: Using Your Email Here: http://bit.ly/InvMgrPt1_Wb With Facebook Messenger Here: http://bit.ly/InvMgrPt1_FbDl See Part 2 Here: https://youtu.be/GodLw1LfTj4 Controlling Purchases, Sales & Inventory can often be a headache, even in Excel. But today all of that changes! In this week's UNIQUE TRAINING Training I will create a POWERFUL Inventory Manager right before your eyes.  In Part 1 of this FREE Training, you will learn: ☑️ Create a single unique single click switch ☑️ Program both Sales AND Purchases in the SAME SCREEN ☑️ Master Conditional Formatting  ☑️ Automated Inventory Count ☑️ Automatically display Product Pictures Got Excel Question? Let us help you with that, Join thousands of the worlds best Excel Experts in Facebook's fastest growing @Excel For Freelancers Group right here: http://bit.ly/groupexcel Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing on YouTube here: http://bit.ly/ExcelForFreelancers_FreeTraining I hope you love these videos, for More Free videos, personalized training and amazing tricks for freelancers, please find and follow us here: Twitter: https://twitter.com/RandyNAustin Website: https://www.ExcelForFreelancers.com LinkedIn: https://www.linkedin.com/in/excelforfreelancers/ Facebook: https://www.facebook.com/ExcelForFreelancers/
Html code for embedding videos on your blog
Text Comments (307)
peri noveriza (3 days ago)
sir...i learn much from your video..
Excel For Freelancers (2 days ago)
Thanks so much Peri, I am glad really glad you are enjoying the videos
streeteats (3 days ago)
At 22.50, You were able to select multiple cells that weren't attached to each other. Could you tell us how? Thank You
Excel For Freelancers (2 days ago)
Hi Street Eats, by holding down the Ctrl button and clicking, users can select multiple cells. I hope this helps
Adinew Tsegaye (5 days ago)
Hi Sir, why do I always have this error which was highlighted in yellow at the line with arrow indicator? What went wrong? I cant make the button move. i use word 2016 please sir i need it to work for me.
Excel For Freelancers (5 days ago)
Hi i cannot see your code or the reason for the error, however many people are running into an error with "IncrementLeft 30" (Please make sure there is a space between "Left" and "30"
superlonlys (6 days ago)
Kindly make excel for oil change shop inventory management
Excel For Freelancers (6 days ago)
Thank you very much for the suggestion. I will do my best.
Excel Formula for Cable Operator Will Make You Please...
Sir aapse jitna Ho sake utna To help kar sakte ho ki nahi...
Hello sir Aap Cable oprater pe Software bana sakteho...itna add karna he muje... Bill number Star date End date customer name Add 1 Add 2 Mobile number Package select Chanel Month New customer add Sifting connection add Status :- Active Status:- Inactive
Excel For Freelancers (8 days ago)
HI thanks for your comment. I am not familiar with the Cable Operator Industry.
EDY WARSONO (11 days ago)
thank you for information brother,,,
EDY WARSONO (8 days ago)
Thank You Brother science, very helpful help give advice.To me about my vidio brother,,,
Excel For Freelancers (9 days ago)
For sure you are very welcome. Happy to help
woss2010 (14 days ago)
to create all this, my question is can I use any color on my own or have to be specific the company need at a color of their own preference
woss2010 (11 days ago)
Thanks,+Excel For Freelancers
Excel For Freelancers (13 days ago)
Hi Woss you can customize this with any color you like, so it is entirely up to you. Make sure you have downloaded the sample from my description above.
ABDULBASET BARNAWI (16 days ago)
can you recommend me which courses should I take to make such things
Excel For Freelancers (15 days ago)
HI sure, when it comes to VBA, this VBA Course by an Excel MVP is the best: https://members.excelcampus.com/a/2425/odpMqQzw When you are ready to create amazing Inventory & Financial Reports this Dashboard course is one of the best: https://www.excelforfreelancers.com/product/advanced-excel-reports-dashboard-masterclass I hope this helps. Should you have any additional questions, please do not hesitate to ask.
baby mama (16 days ago)
could you possibly send me the final template to [email protected] thank you
ghulam rabani (19 days ago)
Hey thank you very much. Please Upload a hd video
Excel For Freelancers (18 days ago)
HI for sure you are welcome. I will upload HD, no problem. Thanks
Fong Chin Weng (25 days ago)
Wow ! Thank you! You are an Master of Excel Manipulation.
Excel For Freelancers (25 days ago)
Thanks so much Fong, I am glad you liked it
muhammad obaid (1 month ago)
Thanks for the Precious information ..i want to know how to export this vba file to exe file so the user can start entry by double clicking the exe file.
muhammad obaid (24 days ago)
+Excel For Freelancers Thanks alot sir!
Excel For Freelancers (27 days ago)
Hello, Excel should stay as an xls, xlsm, or xlsx file. While we can put it into an exe format, it will still need to be converted back to it's original format to be opened by Excel. i hope this helps.
Dipen Modi (1 month ago)
What did you do at 12:42? All those columns changed their size so quickly...
Excel For Freelancers (26 days ago)
There are some great basic VBA Courses in Udemy. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:http://bit.ly/groupexcel
Dipen Modi (27 days ago)
+Excel For Freelancers can you make videos for VBA please? I am unable to save xlsm file and the button doesn't even move after I do the first coding
Excel For Freelancers (27 days ago)
When you highlight a set of columns and double click on a column border in the header, all the columns will auto-adjust size based on the text inside those cells. I hope this helps
ERIC ODJOH KWAAKO (1 month ago)
very good
Excel For Freelancers (1 month ago)
Thank you so much Eric
Raisa Uy (1 month ago)
Hi I'm trying to do this but I got stuck in doing the MoveBtn Command. I followed all the steps but when I already assigned the MoveBtn it prompts to "run-time error '-2147024809 (80070057)" what should I do? Hoping you can give me solution on this. thanks in advance :)
Excel For Freelancers (1 month ago)
Hi add a space between the word "Left" and "-30" This will fix the problem.
Raisa Uy (1 month ago)
It keeps on highlighting on this .Shapes("MoveBtn").IncrementLeft-30 (I don't know what to do)
Amana Agro (1 month ago)
move bottun setup problem hossea
Excel For Freelancers (1 month ago)
Hi add a space between the word "Left" and "-30" or "Left" and "30" This will fix the problem.
zeeshan akram (1 month ago)
Amazing sir
Excel For Freelancers (1 month ago)
Thank you so much Zeeshan :)
Abbiel Ballesteros (1 month ago)
Hi sir! Can I download and use this? Only for educational purposes. I already sent my email in the link above hope to get my copy now. Thank you!!!!
Excel For Freelancers (1 month ago)
Hi Abbiel, Thanks so much. Yes of course you can download and use it. You should get the email in a few minutes (if not check your spam folder) You can also use the facebook messenger link to download the application. Thanks so much.
Adeel Riaz (1 month ago)
Sir i need all coding of this because I'm facing some issues to do coding please
Excel For Freelancers (1 month ago)
Hi thanks for your message. I have created a Facebook group with 15,000 Excel Experts so that many of us can help you with your Excel questions. Can you please post your detailed question, with samples or screenshots directly in our group? If you have not Joined yet, please join here: http://bit.ly/groupexcel. This way we can get you the answers you need, fast.
moin moulvi (1 month ago)
THE FIRST FORMULA SHOWS ERROR KINDLY HELP
ghulam rabani (19 days ago)
​+Excel For Freelancersdear sir please add me in the group, sir u how email?
Excel For Freelancers (1 month ago)
Hi I am not sure which formula you are referring to, so if you can please join our Excel For Freelancers Facebook Group here: http://bit.ly/groupexcel , create a post, and upload your workbook or screenshots. We have 15,000 members who can help you with this.
Nepembe Severus (1 month ago)
Great, which weed do you smoke, i want to be smart like you... keep it up
Excel For Freelancers (1 month ago)
LOL. Thanks so much. I am so glad you love the videos. New training every Tuesday :)
Jay Singh (1 month ago)
Can i download and use it?
Excel For Freelancers (1 month ago)
Hi have a look in the description for this video (inside the description text you will see instructions on how to download)
Jay Singh (1 month ago)
+Excel For Freelancers thanks. I couldn't locate download link. Please help me to find it
Excel For Freelancers (1 month ago)
Yes sure you are welcome to download any application used in my video training and use it for free. (all download links are above in the description)
SHIV KUMAR (1 month ago)
sir how to odd even rows colors this formula not work in my excel sheet.
Excel For Freelancers (1 month ago)
Hi you can add this formula to conditional format formula: =Mod(Row(),2)=0 I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:http://bit.ly/groupexcel
SHIV KUMAR (1 month ago)
Sir movebtn not work in my excelsheet how to create move botton and work movebtn plz tell me with new video.
Excel For Freelancers (1 month ago)
HI many people had a problem with this, make sure there is a space between "left" and "30" in the code I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:http://bit.ly/groupexcel
Phanindra Aravapalli (1 month ago)
Can any one send me this sheet please I need to implement in my business... My email id is [email protected]
Excel For Freelancers (1 month ago)
Hi you can click the links in the description to download the application for free.
Phanindra Aravapalli (1 month ago)
My email is [email protected]
stevan jaramillo (1 month ago)
How could I add a loan category to the purchase and sales tab. could I make a special tab to see how much each person owes ?
Excel For Freelancers (1 month ago)
I believe that would help them for sure (We also have developers who speak Spanish as well)
stevan jaramillo (1 month ago)
+Excel For Freelancers For the paid job do I need to send them my Excel ? I Already made it but it's in Spanish. The code is in English but the Outside part is in Spanish like the purchase and sales tabs
Excel For Freelancers (1 month ago)
Hi Stevan, thanks for your comment. The application is open and free to customize it (I would not be able to explain all of the steps in a YouTube comment) however please feel free to join our Excel For Freelancers Facebook Group here: http://bit.ly/groupexcel and request a PAID JOB by one of our experts there.
mj IOF (1 month ago)
the excel im using has no "developer" button next to "view" button.. what will i do then ?
Excel For Freelancers (1 month ago)
Hi you can display the Developers tab from the File > Options > Customize Ribbon > Check Developers Tab, or just use Alt + F11.
BlkQueenK (1 month ago)
You can do so much with Excel. Thank you for this 🙏🏾
Excel For Freelancers (1 month ago)
Thank you so much. Please do not miss this Tuesday, I will show you how to share and sync your macro-enabled workbook with anyone in the world: https://youtu.be/3E6ExWYscHQ
Very nice and useful video..request you to upload the same in hind plz
Excel For Freelancers (1 month ago)
Thanks so much. You can download the free workbook using the links above in the description. I hope that helps.
Abhishek Hulyalkar (1 month ago)
Hello sir, what is solution for "compile error expected: expression" ??
Abhishek Hulyalkar (1 month ago)
+Excel For Freelancers sure I'll upload it.
Excel For Freelancers (1 month ago)
Hi it is hard to see the cause without seeing your code and workbook. Can you please upload the details to our Excel For Freelancers Facebook Group here: http://bit.ly/groupexcel so that we can get that fixed for you. Thanks so much.
Fendi Khan (1 month ago)
Hi Sir, why do I always have this error which was highlighted in yellow at the line with arrow indicator? What went wrong? I cant make the button move. Sub MoveBtn() With Sheet1 If .Range("B1").Value = "Inbound" Then --->> .Shapes("MoveBtn").IncrementLeft30 .Range("B1").Value = "Outbound" Else: .Shapes("MoveBtn").IncrementLeft -30 .Range("B1").Value = "Inbound" End If End With End Sub
rajashree raje (4 days ago)
Sir I all so facing the same problem plz how can I salve this issue
Excel For Freelancers (1 month ago)
HI please put a space between Left and 30 like this: .Shapes("MoveBtn").IncrementLeft 30 This will fix the problem (I dont know why excel removes the space. In my application there is a space but in others there is no space. Some issue with Excel, removing the space)
Ayush Kumar (2 months ago)
This is a great video. I have subscribed your channel today. Would you be able to share this sample file to my email id: [email protected] Many thanks again :)
Excel For Freelancers (2 months ago)
Hi Ayush, thanks so much. You can download the free sample file using email or facebook. (see the links above in the description)
bio Mechatronics (2 months ago)
Are u an AI?
Excel For Freelancers (2 months ago)
Not since the last time I checked, but I will check again and let you know :)
bio Mechatronics (2 months ago)
Sir did u create microsoft?
Excel For Freelancers (2 months ago)
LOL. No, but I just love software, and I enjoy creating real solutions. :)
Symphony X (2 months ago)
Hey thank you very much. But i get a error when put the formula in the conditional formatting. But thank again. Impressive work.
Excel For Freelancers (2 months ago)
HI thanks so much for your comment. I am sure we can fix that error for you. Can you join our Excel For Freelancers Facebook Group here: http://bit.ly/groupexcel and post a screenshot of your issue. We have 15,000 experts who can help you. Thanks so much
Dream Paradise (2 months ago)
Hi Sir, You did fantastic thumbs up :) I just wanted to know that which formula you created in while you doing conditional formatting in the new rule because first, it was blur can't see properly and secondly you typed so fast. So, if you kindly help me out and tell me the formula in your reply, I'll be really grateful to you. B. Regards.
Excel For Freelancers (2 months ago)
Thanks so much. I do appreciate that.
Dream Paradise (2 months ago)
+Excel For Freelancers Sir, Thank you so much your kindness, I am really grateful but I am still trying to make my own while watching your videos just to learn myself. May GOD Bless You Always. B. Regards.
Excel For Freelancers (2 months ago)
Hi Dream, I can certainly understand if you did not catch each formula, and sometimes it's hard to see. That is why I always make the entire workbook available for free for you to download. Please check the links in the description to download the entire workbook so you can see all of the conditional formatting formulas first hand. I hope this helps.
ROHAN ISLAM (2 months ago)
thanks for tutorials...
Excel For Freelancers (2 months ago)
For sure, you are very welcome
ROHAN ISLAM (2 months ago)
please speak slowly
Excel For Freelancers (2 months ago)
Thanks Rohan, I will do my best
Carlos R. Chavez (2 months ago)
Thanks my friend you're one of the best instructors I ever follow
Excel For Freelancers (2 months ago)
Thanks so much Carlos, I really appreciate that.
Talal Flew (2 months ago)
mate i have followed you until i come to make Macros bottom it give me wrong. what is the problem. please see this and let me know Sub MoveBtn() With Sheet1 If .Range("B1").Value = "Purchase" Then .Shapes("MoveBtn").IncrementLeft30 .Range("B1").Value = "Sales" Else: .Shapes("MoveBtn").IncrementLeft -30 .Range("B1").Value = "Purchase" End If End With End Sub
Excel For Freelancers (2 months ago)
Hi for some reason many people are getting this error. (my file its not a problem) but its an easy fix. Just put a space between "Left" and "30" so the line is .Shapes("MoveBtn").IncrementLeft 30 I am sure this will fix the issue.
Kingsley Bigshot (2 months ago)
Wow! So amazing. How can I develop a tuckshop management system. The tasks include (1)students deposit a certain amount of cash.(2) Purchases like snacks, toiletries, stationery, mending of shoes/clothes etc are paid for from the initial deposit made. (3) The balance should be calculated after each expenses. The Report should show the child's name, class, the items purchased, date purchased and the balance (credit/debit). Please house I need a headstart. Thanks
Excel For Freelancers (2 months ago)
Hi thanks for your message. it really depends on a few factors, your skill level, how much time you have, and your full requirements. All of this is possible and you are welcome to customize any of my applications to fit your exact requirements. If you would like some help with this, we have a group with 14,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: http://bit.ly/groupexcel (if you have not done so yet) You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project. I hope this helps and thanks so much.
Arun Kumar (2 months ago)
Vdo not clear
Excel For Freelancers (2 months ago)
Hi sorry if it was not clear for you. Please download the workbook using the links in the description so that the instructions are more clear. Thanks very much
NSLAS Shore (2 months ago)
download link not available
Excel For Freelancers (2 months ago)
Hi thanks there are two links in the description they should both be working, (you can try both). Thanks very much.
Colin (2 months ago)
I don't know what kind of demon magic you possess. I wasn't even aware this was possible in Excel.
Brandi Rollins (10 days ago)
Lolol. @demon magic.
MsMunchy23 (1 month ago)
Ha ha ha took the words right out of my mouth lol
Excel For Freelancers (2 months ago)
Haha thanks so much Colin, Sometimes i don't know either i just push the limits every chance I get. Thanks so much for your comment.
tuhafeni mwandingi (2 months ago)
Hi,I'm kindly looking for someone to assist me with my excel project. I want a pop form to appear when a cell is selected, to assist enter data in that cell and several other specific cells, either in that worksheet or other sheets within the same workbook. Or create a series of promting messages requiring completion of few other cells if a certain cell is filled, or something similar to prompt users to fill in multiple data in different locations using just one form. mail me via Microsoft: [email protected] Thank you.
Excel For Freelancers (2 months ago)
Hi tuhafeni, Thanks so much for your message. If you join our Excel For Freelancers Facebook Group here: http://bit.ly/groupexcel and post your requirements along with PAID JOB, we have 14,000 excel experts who can help you with that. Thanks so much
Rom lef (2 months ago)
Bonjour je profite des vacances de noel pour voir des videos que je n'ai pas encore vu !!!! à vrai dire elles sont vraiment très complètes, du très bon boulot, je vais toutes les visionner, un très grand merci pour cette première partie enrichissante :) merry chrismass
Excel For Freelancers (2 months ago)
Thank you very much Rom
Rom lef (2 months ago)
+Excel For Freelancers . Magnifique, je vous ai découvrir sur youtube il y a pas très longtemps et je suis ravi, je vais essayer de récupérer vos tutos, vidéo et classeur xls et xlsm pour m'améliorer, il y a quand même des petites différences entre excel anglais et français, bravo 😄
Excel For Freelancers (2 months ago)
Merci beaucoup Rom. Après ce gestionnaire d'employés, je créerai plus de vidéos à partir d'un classeur vide, comme celui-ci. J'apprécie toujours tes commentaires
Justin Gulledge (3 months ago)
Hello! I went through this video step by step by copying everything being done on my own Excel file. The points I found tough to duplicate were naming the shapes as Excel kept going back to the original name. I was able to use Alt F10 which brings up a menu that allows you to change the name of shapes and groups easily. The other part that was difficult was using the Name Manager to create the mapping piece. This is because I have never used this function and not understanding the formulas made it harder to copy them as they were done (a lot of going back in the video and pausing to get it right). All that said, I now have a spreadsheet setup which is very similar to the one done in this video. Yes the colors are off a bit, but the function of it to this point is right on. This was a four plus hour project for me doing it at my own pace while watching and playing back the video as needed. I learned so much from this and want to thank you for putting the video out. Using Excel daily for work I get used to doing the same things over and over but this opened my eyes to new and exciting options this powerful tool has to offer. I look forward to going on to part 2 and finishing my spreadsheet. Then I will work towards modifying it to fit my business needs. A++ on the video and time taken to go through this for public use. Thank you again!
Excel For Freelancers (2 months ago)
Hi Justin, Thanks so much for going through, watching the videos and creating the application yourself. That is the best way to learn and you should be commended. IF there is any duplication in shape names, or grouped, they might need to be renamed using the selection panel. The Name Manager can also be a bit complex when it comes to Dynamic Ranges but for sure you will do great. When you are ready to create powerful reports and dashboards you can check out my Advanced Excel Dashboard Reports Masterclass here: http://bit.ly/AmazingDashboardCourse Also I am on part 15 of our Employee Manager which is an amazing and massive project and great way to learn as well. Thanks so much for your comment and continued support.
amjad ahmadzai (3 months ago)
Actully excel is not for database, such kind of database should be create in java,C#,or oracle
Excel For Freelancers (3 months ago)
Thank you very much. I am happy to help.
amjad ahmadzai (3 months ago)
but the way you teach is amazing. i havn't see such kind of vidoes in whole youtube even the programmer will be amazed to see your vidoes i really appreciate
Excel For Freelancers (3 months ago)
Hi Amjad, thanks for your comment. Any large database, with millions of rows should be contained in a larger application, correct however for medium or small companies, Excel can provide a great solution. I appreciate your comment
CJ cy (3 months ago)
Hello can you please make atutorial for Accounts receivable system and collection connected with its ledger accounts?
Excel For Freelancers (3 months ago)
Hi CJ, thanks very much for your suggestion. In the coming weeks I will do more financial reporting including AR, P&L and ledger accounting as well. Thank you for your continued support
Awadh Binamro (3 months ago)
Heloo Sir can you upload this file to any link so that we can download it easily
Excel For Freelancers (3 months ago)
Hi thanks very much for your comment. All files can be downloaded using the links in the description above. Thank you.
Varaha A (3 months ago)
Hello, can we able to customize or your help t customize it?
Excel For Freelancers (3 months ago)
Hi thanks for your message. I have been focused on creating some amazing Excel courses for all Excel enthusiasts so I am unable to offer any one on one support at this time. However, I have created a Facebook group with 13,000 Excel Experts so that many of us can help you with your Excel questions or complete a customization project for you. Can you please post your detailed question, with samples or screenshots directly in our group and mark it as "PAID JOB" so our members know it is a paid job for them.? If you have not Joined yet, please join here: http://bit.ly/groupexcel. This way we can get you the answers you need, fast.
Akmar Anwar (3 months ago)
the developer button where does it come.?
Excel For Freelancers (3 months ago)
Hi Akmar, you can display the Developer button when you go into the "File" menu then click "Options", then "Customize Ribbon", and then on the right side you can select "Developer" option. Thanks for your question.
Samson Saka (3 months ago)
Excellent and helpful video but you did not cover the Macro part at the end of the video. I believe you have cut it short due to time. Can you please cover the Macro part in another video?
Excel For Freelancers (3 months ago)
Hi thanks so much, and I am glad you liked it. Please also check out part 2 of this were I cover additional macros and features here: https://youtu.be/GodLw1LfTj4
Dawoodhusain Husain (3 months ago)
Sir do u have codes for school library software ..plz upload it
Excel For Freelancers (3 months ago)
Hi thanks for your message. I do not currently have any codes for a school library software. Thank you
Wishma Lowa (4 months ago)
hi i need to help me create macro zero qty based on the other column value please help men
Excel For Freelancers (4 months ago)
Hi thanks for your comment. I have created a Facebook group with 12,000 Excel Experts so that many of us can help you with your Excel questions. Can you please post your detailed question, with samples or screenshots directly in our group? If you have not Joined yet, please join here: http://bit.ly/groupexcel. This way we can get you the answers you need, fast.
Chakradhar Nag (4 months ago)
Hello sir, I am from india. difficult to understand to your english prouncession. You can short out by writing in words with sound. Thanks.
Excel For Freelancers (4 months ago)
Hi thanks very much for the feedback. Much appreciated.
Chene Nowicki (4 months ago)
your videos are great man thanks for the knowledge
Excel For Freelancers (4 months ago)
Thanks so much and glad you like them
Jesnathan Barrera (4 months ago)
new subscriber is here.. thank you for sharing this video. more power and God bless!!!
Excel For Freelancers (4 months ago)
Thanks so much Jesnathan, so happy to have you here. I look forward to creating amazing videos and training each week
Arthur Siloka (4 months ago)
Thanks for this video. just what i needed. where is part two though?
Excel For Freelancers (4 months ago)
Hello Arthur, you are welcome. Part 2 can be found here: https://youtu.be/GodLw1LfTj4
sandeep arora (4 months ago)
fabulus videos
Excel For Freelancers (4 months ago)
Thank you so much. I am really glad you like them
only hits (4 months ago)
I like it. Is awesome
Excel For Freelancers (4 months ago)
Thank you very much, I do appreciate that.
sandeep suri (4 months ago)
Run time error 438 Sub MoveBTN() With Sheet1 If .Range("B1").Value = "Purchase" Then .Shapes("MoveBTN").IncrementLeft30 Range("B1").Value = "Sales" Else: .Shapes("MoveBTN").IncrementLeft -30 .Range("B1").Value = "Purchase" End If End With End Sub how to solve this
sandeep suri (4 months ago)
Excel For Freelancers hi I downloaded your version but unfortunately is not being supported
Excel For Freelancers (4 months ago)
There must be a space between 'Incrementleft' and '30' (It is strange so many people had this issue however in my download version there is a space between 'incrementleft' and '30')
Tunis Babas Isaiah (4 months ago)
please help me out, am unable to create MoveBtn for the past two weeks now and without that I cannot move forward. this is the error massage that message was 2147024809(80070057) and the item with the specified name wasn't found.)
Excel For Freelancers (4 months ago)
HI i am not sure what the problem is, or the cause but i see many people have the same problem on this they are writing "IncrementLeft30" when they should write "IncrementLeft 30" (there must be a space between IncrementLeft and 30) I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:http://bit.ly/groupexcel
nandani Chetnani (4 months ago)
Where is part 2 of inventory manager
Excel For Freelancers (4 months ago)
Hi Part 2 can be found here: https://youtu.be/GodLw1LfTj4
Windward RES Ltd (4 months ago)
I was getting an Error code as soon as I tried to run the macro. I've added an End With to close the With line but when my button moves to the right it disappears! I suspect underneath the background shape.....
Thierno Diallo (25 days ago)
That error is related to the oval shape not properly getting renamed to "MoveBtn". fix that and all should work perfect
Excel For Freelancers (4 months ago)
HI Windward, its hard to know the exact cause of the issue however to get help with your question, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:http://bit.ly/groupexcel
vivek pal (4 months ago)
Upload a video on /off button and show coloer and text- during click the button show on /off.
Excel For Freelancers (4 months ago)
Hi thanks for your suggestion I will do my best to get this in. Much appreciated.
vivek pal (4 months ago)
I have solved my problem; the problem was related to not click on run button that is on above ribbon.
Tunis Babas Isaiah (4 months ago)
@Vivek Pal. please help me out, am having the same problem with. kindly tell the steps to resolve it (that message was 2147024809(80070057) and the item with the specified name wasn't found.)
Excel For Freelancers (4 months ago)
Thanks Vivek I am very glad you got this resolved.
Every thing tech (4 months ago)
https://www.youtube.com/watch?v=1tx82VoxAWY First Lesson in Microsoft word. This video describes the introduction and basic information about Microsoft office Word application. how to create a document in ms word and apply basic formatting (ribbon and tabs use, rand function, clipboard options, bold, italic, underline, text size, sub-script, super-script, text effect
Peter Erfe (4 months ago)
The Qty on hand formula is not working
Excel For Freelancers (4 months ago)
HI thanks you may want to check for #REF errors in your named ranges. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:http://bit.ly/groupexcel
Indian Monster (4 months ago)
Query : I have make Inward Outward register , but problem is product OUT in Diffrent-Diffrent Dates ......So i'm not Finding a perfect bill vice outstanding stock as per bill vice.......... and genrate reporting........... Can you intrested this query............???? Pleased MAKE THIS .............I'M WATING
Excel For Freelancers (4 months ago)
I am not sure I understand the question so if you post this question, with details and screenshots in our Excel For Freelancers groups we would be happy to help you. Thanks. http://bit.ly/groupexcel
Edward Fedee (5 months ago)
Good day love the video but i am stuck on the increment button
Excel For Freelancers (4 months ago)
Hi thanks a few people have been stuck on this. it seems many people for some reason are missing a space between "increment" and "30" make sure you put a space between that (just in case this was your issue too) I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:http://bit.ly/groupexcel
vivek pal (5 months ago)
I face run time error; that message was 2147024809(80070057) and the item with the specified name wasn't found. Please guide through you tube video.
Maurice Reece (1 month ago)
I am gettingthesame problem
Excel For Freelancers (3 months ago)
Thank you so much for your feedback and help. I do appreciate that. The problem could be that in some versions of Excel the Macro Name "MoveBtn" and the Shape Name "MoveBtn" are the same. Perhaps in some versions of Excel this is causing an issue. I have made corrections and updated both Part 1 and Part 2 so when you download the sample workbooks the fix is there (but you could easily fix this yourself by renaming the shape "MoveBtn1" then also changing this in both instances in the code. Thanks very much for your feedback
Regardt Basson (3 months ago)
hi @vivek pal i encountered the same problem but found a work-around... basically what happened is that when you entered a name for the shape (Oval) then software didnt accept it, recall that when you created the Macro you are naming the same based on the name that you are assigning on the excel window. All i did was to go back to the macro and inserted the actual shape name (Oval 2) in both instances and the macro then worked, i have no idea as to why excel didnt accept the name that we are supposed to enter for the shape. Hope this will solve your problem as it worked for me
Excel For Freelancers (4 months ago)
HI Edward, I am sure we can fix this in just a few minutes. Can you upload your screenshot and details in our Excel For Freelancers Facebook Group here: http://bit.ly/groupexcel Thanks so much.
Edward Fedee (5 months ago)
Same here did you get a solution
adit sumardi (5 months ago)
Why I Always stuck in Increment Left?
Excel For Freelancers (5 months ago)
Hmm i am not sure. I see people have this issue. Make sure there is always a space between the 30 and "increment". I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:http://bit.ly/groupexcel
vivek pal (5 months ago)
I am not able to create movebtn please help me for VBA project.
Violina Oktania (2 months ago)
vivek pal hai did you get your answer about move button.i am so frustrated to make it work T_T
Excel For Freelancers (5 months ago)
Hi thanks for your message. I have been focused on creating some amazing Excel courses for all Excel enthusiasts so I am unable to offer any one on one support at this time. However, I have created a Facebook group with 11,000 Excel Experts so that many of us can help you with your Excel questions. Can you please post your detailed question, with samples or screenshots directly in our group? If you have not Joined yet, please join here: http://bit.ly/groupexcel. This way we can get you the answers you need, fast.
favourits favourits (5 months ago)
Hi, thanks a lot for this useful video and amazing program, I really learnt a lot from you. And I have a question, that how I can prevent editing for specific cells which relate to product information and other cells which have formulas with out affecting running codes.
Excel For Freelancers (5 months ago)
HI thanks for your comment. You would need to protect only those cells with formulas, and unprotect the others. Then protect the sheet with a password. I hope this helps. Thanks for your support.
mahdi zahzah (5 months ago)
Thank you for this valuable information. I learned techniques that I never knew
Excel For Freelancers (5 months ago)
Thanks so much Mahdi, I am really glad you like the training.
MD Saiful Islam (5 months ago)
very nice,,,, please employee management software
Excel For Freelancers (5 months ago)
HI we are working on an amazing Employee Manager now, I have already done 4 parts and will release Part 5 on Tuesday. Here is Part 1: https://youtu.be/iyr9WIyxlJc
Sajid Khan (5 months ago)
Toooooo goood
Excel For Freelancers (5 months ago)
Thanks very much. I am glad you like it.
Abdul Kareem (5 months ago)
Can you ready "INVENTORY MANAGER" availabilities plz send . [email protected]
Excel For Freelancers (5 months ago)
Hi thanks you can download the free workbook using either of the two links in the description.
Muhammad Imran (5 months ago)
Abdul Wadood
Excel For Freelancers (5 months ago)
Thank you
MN Ariffin MN Yusoff (5 months ago)
This is an amazing guide! Thank you so much! Good Job!
Excel For Freelancers (5 months ago)
Thanks so much I am glad you liked it.
Being Anonymous (5 months ago)
I guess this video is specially for professionals not for the beginners. All the steps are too fast with less explanation. Thanks anyway ! Mz
Excel For Freelancers (5 months ago)
Hi thanks yes my lessons tend to be for Advanced Excel users since there are already hundreds of great channels that cover Excel Basics. Try the channel Excel is Fun for amazing learning of Excel fundamentals
Jitender Kumar (5 months ago)
Sir move button not response pls sir help me how to solve this problem Option Explicit Sub MoveBtn() With Sheet1 If .Range("B1").Value = "Purchase" Then .Shapes("MoveBtn").IncrementLeft30 .Range("B1").Value = "sales" Else: .Shapes("MoveBtn").IncrementLeft -30 .Range("B1").Value = "Purchase" End If End With End Sub
Excel For Freelancers (5 months ago)
Hi make sure there is a space between "Left" and "30" I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:http://bit.ly/groupexcel
hassan shiree (5 months ago)
i was doing this excel exercise but now i am stuck i need help the button not working giving me runtime error (-2114024809(80070057) the item with specified name was not found With Sheet1 If .Range("B1").Value = "purchase" Then .Shapes("MoveBtn").IncrementLeft30 .Range("B1").Value = "sales" Else: .Shapes("MoveBtn").IncrementLeft -30 .Range("B1").Value = "purchase" End If End With End Sub plzzz guide me sir
Excel For Freelancers (5 months ago)
Hi, make sure you put a space between "left" and "30" it should not be ".Shapes("MoveBtn").IncrementLeft30" but should be ".Shapes("MoveBtn").IncrementLeft 30" I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:http://bit.ly/groupexcel
Anis BEN (5 months ago)
Great Excellent Video
Excel For Freelancers (5 months ago)
Thanks so much. I am glad you liked it.
Rami al-yazedi (5 months ago)
How can I get the data in Product and Setup sheets ?
Excel For Freelancers (5 months ago)
Hi Rami, you can copy and paste your data into the product sheets. You can also customize this application to fit your exact needs. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:http://bit.ly/groupexcel
Jihad Halabi (5 months ago)
Really I am learning new things. Thanks a lot. But after writing the code for the button and trying it, I get the error message "Run-time error '-2147024809 (80070057)': The item with the specified name wasn't found.
adit sumardi (5 months ago)
Same case with me
Excel For Freelancers (5 months ago)
I am really glad you like the videos and training. It is hard to know the cause of the bug unless we can see a screenshot or your workbook. I have created a Facebook group with 10,000 Excel Experts so that many of us can help you with your Excel questions. Can you please post your detailed question, with samples or screenshots directly in our group? If you have not Joined yet, please join here: http://bit.ly/groupexcel. This way we can get you the answers you need, fast.
emmy onu (5 months ago)
am having problem from here, `On Transaction change, but not on Transaction Load or new transaction it return error "Compile Error Invalid Character" Please help.
emmy onu (5 months ago)
Excel For Freelancers  Thanks a lot, I did not have any problem with this part 1, I have completed it and it`s working fine till when I started with part 2. and that problem started with entering codes, (`On Transaction change, but not on Transaction Load or new transaction). The moment APOSTROPHE comes in. The problem is "apostrophe sign" (`) I don't know which signs to replace it. I have the problem using apostrophe sign on VBA code, and comma sign on Excel Formulas but I have solved Excel formulas problem. I use semicolon sign instead of comma sign on Excel Formulas. Please help me with ( apostrophe signs on VBA ) is there any other sign to use in places of apostrophe (`) or any other sentences to use. thanks
Excel For Freelancers (5 months ago)
Hi It's hard to know the cause of your error without seeing screenshots or your workbook. Please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:http://bit.ly/groupexcel
Ajmal Khan (5 months ago)
Excellent Video
Excel For Freelancers (5 months ago)
Thanks so much I do appreciate that.
Joory Al Hamed (5 months ago)
Creative and professional, thanks
Excel For Freelancers (5 months ago)
Thank you very much Goory, Much appreciated.
FAHAD KHAN (5 months ago)
I am trying to make as per your tutorial
Excel For Freelancers (5 months ago)
Yes sure I have commented on your other post the issue.
FAHAD KHAN (5 months ago)
This query is not working in Movebtn. .Shapes("MoveBtn").IncrementLeft -30 .Range("B1").Value = "Purhcae"
emmy onu (5 months ago)
the query working fine, check the Sheet number or Sheet name
Excel For Freelancers (5 months ago)
Hi Fahad, I think you are missing an "s" and have a misspelling, should be .Range("B1").Value = "Purchase" I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:http://bit.ly/groupexcel
Bugkiller666 (5 months ago)
WOW I'm learning, Thanks for sharing !!
Excel For Freelancers (5 months ago)
You are very welcome, glad I can help
Sofie Johari (5 months ago)
the 'developer' button did not appear in my tab. help
Excel For Freelancers (5 months ago)
Hi thanks I think you may have found it already in the options.
Sofie Johari (5 months ago)
i knew it
alwasim rony (5 months ago)
Really Awesome video
Excel For Freelancers (5 months ago)
Thanks so much Alwasim, much appreciated
lorenc bellovoda (6 months ago)
I wrote this code: Sub MoveBtn() With Sheet1 If .Range("W16").Value = "Blerje" Then .Shapes("MoveBtn").IncrementLeft30 .Range("W16").Value = "Shitje" Else .Shapes("MoveBtn").IncrementLeft -30 .Range("W16").Value = "Blerje" End If End With End Sub The first movement is OK but when I click to go right it doesn't work and highlight line .Shapes("MoveBtn").IncrementLeft30 by yellow. What's going on. I did every step as showed in the video.
lorenc bellovoda (6 months ago)
Fantastic. Thanks.
Excel For Freelancers (6 months ago)
You would need a space between "Left" and "30" I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:http://bit.ly/groupexcel
ricardo patacsil (6 months ago)
*sobs in frustration* everytime i write a function/formula starting from that mod with the even rows...even if i exactly copied what was shown in the video it says "we found a problem with this formula, please check blah for the formula, if youre not writing a formula..blah, your cell shows, formula shows, to avoid this issue put a apostrophe" HUHHHHdjfbsdbfsjdgfkesfbgfahfdbvsjvbdk
Excel For Freelancers (6 months ago)
Hi thanks for your comment, If types in properly it should not, however keep in mind that in some configuarations the comma should change to a semi-colon (Depending upon your settings) . The formula =Mod(Row(),2)=0 could be also =Mod(Row();2)=0 depending on your currency settings. You can read more about it here: https://lockone.wordpress.com/2015/08/06/excel-now-using-semicolons-instead-of-commas-in-separating-formulas-fix-it-now/ Let me know if this works for you.
Nischal Sijwal (6 months ago)
THANKS BUT COULD YOU SOUND SYSTME BE MORE CLEAR
Excel For Freelancers (6 months ago)
Hi thanks for the feedback. I will check my microphone settings so that it's a bit more clear.
Bruno Maia (6 months ago)
Hi! How can I make a Sale with more than one type of product (showing the products in diferent lines, how if the "type", "customer", "date", "client" and "total" were merged in all lines) using just one "New Transation"? Is it Possible? - I discovered your vids a fell days ago and I am seeing a lot of then! Thanks for the classes!!!
Excel For Freelancers (6 months ago)
Thanks so much Bruno, I am happy to help.
Bruno Maia (6 months ago)
+Excel For Freelancers Really thanks for your answer! I am just curious about Excel. I use it on my work and personal things. And I like to try the possible to make things better! But I am too far from really know a lot of Excel. So I think I will not can do it alone. I will search more about and try. Any way, I will wait for your course about it to learn better about. Thanks! And congratulations for all the quality!
Excel For Freelancers (6 months ago)
HI thanks for your comment. You could do this with an Invoice type of transaction in which Items are purchased together. This would be more involved, however I plan to release a course on this in the near future. Thanks so much for your comment. Happy to help.
Sir Ratr Brahe- Raz (6 months ago)
This is an amazing guide! Thank you! Also, I'm creating a button with 3 choices but it isn't working correctly. (PURCHASE / SALES / RETURNS). I believe it is running a loop with 3 choices in the macro. How is writing that slider macro different?
Dishant Yashwardhan (4 months ago)
Yes Sir plz make video on that topic also in which we can also maintain ecommerce returns data like this video.
Excel For Freelancers (6 months ago)
Hi thanks so much. I am glad you like it. With a 3 Choice option it may be easier to use 3 separate macros. Also you want to make sure to know the existing position that it is currently in, so based on the user choice you know to move it right or left and by how much. Its certainly possible. Give it a try then if you need help, please post your workbook and questions in our Excel For Freelancers Facebook Group here: http://bit.ly/groupexcel

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.