📅Excel Calendar Pro: Your Solution to Stress-Free Scheduling 👉 rebrand.ly/CalendarPro_PinnedComm
@abuaseel1234
2 ай бұрын
HI where is the link for excel sheet ??
@basharalali5273
2 ай бұрын
Is this report available for free download ?
@barrymcki8489
2 ай бұрын
Hi Randy, is there a Patron upgrade version of this Inventory Management system ?
@joeleoalex6196
Ай бұрын
I wish I can buy only one that suits my requirement. A Pharmacy Inventory for a public hospital. You are a GENIUS ❤❤❤
@PRADEEPKUMAR-jc8nx
21 күн бұрын
hi
@Natureshoot312
9 күн бұрын
Waiting…. For more. I can’t find a word to thank you ❤❤❤❤🎉🎉🎉🎉
@ExcelForFreelancers
8 күн бұрын
Great, thanks so much. I am so happy you enjoyed this training. Thank you for your Likes, Shares & Comments. It really helps.
@Samuel_Nzubechukwu
Ай бұрын
Hello, thank you for this priceless piece of work. I am currently at 37:30 Please how did you get the Order_ID that match? Though I didnt see you show how you listed those functions in the name manager, i tried it but mine didnt pop up when i typed order_id Please can you show how you created the names in the name manager? Thanks
@ExcelForFreelancers
28 күн бұрын
Hi and thanks, yes i created the order id with a Named range such as =OFFSET(Orders!$A$3,1,,COUNTA(Orders!$A$3:$A$997)-1,1) I cover named ranges in this video: kzitem.info/news/bejne/2oOwnodrsqJzoJw I hope this helps and thanks so much.
@jameljames4835
Күн бұрын
Im in the process of working through this video now. Making some changes because the supplier menu doesn't matter to me, but being able to capture my recipes to get a total cost of ingredients does. But, i am curious if you think this DB can be translated to Google Sheets? Im not a Sheets person, but was wondering because of the anywhere availability of Sheets.
@ExcelForFreelancers
22 сағат бұрын
Hi and thanks very much. If you want to be able to use your data anywhere, you can follow my training on this. To share and sync your macro-enabled Excel workbook, please watch this training: kzitem.info/news/bejne/qG-M13ptsoBhgqQ I hope this helps and thanks so much.
@fabrictexture4767
11 ай бұрын
Stay Blessed
@ExcelForFreelancers
11 ай бұрын
Thanks so much. :)
@unknownrandom20
6 ай бұрын
How can I get the average cost of same product if I bought it from multiple vendors? Like from one vendor it cost me 5 from second vendor it cost me 6 from third it cost me 3. How can i get the accurate average cost for this product and how can manage it in this system
@ExcelForFreelancers
6 ай бұрын
Hi and thanks so much. You can add the total purchased Amount (all vendors) divided by the total purchased Qty (all venders) to get the average price. I go over this specifically in this training: kzitem.info/news/bejne/2nx8vIxmnn-deIY I hope this helps and thanks so much.
@Harthelos04
11 ай бұрын
Nice thumbnail, I legit thought Mr. Clean was gon' educate me.
@ExcelForFreelancers
11 ай бұрын
Haha thanks so much. Thank you for your Likes, Shares & Comments. It really helps.
@SamuelWristberg-wk3lo
Жыл бұрын
Hi please I want you to send me the template. Thanks
@ExcelForFreelancers
Жыл бұрын
Hi Samuel, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@Jason-96
Жыл бұрын
I just completed my first week at a new job in the warehouse and the weekly report in nuts. I spent all day cutting a pasting from one work book to another, then adding things up. It's nuts... I feel like I'm wasting so much time doing the same thing over and over. My goal is to somehow automate this report from what I've already put on excel. Wish me luck...
@ExcelForFreelancers
Жыл бұрын
I am sure you are going to do great. If you need help at any time, or jus looking for a straight answer to a question, feel free to join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@mjz2mjz92
13 күн бұрын
Best of luck Bro..... Can you please update with your story how did you manage all that
@calofc01s
Ай бұрын
why not just learn how to use database software at this point
@ExcelForFreelancers
Ай бұрын
Learning database software is always great. We use Excel because it is already on millions of computers around the world. Se we are taking the software to the people who are already using and comfortable with the platform. Thank you for your Likes, Shares & Comments. It really helps.
@SugarDose-o1w
Ай бұрын
I can't complete the videa because I don't have name manager :(
@ExcelForFreelancers
Ай бұрын
Hi and thanks so much. Some older versions of Mac's do not have a Name Manager. Please consider using something like Parallels which will mimic the Windows environment within a Mac. You can learn more about that here: www.excelforfreelancers.com/go/rwm-parallels-YTDesc I hope this helps and thanks so much.
@simonazukaite8989
28 күн бұрын
I get error for line 4 MenuNumb = Replace(Application.Caller, Left(Application.Caller, 8), ""). tells me aplication.caller =error 2023 and i cant do anything from there
@ExcelForFreelancers
27 күн бұрын
Hi and thanks for your comment. the Application.caller is the name of the shape that 'called' the macro (The name of the shape you used to click to run the macro) You can only run this macro from clicking a button. You will want to make sure not to run this macro from the VBA Editor. Please double check the name of the button. 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: bit.ly/groupexcel
@EmilioAltieri
2 ай бұрын
Hi Randy! I really appreciate this video! Unfortunately I'm stuck at the minute 30:44 I literally rewrote the formula =and($D8"",Mod(Row(),2)=0), but it keeps telling me there's a problem. I'm really frustrated and I'm only at the beginning of the video :(. Please I need help because I don't know what I'm doing wrong
@ExcelForFreelancers
2 ай бұрын
HI and thanks for your comment. The formula should be =and($D8"",Mod(Row(),2)=0) However with some language pages it will use a semicolon instead of a comma. I hope this helps and thanks so much.
@sasifexcelsolutions4509
Жыл бұрын
Now this is what we talking about, 3 days wait seems extremely long
@ExcelForFreelancers
Жыл бұрын
Great, thanks so much. I will be doing a lot more from scratch. I will try to keep them not so long, but some will be longer since its from scratch. Thanks for your continued support.
@okorouche6934
2 ай бұрын
Hi Randy, the workbook I got on the mail is corrupted and my PC sees it as malware. Any other means to get the workbook? Thanks
@ExcelForFreelancers
2 ай бұрын
Hi and thanks very much. The workbooks are certainly not corrupted since i program them myself. You would want to disable any antispam or antivirus you have on your computer, temporarily, so that it will allow the download of the macro-enabled workbook. Also, as an extra security measure, Microsoft disables macros from workbooks downloaded over the internet. You can fix this once and for all by following the steps I have outlined on this page www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/ I hope this helps and thanks so much.
@blaketorres2727
5 ай бұрын
The only question I have is, How can I make my sheet update everyday? At this point I will need to update the sheet everyday to keep the information accurate. if that is something I can do, would you please advise how to do it?
@ExcelForFreelancers
5 ай бұрын
Hi and thanks for your comment. This workbook contains many databases, what type of update did you need to make?
@atyuinnegi
Жыл бұрын
I need inventory management for WIP and FG. from the beginning of MFG. Till the end dispatch.
@ExcelForFreelancers
Жыл бұрын
Hi and thanks for your comment. I am not sure what WIP, FG or MFG is. Can you explain?
@atyuinnegi
Жыл бұрын
@@ExcelForFreelancers Work in progress,,, Finished Goods and Manufacturing
@ExcelForFreelancers
Жыл бұрын
Ah ok thanks for explaining it to me. Once this training goes live, feel free to watch the video then download the template. The template is open and unlocked and you are welcome to customize to add the feature you want. I hope this helps and thanks so much.
@ExcelForFreelancers
Жыл бұрын
Hi there, the Manufacturing & Bakery manager is scheduled for next Tuesday: kzitem.info/news/bejne/1IiAt5qAqp9nhJg I am sure you will enjoy it. Please like and share it.
@atyuinnegi
Жыл бұрын
@@ExcelForFreelancers yep..
@femiezekiel3622
Жыл бұрын
Hi.. 😢😢 You links have not been responding since yesterday and it's weaken my learning spirit😢😢😢
@ExcelForFreelancers
Жыл бұрын
HI and thanks, and sorry for the issue. Can you place the link that is not working here in the chat so i can check it out? I have not received any other reports of issues on links. Thank you
@desilvakts2071
15 күн бұрын
30:37 how did you suddenly come to mod(row2), please explain if there is a shotcut
@ExcelForFreelancers
15 күн бұрын
HI and thanks. Yes. I use AutoHotkey for that. I have a video on there here: kzitem.info/news/bejne/yKGjz4Khm6ihnno And another one on how to automate typing with an AutoHotkey library coming out in a week
@pygmesolutions
Жыл бұрын
It’s like drinking from a fire hose
@ExcelForFreelancers
Жыл бұрын
Hahah yes I know its a lot of content and a lot to absorb, but the more you watch the more you will be able to understand and create soon you will be creating them yourself Thank you for your Likes, Shares & Comments. It really helps.
@Yhob1
20 күн бұрын
😂😂😂
@anemicsilence
14 күн бұрын
😂😂😂👍
@TrangLe-zj7kq
Жыл бұрын
Many thanks for your hard work ! These are actually invaluable assets to have in Excel 💯
@ExcelForFreelancers
Жыл бұрын
Thank you so very much, I really appreciate that Trang and I am so happy to create them for you. Thank you for your Likes, Shares & Comments. It really helps.
@maejourney
7 ай бұрын
awesome for excel programmers (or whatever you call them). This is really free training. Grateful for your content. but for people like me, I'd rather buy the finish product :D
@ExcelForFreelancers
6 ай бұрын
Hi and thanks so much. I am glad to help. If you want I can have this customized and secured for you. Please feel free to email your requirements Randy@ExcelForFreelancers.com I hope this helps and thanks so much.
@theamarothman
6 ай бұрын
This is so detailed, so complex, so... so... fascinating. Thank you. I love it.
@ExcelForFreelancers
6 ай бұрын
Thank you so very much, I really appreciate that and so glad you enjoyed the training
@petercavallaro7051
6 ай бұрын
I am having loss of data in description column - could it be due to loss of ram available ???
@ExcelForFreelancers
6 ай бұрын
Hi and thanks for your comment Peter. It would not be due to a loss of ram unless you have a massive database. Most likely its a small VBA issue. Can you share your specific code within our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@catalinalanda3414
7 ай бұрын
could not formulte the colors that you did in the beggining minute 33 when entering ok nothing happens
@ExcelForFreelancers
7 ай бұрын
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@ABDULDADD
Ай бұрын
HI there, i facing a debug in supplier delete.how to resolve this.
@ExcelForFreelancers
Ай бұрын
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@rahbarkarim671
5 ай бұрын
Can u please share this Inventory management Excel File with me?
@ExcelForFreelancers
5 ай бұрын
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@marineau1
7 ай бұрын
Hey! where can i get this beautiful background? :)
@ExcelForFreelancers
7 ай бұрын
HI and thanks so much. I make all of the resources (Icons, pictures, backgrounds) for each training available on our Patreon platform here, along with a ton of other benefits. It would be great to have you www.patreon.com/ExcelForFreelancers
@larrybergeron7356
Жыл бұрын
New to the channel, love it, but I have been unable to download the free files. It says that I was successful and to look in my inbox. But they never show up. Three of the files are five years old, one is three weeks old, and this one.
@ExcelForFreelancers
Жыл бұрын
Hi Larry, thanks for your support and sorry to hear about that. If you have tried to download this workbook using the links but had a problem please email Shane@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
@somenmaji7078
Жыл бұрын
hello sir, When I was learning excel, I tried creating a system to take the input of students data and create a profitability chart. Your videos are very inspiring.
@ExcelForFreelancers
Жыл бұрын
That's great to hear. Thanks so much for sharing and I am glad you enjoy this training
@phantuanapl
Ай бұрын
Is this template working when multiple users update in the same time?
@ExcelForFreelancers
Ай бұрын
HI and thanks. This is not set up for multiple users however you can use my add-in here if you want to set it up for multiple users: kzitem.info/news/bejne/qG-M13ptsoBhgqQ Or you can use the features in this training: To share and sync your macro-enabled Excel workbook, please watch this training: kzitem.info/news/bejne/x5VnrqeIcmVhaH4 I hope this helps and thanks so much.
@fazirahmusa2720
4 күн бұрын
can buy your template sir? 😢 very hard to do it
@ExcelForFreelancers
4 күн бұрын
Yes for sure you can. You can purchase my 350 Excel template pack from here rebrand.ly/350Wkbks_Randy I hope this helps and thanks so much.
@IamMichelo
4 ай бұрын
I keep running into an error after assigning macros on the menu items: Run-time error '1004': Select method for Range class failed. When I try to debug, it highlights: .Range("A9").EntireRow.Select. kindly help
@ExcelForFreelancers
4 ай бұрын
Hi and thanks for your message. The first thing that comes to mind is that you cannot select anything (row, column or cell) unless that sheet is activated so try something like .Activate before that line of a code before the line with the bug. I hope this helps and thanks so much.
@IamMichelo
4 ай бұрын
Thank you. I solved this issue but I ran into another one. When assigning the 'SaveItem' macro to the save button. The button does not save, what could be the issue?
@ExcelForFreelancers
4 ай бұрын
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@barrymcki8489
Жыл бұрын
Just love your work. I've downloaded the sheet and started customizing it for our Not For Profit club. Learning a lot as I go along. I'm not sure if it was pointed out previously, but in the version I downloaded the Suppliers kept showing the Customers address. I looked back over the video at 1:42:41 and you have left the E6 and E7 values as Customers.Range instead of Suppliers.Range. Sorry if it has already been picked up. Cheers, Barry from Tassie Australia
@ExcelForFreelancers
Жыл бұрын
Hi Barry, thanks so much. I did see that and fixed the issue, and updated it for downloads. I also made other updates and added features on our Patreon platform update here: www.patreon.com/ExcelForFreelancers Thanks so much for your continued support
@qasimbashir9451
Жыл бұрын
Hi @barrtmcki8489. Were you able to modify it for a non profit? can you share amended excel as I need it for a non profit foundation I'm volunteering for? it will be of great help.
@clariseannelefanfe4857
6 ай бұрын
How do you do the other tabs? I cant seem to download the free template :(
@ExcelForFreelancers
6 ай бұрын
Hi If you have tried to download this workbook using the links but had a problem please email Angela@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
@AnwarHoosenNizamie
11 ай бұрын
Good Day. I purchased the 250 workbooks last year but can not find this lesson. Please advise
@ExcelForFreelancers
11 ай бұрын
Hi and thanks very much. this is a newer lesson that is part of the 300 workbook pack. It has been updated. Please feel free to email my accounts manager Shane shane@ExcelForFreelancers.com She will get you a special upgrade price which includes this Inventory Management System Workbook. I hope this helps and thanks so much.
@sifatqureshi5537
2 ай бұрын
Hello Sir Can you give me data for practice?
@ExcelForFreelancers
2 ай бұрын
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@SyedMuzammilMahasanShahi
Жыл бұрын
Thank you Randy for sharing this whole new level of awesomeness with us. God Bless you.
@ExcelForFreelancers
Жыл бұрын
Thank you so very much for your continued support Syed :)
@saeedahmed1261
9 ай бұрын
کیا اسے ڈاؤن لوڈ کیا جا سکتا ھے؟
@SyedMuzammilMahasanShahi
9 ай бұрын
جی بالکل کیا جاسکتا ہے۔ آپ کیا کرنا چاہتے ہیں ڈاؤن لوڈ کر کے؟@@saeedahmed1261
@GenetKidane-ij9tu
6 ай бұрын
Dear sir l have second interview by inventory Analyst please help me
@ExcelForFreelancers
6 ай бұрын
Hi and thanks very much. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@carrrie100
7 ай бұрын
Hi can this be used by multiple users and multiple machines at the same time?
@ExcelForFreelancers
7 ай бұрын
HI and thanks. yes for sure. To share and sync your macro-enabled Excel workbook, please watch this training: kzitem.info/news/bejne/x5VnrqeIcmVhaH4 I hope this helps and thanks so much.
@AamirBosan66
5 күн бұрын
Hello how can I get this XLSX file ???
@ExcelForFreelancers
5 күн бұрын
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@WiseRaboon9426
Ай бұрын
Hello is there a video where i can watch how to create the name manager data?
@ExcelForFreelancers
Ай бұрын
Hi and thanks so much. I discuss the Name Manager in this video kzitem.info/news/bejne/2oOwnodrsqJzoJw I hope this helps and thanks so much.
@userjustlearning
11 ай бұрын
can i have a trucking payroll and brookers payment one please
@ExcelForFreelancers
11 ай бұрын
Hi and thanks, you are welcome to download any template, for free, using the links in the description. Please feel free to search my channel for any related training and templates. I hope this helps and thanks so much.
@IsmailyNetworks
23 күн бұрын
Add Expenses and Stocks in this software
@ExcelForFreelancers
22 күн бұрын
Hi and thanks so much for your suggestion. You are welcome to download this template and customize it however you like. If you would like some help with this, we have a group with 60,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: 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.
@anab2462
Ай бұрын
Hello! I cant continue. I am in the =and($D8**,MOD(ROW(),2)=0) is giving me an error message when the first character is equal (=) Excel thinks it’s a formula, =1+1=2 to get around this tap an apostrophe (‘) I did that but it still not able to see the color rows 🙈 please help
@ExcelForFreelancers
Ай бұрын
Hi and thanks so much. In some regional settings, the comma is replaced with a semicolon. Please try this updated formula AND($D8"";MOD(ROW();2)=0) I hope this helps and thanks so much.
@simondavidson6005
Ай бұрын
I purchased the IMS, I am trying to add a new product with an inventory of 2 via the Inventory Management tab. It all seems good there. However, If I go to the products tab the inventory still shows 0...????
@ExcelForFreelancers
29 күн бұрын
Hi and thanks very much. When you make a purchase of a product, the formula will consider this a new item and add it to the Qty. Once it is sold it will be deducted. 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: bit.ly/groupexcel
@josedossantosl.6833
Жыл бұрын
Buenas, cual es el precio de este archivo?
@ExcelForFreelancers
Жыл бұрын
Hola y gracias, esta plantilla es gratuita. Puede descargar este archivo utilizando los enlaces en la descripción debajo de la palabra DESCARGAR. Espero que esto ayude y gracias.
@coffeekakumiro
4 ай бұрын
Hi Randy, thank you for the work here. on the Customers sheet, how did you get the asterisks into the criteria tables? and how do you create these criteria tables?
@ExcelForFreelancers
4 ай бұрын
Hi and thanks for your comment. The Asterisk are the wildcard characters used in the advanced filters. So you would manually type them in along with the value of the searched cell. These are common in Advanced filters. I have a training on that here: kzitem.info/news/bejne/uqt52HmNjmSFoGU I hope this helps and thanks so much.
@MrSteveribs
26 күн бұрын
I have discovered a number of "errors" in this workbook. For example if I go to PRODUCTS I see a list of products, some with negative quantities in stock, and yet I can go to Sales Order and generate a sales order. How can I sell an item that has zero or a negative stock balance on hand. Also if I go to products and change the negative stock quantity of a product to a positive stock quantity, the value of stock on hand remains a negative value in the product list. The value of stock on hand (in dashboard data) is also calculated incorrectly as it multiplies the stock on hand quantity with the purchase price PLUS the purchase price. In other words if the quantity in stock is 36 and the purchase price is $1.93 it shows the value on hand on the stock list as $69.48, which is correct, but the sheet marked dashboard data show the value on hand as $71.41 meaning the calculation is 36 x $1.93 PLUS $1.93(purchase price). The stock valuation on your dashboard is overstated and not therefore accurate.
@ExcelForFreelancers
26 күн бұрын
Hi and thanks for your feedback. I am sure there are hundreds of bugs and errors. I create these templates in just a few days and they are used for training purposes. They are free to download and act as a starting point for you to build your own applications on. They are free and you are welcome to download to use for anything you like, however if they were completed applications they would sell for hundreds of dollars each. I hope this helps and thanks so much.
@coffeekakumiro
3 ай бұрын
Hi Randy, please help with the way you came up with the criteria formula you deployed in the advanced filters. eg ="*"&'Inventory Management'!R4&"*". I have done some reading research but don't seem have it documented anywhere not even textbooks. I have a deaf friend who really is an enthusiast of excel, how I wish you could find him a transcription. He can read but impaired with hearing.
@ExcelForFreelancers
3 ай бұрын
Hi and thanks so much. I have Closed Caption, in 13 languages, including English, on every video. I also have specific videos on Advanced Filters. I hope this helps and thanks so much.
@shahasim
11 ай бұрын
Hi, can you please share link to download this file
@ExcelForFreelancers
11 ай бұрын
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@QuanNguyen-ff7xn
Жыл бұрын
Its sounds great! I'm really excited. Pls make this training as much more details as possible. Thks you!
@ExcelForFreelancers
Жыл бұрын
Hi and thanks so much. Yes, in this training I will be designing the worksheet from scratch, during the training, so you can follow along. I hope this helps and thanks so much.
@sasadacee7499
7 ай бұрын
IS there a VIdeo where all about menus is better explained? I watched this video 100x but even if I try to copy some of your codes it never work for some reason. Of course I edit the ranges data etc
@ExcelForFreelancers
7 ай бұрын
Hi and thanks very much. Please check out our School Management series in which I show you how you can create your own Excel applications, from scratch, in an amazing series right here: bit.ly/SchoolManagerSeries I move a bit slower in this training and it should help
@sasadacee7499
7 ай бұрын
@@ExcelForFreelancersThank you again. You are really a crack :)
@ExcelForFreelancers
7 ай бұрын
Thank you so very much, I really appreciate that
@programminggeek1875
6 ай бұрын
Thank you for providing such helpful content. I'm currently working on modifying the template, but I've run into some difficulties. Could you please recommend any specific videos or resources where I can learn more about making modifications? My main issue arises after the 36:18 mark, as the worksheet design includes multiple sheets and I need to delete certain columns in both the customers and suppliers sheets.
@ExcelForFreelancers
6 ай бұрын
Hi and thanks very much. If you delete columns, this requires modifications to the code, formulas, formats and functions across many macros within the code, so there would not be a single video to show you how to do this. You may want to hide the columns. To learn more about VBA I have a beginners series here kzitem.info/door/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z If you would like some help with this, we have a group with 60,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: 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.
@programminggeek1875
6 ай бұрын
@@ExcelForFreelancers thank you
@jameljames4835
5 сағат бұрын
Question, you've got it setup to show 108 rows, what I want to know is there a way to have it show I say groups of 30 and then you have to hit a button to go to the next 30?
@yaranassar1208
7 ай бұрын
I have a question on 1:22:00 when working on the search customer feature. I copied your code for the Product_RefreshList() function and I'm changing the values and columns exactly to fit mine but it is not working I don't know why. The results table isn't changing. It is always empty. I have been trying to fix it for the past 2h and nothing is making sense please I need some help
@ExcelForFreelancers
7 ай бұрын
Hi , Thanks for your comment. Please make sure to double check the Advanced Filter Criteria. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@yaranassar1208
7 ай бұрын
Okay I requested to join and will see@@ExcelForFreelancers
@yaranassar1208
7 ай бұрын
Done, I uploaded the screenshots @@ExcelForFreelancers
@ExcelForFreelancers
7 ай бұрын
Ok very good, thanks so much. I was able to find the solution and point out the issue in our group
@d3vil041
2 ай бұрын
Hi Randy, everytime i add a new product the "in stock" value dosnt reflect in the products worksheet. it remains 0 in products worksheet which causes "value on hand" to remain blank until i manually change it in the products worksheet only then will it do the math for "value on hand". any idea how i can fix this
@ExcelForFreelancers
2 ай бұрын
Hi and thanks very much. The 'in stock' is a calculated value based on the # of purchases minus the number sold. To set an initial value, you can create a purchase for this item which will set that value (If I were going to make an update for this application, I would add a table of 'Inventory Starting Quantities' and then take the values into consideration as well) I had to keep it simple for this training. You would not want to change the value manually in the database since this is a formula. I hope this helps and thanks so much.
@treauy912
3 ай бұрын
fascinating to see people who know how this works
@ExcelForFreelancers
3 ай бұрын
Great and thanks so much. I am so glad you enjoyed the training
@jaygreentree4394
11 ай бұрын
Excel is a messy way to do business. Use modern technologies that are available.
@ExcelForFreelancers
11 ай бұрын
Millions of people, including most governments around the world, have chosen Excel for nearly 50 years, so I guess a lot of people love getting messy :)
@slminc
11 ай бұрын
@jaygreentree4394 is it possible for you to share the confirmation from Microsoft where they discourage the use of Excel considering the statement you made “Messy”. I have been using Excel to analyse aircraft components using Finite Element Analysis on Landing Gears. The big aircraft manufacturers adopted some of the recommendations into standard repairs. Still today my previous company is still using Excel. I am talking about 2008. Even a link that confirms your statement, one of the world-renowned Audit Firm is highly reliant on Excel. And they are making Huge profits. I will await you response with the links confirming that statement you made. The link must contain the statement “messy”.
@joshuawoods1878
Жыл бұрын
Hey Randy thanks for all of this so glad i found your channel right whn i needed it. So having to ho through a crash course of excel as we lost our guru. These have been awsome to learn new stuff by building. But i have an issue i have not been able to figure out how you did it. Aroun an hour and eight mins into the video you go change all of your tables and update them to not include the column of row to be displayed. There has to be an easy way to do that without messing all of the tables and formats up. I can see removing column adding column reshaping box format can be done for each. I just wondered what approach you did so if i can fix mine i am building step by step. And i can fix in the future if i encounter it again. Thanks
@ExcelForFreelancers
Жыл бұрын
Hi and thanks very much. I am glad you liked the video. Anytime I bring over data from an original table, if i have to edit that data, I generally bring over the database row. I will put that in an adjacent column. To hide this, there are 3 methods. (Hiding the column, matching the font color with the background color, or in this case I used a custom format with either two semicolons ;; if its only numbers, or 3 semicolons ;;; if it is a mix of numbers and letters. This is a custom cell format. Please feel free to download the sample workbook. I hope this helps and thanks so much.
@scottknox8817
3 ай бұрын
Not sure if this is training you have been doing for a while as you seem to have a lot of data already
@ExcelForFreelancers
3 ай бұрын
Hi and thanks very much. I try to add as much data as possible for every training. I hope this helps and thanks so much.
@parinose6163
4 ай бұрын
Hi Randy! Thanks for the IMS template! How to get rid of the pub inside? Thx in advance!
@parinose6163
4 ай бұрын
Ok! I got it...
@ExcelForFreelancers
4 ай бұрын
HI and thanks for your comment. I am glad you were able to get it. As an extra security measure, Microsoft disables macros from workbooks downloaded over the internet. You can fix this once and for all by following the steps I have outlined on this page www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/ I hope this helps and thanks so much.
@AmeenahMuritala
5 ай бұрын
Thank you very much for this Inventory Management System. I really love the free template as it would be a great way for me to track my sales, customers, purchases etc. But I'm not really a techy person and I tried editing the free template but I keep running into bugs. Please how can you help me? Thank you. I run a small business and it would really help with my limited resources.
@ExcelForFreelancers
5 ай бұрын
Hi and thank you for your comment. If you would like some help with this, we have a group with 60,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: 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.
@rhondahill3269
11 ай бұрын
NOT FOR BEGINNERS!! I need to find something that a complete beginner to Excel can build some type of inventory tracking for a small company. This video seems to be for more advanced users. Needs LOTS more explanation and connecting the info (why do I use this code/format, for what purpose, how does is work) etc.
@ExcelForFreelancers
11 ай бұрын
Hi and thanks. Yes that is correct, that this video is for intermediate to advanced Excel/VBA users. However, I have decided to add a new weekly video on Saturdays that is specifically for beginners of VBA, and we will start from the beginning. You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBACourseRandyShared I hope this helps and thanks so much.
@spunky143143
6 ай бұрын
We're a crystal store that creates products like jewelry and home decor. I am looking for a workbook in which I can break down the costs, do markup, and split profit with partners. Are you able to help?
@ExcelForFreelancers
6 ай бұрын
HI , thanks for the information. There is no doubt we can help you with that. While I am unable to take on any projects I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com Thanks so much.
@sonjacoetzer5544
8 ай бұрын
Hi Randy I need help, I do have a Excel Stock Control Sheet of my Pesticides, Fertilizers and Seed but know I want help on the following: On each block on the lands we uses pesticides, fertilizers, and seed, what I want to do is if I fill in the information onto my blocks how can it pull through to my stock control sheet automatically. Hope you understand
@ExcelForFreelancers
8 ай бұрын
Hi Sonja, Thank you for your comment. If you would like some help with this, we have a group with 60,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: 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.
@TheLegend_lab
2 ай бұрын
Hi Randy, your teachings are great however, they are more advanced. I think maybe the missing part of these trainings is only two things otherwise we could have the detailed training. I don't mind if these trainings can take 2 or three hours as long as it is something that someone can follow without asking so many questions and be able to develop something from your programs Here are my Suggestions: 1. Losing the link on the name managers and applying it to the formulars. This is missing more detailed on how it is done and where it is extracting from. This part is very important! 2. Prepopulated the VBA codes. It would be good to start all your codes on the same template you have created from the beginning. We get lost on the middle of the way and we ended up not completing these trainings because you explain code and not making it with us. Unless you have any other class where we can learn this that will be good since we are new babies on these codes. However, the finish products of your work are brilliant always.
@ExcelForFreelancers
2 ай бұрын
HI and thanks so much for your comment and feedback. I do appreciate that. When it comes to basic VBA, each Saturday I create a Basic VBA Training and I have 36 VBA Basic trainings here kzitem.info/door/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z Concerning writing code and design. On any basic template, I can create it from scratch during the video. I have an entire series of 'from scratch' training you may like here: kzitem.info/door/PLIBeRriXvKzCHVxFYRSMTZu3PmnVn4ujb Please also keep in mind that the template I use for training is available for free using the link in the description. You may also want to check out our School Management series in which I show you how you can create your own Excel applications, from scratch, in an amazing series right here: bit.ly/SchoolManagerSeries
@arcle3853
3 ай бұрын
Hello, I haven't watched the entire thing yet but I just wanted to know ahead if this is possible to be done in a way that multiple people can interact with the inventory system and update in real time? I'm new to excel and I'm not sure if it can do that besides just downloading the file and passing to to others. I was also thinking if this is doable in Google Sheets instead?
@ExcelForFreelancers
3 ай бұрын
Hi and thanks. Yes for sure its possible. You can use my Share & Sync addin here: kzitem.info/news/bejne/qG-M13ptsoBhgqQ I hope this helps and thanks so much.
@darinbeyerable
11 ай бұрын
do you have something similar but allows me to have inventory at several store locations -
@ExcelForFreelancers
11 ай бұрын
Hi and thanks for your comment. I have added Locations onto this template for our Silver & Gold Patreon members here: www.patreon.com/posts/store-management-90632852 Feel free to join us on Patreon I hope this helps and thanks so much.
@slminc
11 ай бұрын
Nice and easy 🎉
@debnathmriganka2010
10 ай бұрын
Sir Can you help me to make a Printing and Packaging Press Company full software for Exel sheet for costing, ups everything ?
@ExcelForFreelancers
10 ай бұрын
Hi there, Thank you for your comment. If you would like some help with this, we have a group with 60,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: 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.
@chrisbriley
10 ай бұрын
Hi Randy, please help…. 49:22 I keep getting “compile error: Variable Not Defined” and where it says “Sub Menu_Select ()” its highlighted in yellow, and “InvMgr” is highlighted in blue
@ExcelForFreelancers
10 ай бұрын
Hi Chris, thanks for your comment. That would probably mean that you do not have a sheet with a code name "InvMgr" so you would want to make sure you give the sheet a code name of InvMgr. 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: bit.ly/groupexcel
@chrisbriley
10 ай бұрын
@@ExcelForFreelancers I figured out what happened, I deleted the first screen that you were working on from your template and started from scratch following along with you, but in the VBA that screen is no longer an option and I’m not sure how to put it back
@ExcelForFreelancers
10 ай бұрын
Hi and thanks so much. You may want to download a new version from the link you supplied so that you have two different copied to compare. I hope this helps and thanks so much.
@Cuursedd
4 ай бұрын
Can you provide a source for where you got those stock images if possible?
@ExcelForFreelancers
4 ай бұрын
Hi and thanks I create the images with Midjourney: www.midjourney.com I hope this helps and thanks so much.
@Cuursedd
4 ай бұрын
@@ExcelForFreelancers thanks it does
@Cuursedd
3 ай бұрын
Thanks
@jamesbaxter2812
11 ай бұрын
Can this work in LibreOffice Calc
@ExcelForFreelancers
11 ай бұрын
Hi and thanks very much. The templates I build only work on Microsoft Excel. I hope this helps and thanks so much.
@agvets3011
10 ай бұрын
Sir, Can you help regard coding?
@ExcelForFreelancers
10 ай бұрын
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, since I get literally hundreds of request for help per day. However, I have created a Facebook group with 60,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: bit.ly/groupexcel. This way we can get you the answers you need, fast.
@justinecardellantolin4138
8 ай бұрын
Hello Sir, I'm stuck at adding name ranges because I don't have sources. I hope you can help me. Thank you!
@ExcelForFreelancers
8 ай бұрын
Hi, you can download this file using the links in the description under the word DOWNLOAD to help you with the named ranges. I hope this helps and thanks.
@gmstationph
8 ай бұрын
hi I am really happy about your work, Quick question, How can I reduce and add quantity to the product for every purchase and sales i have? so If I purchase items, quantity should add to the product, and if I have sales quantity of the product should be deducted. how can you do it?
@ExcelForFreelancers
8 ай бұрын
Hi and thanks very much. I show you how to do that in my recent Userform Point Of Sale training here: kzitem.info/news/bejne/mpifqXaCsHefmoI I hope this helps and thanks so much.
@waddlescustom4637
11 ай бұрын
Does this same template work in Google Sheets
@ExcelForFreelancers
11 ай бұрын
Hi and thanks for your comment. This would only work in the desktop version of Microsoft Excel. I hope this helps and thanks so much.
@gangan-mh
10 ай бұрын
If i were to copy it and design the same way it'll still take a week fir me lol
@ExcelForFreelancers
10 ай бұрын
These things do take time, but it gets faster as you do it more often. This would have taken me 6 weeks not too long ago. You are doing great
@benhennisidahmed1318
Жыл бұрын
Plz i need application point of sale pressing ❤
@ExcelForFreelancers
Жыл бұрын
I have 10 different Point Of Sale trainings with free templates here: kzitem.info/door/PLIBeRriXvKzBohiJA68HSrtetepIR4Nna I hope this helps and thanks so much.
@NPE360Life
Ай бұрын
I'm at 37:32 and where can I learn to do this part? Or is this something I have to buy?
@ExcelForFreelancers
Ай бұрын
Hi and thanks in this time period we are just doing an Index/Match formula. What is your specific question?
@NPE360Life
Ай бұрын
@@ExcelForFreelancers do you have a video that goes over what you were doing or the part where you built that? I'm not familiar with that process. 37:29 shows many formulas. you were showing, for example formula =OFFSET(Customers!$A$3,1,,COUNTA(Customers!$A$3:$A$9998)-1,1) and a column highlighted. I just tried to do it and got errors. I'm stuck at this part
@ExcelForFreelancers
Ай бұрын
Hi there, Please make sure your sheet name is correct "Customers". It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@deondejager6165
Жыл бұрын
Hi Randy. Thank you for an awesome lecture. Is it possible to get the formulas for each as we go along. I'm stuck at the first formula 🙈🙈=and$D8**,Mod(Row(),2)=0) and can't continue 😫😩. Not sure if I can see the formulas so clearly on the screen. Thank you very much.
@ExcelForFreelancers
Жыл бұрын
Hi and thanks so much. the formula is =and($D8"",Mod(Row(),2)=0). However, you can download this file for free using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@deondejager6165
Жыл бұрын
@@ExcelForFreelancers Thank you very much. I want to try to create it myself. I want to learn more.
@ExcelForFreelancers
Жыл бұрын
Yes of course, I understand. Its a great way to learn and thanks so much
@Bob-zy4rt
7 ай бұрын
Awesome app but quick question. Wanting to use this for work, but how would I go about adding an order from a seperate excel workbook?
@ExcelForFreelancers
7 ай бұрын
Hi and thanks you can link the workbook in the admin screen with the file path, however i do recommend having all of the data in the same workbook for speed and ease of use. I hope this helps and thanks so much.
@sasadacee7499
8 ай бұрын
Hello there. I am following this training but at the part where we should link formulas from name manager I cant continue. My name manager is empty while yours is full. Is there a toutorial how to fill it properly?
@ExcelForFreelancers
8 ай бұрын
Hi and thanks please feel free to download my template for free so you can see all of the named ranges. You can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@adarshagnihotri3228
6 ай бұрын
can you please suggest your videos for all the data that you have put, I'm having problem after 35:00 in understanding other sheets workflow.
@ExcelForFreelancers
6 ай бұрын
Hi and thanks for your comment. I am not sure what you mean by 'all the data that you have put'? The data I use in these templates is just sample data. You can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@amponsemmatthewkweku8971
10 ай бұрын
Please when I delete a product it says error
@ExcelForFreelancers
10 ай бұрын
Hi and thanks, make sure you step through the code to ensure that you have a correct row number and sheet 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: bit.ly/groupexcel
@saajanbarham1987
Ай бұрын
i wanted to make GRN in excel need help
@ExcelForFreelancers
Ай бұрын
Hi and thank you for your comment. If you would like some help with this, we have a group with 60,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: 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.
@keitamoussa2229
Жыл бұрын
Hey Randy AUSTIN, thanks so much for your mind-blowing tutorials. You don't know how life-changers your courses are to me !!!!
@ExcelForFreelancers
Жыл бұрын
Thank you so very much, I really appreciate that Keita, I am really happy to help and share
@abdullahquhtani8058
10 ай бұрын
what if there are Mutiple locations??
@ExcelForFreelancers
10 ай бұрын
Hi and thanks so much. I have added a 'Location' feature on the Patreon update here: www.patreon.com/posts/inventory-system-84095833 I hope this helps and thanks so much.
@ExcelForFreelancers
11 ай бұрын
🤖Speed Up Excel Tasks with AI-Powered Solutions ► bit.ly/AIToolpack_Com
@nosyparker10
Жыл бұрын
Hi.. I tried this.. into my excel. It is good at first, but when the data come to 50 above sales.. the calculation start slowing down the entry process. Currently the files become 157MB. Original files is 17MB. Any suggestion to reduce files size? Approx now is 2.8MB per Sales order.
@ExcelForFreelancers
Жыл бұрын
Hi and thanks very much. That seems quite high. You can limit the named ranges and cell formats to just the used area. On the database sheets you can remove all formats as well. You can also remove unnecessary pictures on the dashboard. The size seems quite high as data itself should not be that much. Formatting can take up a lot of space so you may also want to limit the conditional formatting. I hope this helps and thanks so much.
@joeleoalex6196
Ай бұрын
I am trying to help this district hospital create a manageable pharmacy inventory. Love all your tutorials. Trying to work around to create one. ❤❤❤love all your work. Cherrs.
@ExcelForFreelancers
Ай бұрын
HI and thanks so much. Please check out my Pharmacy POS here: kzitem.info/news/bejne/zaaAnJOvp4KmiGk I hope this helps and thanks so much.
@eastonturnage8462
9 ай бұрын
Do you have any templates or demos on any inventory management/POS excel based systems? Looking to track bulk inventory moving in and out from a warehouse. Would like to have it automatically update the system when removing or adding to the overall inventory. An added plus would be to have barcode scanner capability. Thanks!
@ExcelForFreelancers
9 ай бұрын
HI and thanks so much. I have an entire playlist of POS Systems here: kzitem.info/door/PLIBeRriXvKzBohiJA68HSrtetepIR4Nna I hope this helps and thanks so much.
@andyneal3317
Жыл бұрын
Thank you i did download your file & it opens allowing me to view everything. butcan i change things like $ to other signs also replace datawith my own. I did try but it will not update or change anything.
@ExcelForFreelancers
Жыл бұрын
Hi and thanks so much. yes you can change any part of the file. To Change the currently please go to Formats and update the currency to anything you like. I hope this helps and thanks so much.
@darwinsarchived
4 ай бұрын
Hello Good day. Great tutorial. How the "In Stock" works? just tried your file. and how i know how many stock left?
@ExcelForFreelancers
4 ай бұрын
Hi and thanks so much. Essentially the Total Amount Purchased for a given item - The Total Amount Sold for a given item is the Quantity On Hand. I hope this helps and thanks so much.
@nurhidayahbintizaini8710
Жыл бұрын
Hi, I have a question. Will this system works on excel 2013 and below? Thank you.
@ExcelForFreelancers
Жыл бұрын
Hi and thanks, yes this will work on any version including 2007 and after. I hope this helps and thanks so much.
@rabiatula.abdullah8543
9 ай бұрын
I have a problem about menu button. It only show up if I click purchases button but if I click other than that t doesn't show up just the list only 1:02:04
@ExcelForFreelancers
9 ай бұрын
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@Isaacasare5
Ай бұрын
I have been watching you and I have seen that you don't show us how to save the entire work for future use. So please
@ExcelForFreelancers
Ай бұрын
Hi and thanks, you will want to save this as a macro-enabled workbook (xlsm) i do cover that here kzitem.info/door/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z I hope this helps and thanks so much.
@josephwaki4949
6 ай бұрын
The conditional formatting formula is not working in my excell spreadsheet😢
@ExcelForFreelancers
6 ай бұрын
Hi Joseph, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@info.kbslogisticfurniture834
4 ай бұрын
can you tell me how to get this file please
@ExcelForFreelancers
4 ай бұрын
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@airdrop_adviser
Ай бұрын
What about sales return data. When customers return the product to get replace or sometimes get refund. Please add this one to complete full inventory management software.
@ExcelForFreelancers
Ай бұрын
Hi and thanks so much. I have completed this template however you are welcome to download it and customize it however you like. I hope this helps and thanks so much.
Пікірлер: 680