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

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

7033 ratings | 514884 views
🔥 Join thousands in my amazing Single Click Dashboard Reports Masterclass Here: http://bit.ly/Excel_Dashboard_Masterclass 💯 Get 100 Of My Best Workbooks in One Zip File Here: http://bit.ly/100_Workbooks 📗 The Ultimate Excel Resource Guide, with 1000 Excel Resources, is the last Excel resource you will ever need. See all of the details here: http://bit.ly/Ultimate_Excel_Resource_Guide 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 Applications used in making this video: 🎬 Camtasia Screen Recorder: http://bit.ly/CamtasiaStudioRecorder 📸 Snagit Screen Capture: http://bit.ly/SnagitScreenCapture ❓❓Got Excel Question? Let us help you with that, Join thousands of the world’s 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/Excel4Freelance 🌏Website: https://www.ExcelForFreelancers.com 🔗LinkedIn: https://www.linkedin.com/in/excelforfreelancers/ 👤Facebook: https://www.facebook.com/ExcelForFreelancers/ Thank you very much for your continued Shares and Likes, Randy Austin **I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep these training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.
Html code for embedding videos on your blog
Text Comments (408)
IE for Tujlapur Ausa (28 minutes ago)
can this see excel sheet ?
atul patel (2 days ago)
Please Gove me Downloads Link.
HI Atul, all download links for each video are in the description above.
please send me the vba codes for this part and the second one to my email address : [email protected] because i really need it. Thank you for sharing this video. I'm learning it step by step...
Excel For Freelancers (2 days ago)
Hi thanks for your comment. In the description of each video are links to get the Free Download of every workbook. This is the same for all 100 videos so you can follow along with the workbook. (Just check the links in the video description above)
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.
Excel For Freelancers (2 days ago)
Hi please make sure there is a space between IncrementLeft and 30 and also IncrementLeft and -30 Also you may want to rename the macro as well and reassign the name of the macro on the button (the macro name should not be the same as the button name) 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
Mylo Bernard (5 days ago)
Where can I purchase track, purchase and sales program that you creat it.
Excel For Freelancers (5 days ago)
Hello Mylo, I do not currently have one right now however I will start a Mentorship program next month in which we will create a full accounting application, with Inventory, Invoicing, and a Full Chart Of accounts, so when it's complete you can purchase the program (or you can join the mentorship program as we build it together) Just add your name and email here to be alerted when its ready to launch: https://www.ExcelForFreelancers.com
colaly100 (5 days ago)
I just watched another video that did the same thing you did but slower, I don't get the same menu when I right click as either of you..? different versions?
Excel For Freelancers (5 days ago)
Hi i am not sure what the other video used so it would be hard to know. I used Excel 2010 on a PC to create this. I hope this helps.
colaly100 (5 days ago)
ok this is going way to fast for me. I got the title in at 48 as describe. I can not figure out how you did that formatting thing right after. is there step by like exactly where click what like dummies i guess cause i'm not getting it. Sorry thanks.
Excel For Freelancers (5 days ago)
HI feel free to download the workbook using the links in the description this way you have the code in front of you which is a great way to learn.
Mohamed Morsy (10 days ago)
if you find debug error run time (438) you must make this command like this "Sub MoveBtn() With Sheet1 If .Range("B1").Value = "Purchase" Then .Shapes("MoveBtn").IncrementLeft (30) .Range("B1").Value = "Sales" Else .Shapes("MoveBtn").IncrementLeft (-30) .Range("B1").Value = "Purchase" End If End With End Sub"
Excel For Freelancers (10 days ago)
Thanks so much ,for the update. I see a lot of people having this issue. Adding a space between IncrementLeft and 30 or IncrementLeft and -30 also works. Thanks again Mohamed
Muhammad Hani (10 days ago)
Sir ! I make the INVENTORY MANAGER as you Taught here But I am getting an Error Debugging as are under Option Explicit Sub MoveBtn() With Sheet1 If .Range("B1").Value = "Purchase" Then .Shapes("MoveBtn").IncrementLeft30 .Range("B1").Value = "Sales" Else: .Shapes("MoveBtn").IncrementLeft -30 <------ (This line is showing Yellow in script , And MovBtn is not working ) .Range("B1").Value = "Purchase" End If End With End Sub
Excel For Freelancers (6 days ago)
HI i see the code above but you did not detail what the bug is now or the line that issue is on. If you can upload your screenshots (or workbook) to our Excel For Freelancers Facebook Group here: http://bit.ly/groupexcel We have 18,000 members who can help you with this. Thanks so much.
Muhammad Hani (10 days ago)
+Excel For Freelancers ! Good Afternoon Sir ! I did it before and I did it now , but the Problem is same can you give me Email address I will send you File to check Plz ? See the code : Option Explicit Sub MoveBtn() With Sheet1 If .Range("B1").Value = "Purchase" Then .Shape("MoveBtn").IncrementLeft 30 .Range("B1").Value = "Sales" Else: .Shapes("MoveBtn").IncrementLeft -30 .Range("B1").Value = "Purchase" End If End With End Sub
Excel For Freelancers (10 days ago)
HI Muhammad please make sure you have a space between IncrementLeft and 30 or Incrementleft and -30 Without this space you will get an error.
Zeljko Vidic (10 days ago)
Amazing. I cannot wait for next program. Are there possibilities for online lessons or....?
Excel For Freelancers (10 days ago)
Hi Zeljko I am so glad you enjoyed it. I will teach full Inventory, Accounting and Reporting in a Mentorship programming coming up next month. You can add your name and email to this list to be an Early Bird Member here: http://bit.ly/MentorshipProgram_EarlyAccess
Hajji Aly (10 days ago)
But I have something I did not understand. Can you help me pls
Excel For Freelancers (10 days ago)
Hi Hajji 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 18,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.
Hajji Aly (10 days ago)
Thanks so much for your Videos Part1 & 2. I have learned enough,
Excel For Freelancers (10 days ago)
Thanks so much. I -am really glad you are learning so much.
Dan Chester (15 days ago)
Love your videos. Very informative. How would your coding look if you had the same part number from 2 different vendors with different costs? And be able to track/auto update inventory from invoicing based on the FIFO (First In First Out) concept? Thank you in advance.
Excel For Freelancers (14 days ago)
HI Dan, you can email me here [email protected], however I am unable to offer any one on one support. The group is still the best place to get answers to your questions. Thanks so much.
Dan Chester (14 days ago)
Thank you for the quick response. Is there an email address that I can send the specifics to what I'm referring to? I would include snapshots of my Excel spreadsheets, invoicing, purchase invoice examples, etc to clarify. Then once a solution is figured, post a condensed version to the Facebook group for others who might have the same question.
Excel For Freelancers (15 days ago)
Hi Dan, thanks very much for your comment and I am glad you like the video. In the case you mentioned with the same part #'s and two different vendors, I would still have one single inventory items, however I would have multiple Vendor & Price Fields (Even perhaps a small table if there were many vendors that carried the same product) So in the Individual Inventory Item I would have a table of Vendors who carry that item, their part # (if it is different) and their quantities & prices. This way when you purchase an item, this item will be visible on the purchase order. When you create a Purchase order, then select a specific vendor, it is that respective vendor's prices and quantities that will show up on the Purchase Order (I am a former General Contractor, so it makes perfect sense to have multiple vendors with the same product) To track via LIFO/FIFO, you can create individual Purchase ID's for each part, then when they are sold, they can then be sold in the order that they were purchased.
Jim Harvey Guiyab (19 days ago)
Having trouble in moving the button after applying the macro T_T
Jim Harvey Guiyab (19 days ago)
+Excel For Freelancers Thank you
Excel For Freelancers (19 days ago)
Hi for some reason many people have problems with this. Please both make sure you have a space between "increment" and "30" or "increment" and "-30" (without that space it will display a bug)
盧艷儀 (19 days ago)
I'm having the same trouble with the moving button. It won't move lol. Please help, what's wrong with the code below? Option Explicit Sub MoveBtn() With Sheet1 If .Range("B1").Value = "Purchase" Then .Shapes("MoveBtn").IncrementLeft30 .Range("B1").Value = "Sales" Else .Shapes("MoveBtn").IncrementLeft -30 [It seems like this line got highlighted in yellow] .Range("B1").Value = "Purchase" End If End With End Sub
Sonya Wilson (24 days ago)
Hi, I loved your tutorial and I am trying my best to follow you. I believe that I missed at the very end of this tutorial how the customer, product #, etc. got filled out automatically when you selected row 21. Could you please help me out? Best regards
Excel For Freelancers (23 days ago)
Hi Sonya, thanks so much. I did that through the load item macro. If you download the workbook (through the links in the description) you can follow the code to see exactly how that was done. I hope this helps.
Abishek Bagdi (25 days ago)
I want to contact you. Can you share your contact details
Excel For Freelancers (24 days ago)
Hi yes sure you can email me here [email protected]
khadim Hussain (25 days ago)
nice lecture ,but could have been a LOT BETTER without cell formatting tips because the main purpose of this lecture is how to lay down formulas and macros functions for the inventory. background color cell formatting could be taught in a separate lecture. thanks for such a valuable information!
Excel For Freelancers (25 days ago)
Hi thanks very much for your feedback. Most of my videos I complete the formatting already, however some people want to learn from a blank worksheet, so this lesson would be for those who want to start from the beginning. Feel free to check out my other videos in which formatting is not taught. Thanks so much.
grey Mascara (27 days ago)
BUT DEBUG ERROR ->> If .Range(B1).Value = "Purchase" Then ---- can help me to resolve the issue I follow the code: 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 (25 days ago)
To get help with this issue, 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
grey Mascara (26 days ago)
Still doesn't work
Excel For Freelancers (26 days ago)
Hi make sure there is a space between 'incrementleft' and '30' This should fix the issue.
Adolfo Agustin (29 days ago)
sir thx for your contribution. excusame Sir could you help me how could I do a status monitoring from remote machines with excel. it showes ping, service from machines first sheet and second sheet showes history from those machines thanks in advance
Excel For Freelancers (28 days ago)
Hi Adolfo, you could use text files that get created on certain events and place those text files in a shared dropbox folder. This way as long as the folder is shared among remote machines, The machine can check the shared folder for changes. I go over how to do that in this video here: https://youtu.be/aKV5seZmiBs 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
AnT Santos (29 days ago)
I couldn't get the button to work. I got to the part of assigning it to the Macro but it doesn't move. It shakes when I hover over it. Did I miss a step?
Excel For Freelancers (29 days ago)
Hi it is hard to tell what is the issue with the code. If you can join our Excel For Freelancers Facebook Group here: http://bit.ly/groupexcel and post your code we can help you get it fixed. Thanks so much.
Nadeem Ali (1 month ago)
can you please create excel sheet like manpower or labor provider to different companies like when he join what his salary how to deduct advance amt from his salary if he notice left company before one month how to highlight and make data base of new job seeker and place each other like
Excel For Freelancers (1 month ago)
Hi Nadeem. I do have that in the Employee Manager series on my channel here. Thanks so much for the suggestion.
Ever Green (1 month ago)
I Do Some error in move btn marcos kindly help
Excel For Freelancers (1 month ago)
Hi that is a common error, please make sure there is a space between "increment" and "30"
Mark Ona (1 month ago)
Excel level - 10,000!
Excel For Freelancers (1 month ago)
Thank you so much Mark, I am glad you liked it
Chintamani Subedi (1 month ago)
Can you please send me a final templets I have tried a lot but cannot complete. gmail: [email protected]
Excel For Freelancers (1 month ago)
Hi please check your spam folder as well. You can also download from this link: http://bit.ly/InvMgrPt2_WbDl
Adilet Toroev (1 month ago)
it is great, thanks for tutorial video.
Excel For Freelancers (1 month ago)
Thanks so much. I am glad you liked it.
Shabbir Sheik (1 month ago)
TYSM for this amazing video... Can't we do it with script editor in google sheets?
Excel For Freelancers (1 month ago)
Hi I am glad you like the video. Google sheets can run some scripts however I am not that familiar with those scripts. Thanks very much for your comment.
Davesh (1 month ago)
Can you help me out for inventory management at google spreadsheet? I work in an office where we send the material to different site for installation and bill it later. So, for managing all this i require it to show on google speadsheets.
Excel For Freelancers (1 month ago)
Hi thanks for your comment. I am focused on Excel related work for now, however you can use the same formulas in Google sheets that I have used in Excel. Thank you anyways.
Omar Saidykhan (1 month ago)
Hi that's great but I don't know if there can a column or botton that give you your total amount of purchase/sales
Excel For Freelancers (1 month ago)
HI thanks Omar, you can download my version from the description in the links and customize it 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
Aprila Andi (1 month ago)
Too much playing in appearance design. More focuse on the core, that is the formula and the database linkage
Excel For Freelancers (1 month ago)
Hi Aprila, thanks very much for your feedback. I do appreciate that.
Anas Benz (1 month ago)
How do I change the price currency? it is dollars by default
Excel For Freelancers (1 month ago)
HI Anas, you can change the currency in Excel using a different accounting format.
Janith Perera (1 month ago)
Appreciate Your work much. Thank You.
Excel For Freelancers (1 month ago)
Thank you so much Janith, I am really glad you like it.
AL-AMIN Islam (1 month ago)
hello Sir ...[.Shapes("MoveBtn").IncrementLeft 30] this code are look like Yellow color
Excel For Freelancers (1 month ago)
Hi please join our Excel For Freelancers Facebook Group here: http://bit.ly/groupexcel and upload your workbook. We have 17,000 members who can help you, (I got your email but I am unable to offer one on one help as i get a few hundred requests a day)
Jazz Gill (1 month ago)
+Excel For Freelancers its still not working after putting space , please help
Excel For Freelancers (1 month ago)
HI Al-Amin. please make sure there is a space between "Left" and "30". If there is no space it will return a bug. I hope this helps.
iftikhar soomro (1 month ago)
HI SIR PLEASE SEND ME YOUR E-MAIL ADD I'M CONTACT WITH YOU
Excel For Freelancers (1 month ago)
Hi you can contact me here: [email protected]
Marcela Chaves (1 month ago)
Thank you so much for this! It's really helpful!
Marcela Chaves (1 month ago)
+Excel For Freelancers Great! I'll try it afterwards! Love the way you explain things! 😁
Excel For Freelancers (1 month ago)
HI Marcela, Thanks for your message. Yes, I understand what you are asking for. I do not have a training video on Estimates but I do have a product that I sell that has Estimates as part of it in Excel. The main product is called "Labor Burden Calculator" and the Estimate Add-on Tutorial can be found here: https://youtu.be/LQMubb4sKRE
Marcela Chaves (1 month ago)
+Excel For Freelancers Yes! It's been super helpful to create a system in Excel that can do exactly what you propose here. What I need now is another form that can do estimates. I can imagine that the same template can be used. Haven't really checked your other videos. I've been pretty much reproducing what you have here. It's so great! A lifesaver! :)
Excel For Freelancers (1 month ago)
You are welcome Marcela, I am really glad you like it.
Cameron Mclellan (1 month ago)
What would the formula look like if I needed to add a 3rd move for the button?
Excel For Freelancers (1 month ago)
Hello Cameron, you can crate a multi-state value in a hidden cell such as 1, 2, or 3. This value represents the current state of the button. Then when a user clicks a button, based on the current state (1,2, or 3) the button moves to the right or the left, accordingly. 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
MINHAS SAFDAR (1 month ago)
great dude
Excel For Freelancers (1 month ago)
Thank you so much. I am glad you liked it.
Vxcel (1 month ago)
Wonderful, great man
Excel For Freelancers (1 month ago)
Thank you so much. Cam on Em. :)
Hafiz Muhammad Asif (1 month ago)
Awesome sir....Your The Best...Loved our Tutorials....
Excel For Freelancers (1 month ago)
Thank you so much Hafiz, I am really glad you like this.
The Kid Empire (1 month ago)
I Love Excel So Much...
Excel For Freelancers (1 month ago)
Thank you so much. I am really glad you like it.
SONIA NAZMIN (1 month ago)
Dear sir,,,, Please send me the workbook. Thanks,
Excel For Freelancers (1 month ago)
HI thanks I have included the links for the download in the description above.
Azaad parenda (1 month ago)
how to download this excel ? please must reply
Excel For Freelancers (1 month ago)
Hi please download this free application using the links in the video description.
Sylvester Rozario (1 month ago)
Thanks for your presentation. Would you please send me the Excel link.
Excel For Freelancers (1 month ago)
Hello Sylvester, you can download a free version of the application using the links in the description above.
joshua pates (1 month ago)
is there any way i can try to download this workbook
Excel For Freelancers (1 month ago)
Hi yes sure with he email links in the description above you can have the workbook delivered to you or using your facebook messenger
peri noveriza (2 months ago)
sir...i learn much from your video..
Excel For Freelancers (2 months ago)
Thanks so much Peri, I am glad really glad you are enjoying the videos
streeteats (2 months 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 months ago)
Hi Street Eats, by holding down the Ctrl button and clicking, users can select multiple cells. I hope this helps
Adinew Tsegaye (2 months 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 (2 months 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 (2 months ago)
Kindly make excel for oil change shop inventory management
Excel For Freelancers (2 months ago)
Thank you very much for the suggestion. I will do my best.
Nikunj Vaghela (2 months ago)
Excel Formula for Cable Operator Will Make You Please...
Nikunj Vaghela (2 months ago)
Sir aapse jitna Ho sake utna To help kar sakte ho ki nahi...
Nikunj Vaghela (2 months ago)
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 (2 months ago)
HI thanks for your comment. I am not familiar with the Cable Operator Industry.
E WAR (2 months ago)
thank you for information brother,,,
E WAR (2 months ago)
Thank You Brother science, very helpful help give advice.To me about my vidio brother,,,
Excel For Freelancers (2 months ago)
For sure you are very welcome. Happy to help
woss2010 (2 months 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 (2 months ago)
Thanks,+Excel For Freelancers
Excel For Freelancers (2 months 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 (2 months ago)
can you recommend me which courses should I take to make such things
Excel For Freelancers (2 months 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 (2 months ago)
could you possibly send me the final template to [email protected] thank you
ghulam rabani (2 months ago)
Hey thank you very much. Please Upload a hd video
Excel For Freelancers (2 months ago)
HI for sure you are welcome. I will upload HD, no problem. Thanks
Fong Chin Weng (3 months ago)
Wow ! Thank you! You are an Master of Excel Manipulation.
Excel For Freelancers (3 months ago)
Thanks so much Fong, I am glad you liked it
muhammad obaid (3 months 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 (3 months ago)
+Excel For Freelancers Thanks alot sir!
Excel For Freelancers (3 months 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 (3 months ago)
What did you do at 12:42? All those columns changed their size so quickly...
Excel For Freelancers (3 months 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 (3 months 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 (3 months 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 (3 months ago)
very good
Excel For Freelancers (3 months ago)
Thank you so much Eric
Raisa Uy (3 months 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 (3 months ago)
Hi add a space between the word "Left" and "-30" This will fix the problem.
Raisa Uy (3 months ago)
It keeps on highlighting on this .Shapes("MoveBtn").IncrementLeft-30 (I don't know what to do)
Amana Agro (3 months ago)
move bottun setup problem hossea
Excel For Freelancers (3 months ago)
Hi add a space between the word "Left" and "-30" or "Left" and "30" This will fix the problem.
zeeshan akram (3 months ago)
Amazing sir
Excel For Freelancers (3 months ago)
Thank you so much Zeeshan :)
Abbiel Ballesteros (3 months 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 (3 months 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 (3 months ago)
Sir i need all coding of this because I'm facing some issues to do coding please
Excel For Freelancers (3 months 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 (3 months ago)
THE FIRST FORMULA SHOWS ERROR KINDLY HELP
ghulam rabani (2 months ago)
​+Excel For Freelancersdear sir please add me in the group, sir u how email?
Excel For Freelancers (3 months 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 (3 months ago)
Great, which weed do you smoke, i want to be smart like you... keep it up
Excel For Freelancers (3 months ago)
LOL. Thanks so much. I am so glad you love the videos. New training every Tuesday :)
Jay Singh (3 months ago)
Can i download and use it?
Excel For Freelancers (3 months 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 (3 months ago)
+Excel For Freelancers thanks. I couldn't locate download link. Please help me to find it
Excel For Freelancers (3 months 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 (3 months ago)
sir how to odd even rows colors this formula not work in my excel sheet.
Excel For Freelancers (3 months 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 (3 months 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 (3 months 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 (3 months 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 (3 months ago)
Hi you can click the links in the description to download the application for free.
Phanindra Aravapalli (3 months ago)
My email is [email protected]
stevan jaramillo (3 months 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 (3 months ago)
I believe that would help them for sure (We also have developers who speak Spanish as well)
stevan jaramillo (3 months 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 (3 months 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 (3 months ago)
the excel im using has no "developer" button next to "view" button.. what will i do then ?
Excel For Freelancers (3 months ago)
Hi you can display the Developers tab from the File > Options > Customize Ribbon > Check Developers Tab, or just use Alt + F11.
BlkQueenK (3 months ago)
You can do so much with Excel. Thank you for this 🙏🏾
Excel For Freelancers (3 months 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
Entertainment Plus Plus (3 months ago)
Very nice and useful video..request you to upload the same in hind plz
Excel For Freelancers (3 months ago)
Thanks so much. You can download the free workbook using the links above in the description. I hope that helps.
Abhishek Hulyalkar (3 months ago)
Hello sir, what is solution for "compile error expected: expression" ??
Abhishek Hulyalkar (3 months ago)
+Excel For Freelancers sure I'll upload it.
Excel For Freelancers (3 months 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 (4 months 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
Gopi Krishna (1 month ago)
+rajashree raje Once You check Moving Object name.. MoveBtn or some other else... !
rajashree raje (2 months ago)
Sir I all so facing the same problem plz how can I salve this issue
Excel For Freelancers (4 months 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 (4 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 (4 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 (4 months ago)
Are u an AI?
Excel For Freelancers (4 months ago)
Not since the last time I checked, but I will check again and let you know :)
bio Mechatronics (4 months ago)
Sir did u create microsoft?
Excel For Freelancers (4 months ago)
LOL. No, but I just love software, and I enjoy creating real solutions. :)
Symphony X (4 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.
Khaled Saad (1 month ago)
Hey I think I know about the formula it simple tray to use this >> ; not this >> ,
Excel For Freelancers (4 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 (4 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 (4 months ago)
Thanks so much. I do appreciate that.
Dream Paradise (4 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 (4 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 (4 months ago)
thanks for tutorials...
Excel For Freelancers (4 months ago)
For sure, you are very welcome
ROHAN ISLAM (4 months ago)
please speak slowly
Excel For Freelancers (4 months ago)
Thanks Rohan, I will do my best
Carlos R. Chavez (4 months ago)
Thanks my friend you're one of the best instructors I ever follow
Excel For Freelancers (4 months ago)
Thanks so much Carlos, I really appreciate that.
Talal Flew (4 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 (4 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 (4 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 (4 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 (4 months ago)
Vdo not clear
Excel For Freelancers (4 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 (4 months ago)
download link not available
Excel For Freelancers (4 months ago)
Hi thanks there are two links in the description they should both be working, (you can try both). Thanks very much.
Colin (4 months ago)
I don't know what kind of demon magic you possess. I wasn't even aware this was possible in Excel.
Mark Ona (1 month ago)
LMAO!
Brandi Rollins (2 months ago)
Lolol. @demon magic.
MsMunchy23 (4 months ago)
Ha ha ha took the words right out of my mouth lol
Excel For Freelancers (4 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 (4 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 (4 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 (4 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 (4 months ago)
Thank you very much Rom
Rom lef (4 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 (4 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 (5 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 (5 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 (5 months ago)
Actully excel is not for database, such kind of database should be create in java,C#,or oracle
Excel For Freelancers (5 months ago)
Thank you very much. I am happy to help.
amjad ahmadzai (5 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 (5 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 (5 months ago)
Hello can you please make atutorial for Accounts receivable system and collection connected with its ledger accounts?
Excel For Freelancers (5 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 (5 months ago)
Heloo Sir can you upload this file to any link so that we can download it easily
Excel For Freelancers (5 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 (5 months ago)
Hello, can we able to customize or your help t customize it?
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 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 (5 months ago)
the developer button where does it come.?
Excel For Freelancers (5 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 (5 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 (5 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 (6 months ago)
Sir do u have codes for school library software ..plz upload it
Excel For Freelancers (6 months ago)
Hi thanks for your message. I do not currently have any codes for a school library software. Thank you
Wishma Lowa (6 months ago)
hi i need to help me create macro zero qty based on the other column value please help men
Excel For Freelancers (6 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 (6 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 (6 months ago)
Hi thanks very much for the feedback. Much appreciated.
Chene Nowicki (6 months ago)
your videos are great man thanks for the knowledge
Excel For Freelancers (6 months ago)
Thanks so much and glad you like them

Would you like to comment?

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