Peoples are calling me an Excel Expert even though i am still learning it is all by #Excel_For_Freelancers. I feel nothing better than getting someone like respected Mr. Randy here on UA-cam.
Hey! The amount of effort you have put in each and every video needs to be acknowledged. Giving so much value... You are amazing. Keep up the good work!
Thank you so very much, I really appreciate that Jain. Certainly a lot of work, but its well worth it. You will love the one coming out next Tuesday on Clinic Management here: ua-cam.com/video/9oebyN-ivhU/v-deo.html Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers I need Excel sheet to manage Jet Fuel Farm stock We have 8 Tanks for each Tank: Tank Nominal: 53000 Ltrs Tank Capacity: 50000 Ltrs and three Sample Tank: 1 Tank Capacity: 800 Ltrs. 1 Tank Capacity: 800 Ltrs. 1 Tank Capacity: 600 Ltrs. We have non-blended (Jet A-1) and blended with FSII & CI (JP8) We have One Unloading Meter We have One Loading meter for Tank 1 to Tank 6 We have One Loading meter for Tank 7 and Tank 8 Aviation Fuel Farm Tanks Management: -Receipt (Purchase). -Issue (Sale). -Credit (Defuel or Return back to Tank). -Transfer fuel from vehicle. -Transfer fuel from sample tank. -Transfer fuel from Tank to Tank. -Circulation Fueler Trucks Management: - Refuel Aircraft from Fueler Truck. - Defuel from Aircraft to Fueler Truck. - Circulation. - Transfer fuel From Fueler Truck to another Fueler Truck. We have a DIP Chart and System Digital Reading We need a daily, weekly, monthly & annually Report for Tanks, Fueler Trucks and Customer wise.
Thank you for this educational course. I am working with Excel for a couple of years and learnt to use VB myself. Now I also understand 'INTERSECT'. Very revealing explanation.
WOW .. Sir you're a real genius.. Thank you so much for teaching us by sharing this amazing solution.. I used to do a lot (no code!) in Excel but for years I was away from it.. Now your generosity is going to encourage me again ...
Dear Sir. Both Part I and II were excellently presented. Thanks. I would like to recommend a minor change in logic. The Price with which we purchase from Vendors is same as the Price we sell to Customers. Ideally, the Cost Price and Selling Price should be separate fields. Thanks for making VBA interesting for all of us👌👍👍
Hi and thanks so much. I have an updated version, based on your suggestions, right here: ua-cam.com/video/SbjBgqzbA3w/v-deo.html I hope this helps and thanks so much.
Hi Randy, watching the video, I find this is good for tracking inventory totals, but I don't see anything in the program that identifies the location of the inventory which should be part of any inventory program. This would help for inventory picking, restocking, annual physical counts etc. What would be helpful if there were additional fields added for physical location, ie building, row, shelf etc. I have no VBA experience whatsoever, so modding the program for me would be a daunting task. Maybe in future update consider adding a location. Thanks for all of the hard work making these videos/programs, your time and effort is much appreciated.
HI and thanks so much. You are welcome to download this application and customize it however you like by adding additional fields such as Location or anything else. I hope this helps and thanks so much.
It's not that bad to add extra fields, you'd just need to add them to your original box, make sure you map them just like the other boxes, and make sure the fields clear when you go to add a new transaction or item number. I did then when I was following along with the video, added an extra 3 fields or so. I have no visual basic experience prior to this.
Hi David, thanks so much for your comment for each transaction such as a sales invoice you can save a history of transactions, so you would just save the price it is sold at within a table. Then, changing the sales price would only affect future purchases. This video on Invoicing may help you with that: ua-cam.com/video/99xVbVMABJ0/v-deo.html
I noticed for this inventory manager that if you click the column headers D to K Range("B1") goes blank, this causes the button to shift to the left , making the button going out of bounds.. For those who are beginners like me, you can simply add a code in in sheet1 (If Sheet1.Range("B1").Value = "" Then Sheet1.Range("B1").Value = "Purchase" End If" If there are better ways to do it, please let me know as I'm trying to learn as much as I can. "Thank you for the wonderful training and video"
Thank you so very much, I really appreciate that. Hi, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
Thanks so much Samir. I am glad you liked it. Make sure you download the free version using the link's in the description so you can customize it yourself.
Dear Sir ... Thank you for what you are doing i have done it at my lab top , it is amazing . I have a request from you , if possible . To add to above amazing inventory manager an actual inventory using a bar code gun and to know deviation whether + or - or zero with whats on hand on system Thanks again for your work it is amazing
Hi and yes this would work fine with a bar code scanner and you can add a Point Of Sale application like this as well ua-cam.com/video/C-jw10s8esw/v-deo.html Or this one: ua-cam.com/video/1xyvioUP8Ls/v-deo.html
When following the video, the code is different then the download, when i change the "MoveBtn"to "MoveBtn1) it works. here what i changed it to: Sub MoveBtn() With Sheet1 .Range("E5").Validation.Delete If Sheet1.Range("B1").Value = "Purchase" Then .Shapes("MoveBtn1").IncrementLeft 30 'NOTE: there must be a space between "IncrementLeft" and "30" .Range("B1").Value = "Sales" .Range("E5").Validation.Add xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="=Customers" Else: .Shapes("MoveBtn1").IncrementLeft -30 if i change it to what your "MoveBtn" code is, it does not work. Just thought i would let you know. David
It may have been because I named the Macro the same as the shape, (which I should not have done) when the macro and the shape have the same name, some versions of Excel have a problem with this. I hope this helps. Thanks very much.
@@ExcelForFreelancers i left it at "MoveBtm1", so it does work. just wanted to let you know, that is all. thank you for your reply, nice to know you are one of the good ones out there. David
This was an amazing tutorial to watch. The closest that i could find that i can use. Ill be looking through your other videos, do you have any that you would recommend for a MLM that keeps inventory? I'm trying to keep track of customer orders, when i place orders and inventory i have so i can see an accurate end of yr what i made or loss. Thank you
HI thanks so much Melissa. I am really glad you liked it. I have several videos on Inventory and Invoicing, Purchasing and sales right here in UA-cam. I am also creating a complete Accounting application with full Inventory, Invoicing, Purchase Orders, Chart Of Accounts, Customer & Item Management and a full Dashboard. You can learn more about that right here: bit.ly/MentorProgram_YTComment Thanks again.
Thank you soooo much for your courses. I fully admire how you can think of all these "impossibilities" to become possible! I am following the full tutorial step by step. Just got one question. I have added new columns based on my need so that Range is not 5-11 anymore. However, I receive error and debug is at here: For ProdCol = 5 To 21 If ProdCol 13 Then .Range(Sheet2.Cells(1, ProdCol).Value).Value = Sheet2.Cells(ProdRow, ProdCol).Value Does number of columns in Transaction sheet have to match the number of columns in Product sheet? In any case, how should I change the macro? Thank you so much in advance.
HI and thanks so much for your training. I created a training to help you fix this exact bug, but basically your data mapping is set for the # of columns so when you change that, you then have to update the data mapping. This training should help you find and fix your issue: ua-cam.com/video/ZhxWT2vylIE/v-deo.html
@@ExcelForFreelancers Thank you so much for your reply! I ve managed to fix the issue. But still got couple of other errors. But let me watch your other videos and try to fix on my own 😁. If no luck, i might come back to you to get some direction. ☺️
I am going to attempt creating a store inventory for a family run furniture store. If you could make a tutorial on a returns add on/ variation for this program it would be invaluable
Hello Lucy, Thanks for your comment. I will be creating a full Accounting application which will include Invoicing, Credits, Purchase Orders and more in our Excel For Freelancers Mentorship program. Please make sure you are on our email list to get notified. Thanks so much. www.ExcelForFreelancers.com
Hi! I'm done with the application and I'm so grateful! I just have one question. On the "product" sheet, I have a column for Qty on Hand and Purchase Qty and for these columns, the data is not getting transferred when is loaded on the transaction sheet. How do I manage to get the data transferred to the product sheet? Thanks for everything!
Hi thanks very much for your comment. You can use a straight value to value exchange in VBA or data mapping as I do in many of my videos. I hope this helps and thank's so much.
@@ExcelForFreelancers Thanks for your quick answer! I don't think I have the skillset on excel in order to do that :( I barely manage to follow up your video and just copy the code and everything : / maybe I will ask on the facebook group! Thanks again!!!
Amazing video thanks for the help. Just one question, when I add a new sales transaction, what do I need to do in order to rest the quantity of the product I sold in the product section. What I want is that automatically when I sell/purchase a product, it subtracts/adds in the product section
Hi Roberto thanks so much for your video. Hi, you can download this file using the links in the description above with either your email or Facebook Messenger. This way you can see the formulas I used. Basically it is Total Quantities Purchased - Total Quantities sold. I hope this helps and thanks. Thank you for your Likes, Shares & Comments. It really helps.
I followed along mostly with the videos, though I did a little modification to add some additional information to each product. I'm having alot of trouble working out bugs and figure out how to add a few useful features lol. For example, when I say I made another purchase of a same item I had already purchased, it shows both transactions on the transaction list, but on the product page it replaces the original information with the new information. It'd be nice if I can get it to average the price between the mulitple purchases, and increase the quantity on hand which stays at 1. Gonna have to invest a bit more research haha also, sometimes I know the total of a transaction, but not the individual price off the top of my head. It'd be cool if I could figure out how to get that total calculation to work in reverse as well if I type the total price in its spot, it'd be cool to see the individual price calculated. I don't know if I'll be able to do that though, have two boxes that calculate to each other.
HI Jomama, thanks for your comment. IF you would like more help with VBA basics I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/ If you would like to have more training on Inventory Valuation and Costing I have this video : ua-cam.com/video/0aOVX2F2Ffk/v-deo.html I hope this helps and thanks so much.
Thank you! You saved me a few hours of work at our food bank, I found a bit of code that wasn't needed on part 1 which was throwing a debugging error in VS, not allowing the purchase, sale button to perform correctly, once fixed worked flawlessly. I noticed in part2 that code was fixed. lol. Great tutorial tho!! subbed/notifications.
Hi Thomas, thanks so much. After creating this video I realized that some versions of Excel threw a bug when using the same name for a shape and a macro (as long as the macro names and shape names are different it works just fine) So glad this video helped you and thanks for your comment.
Thank you so very much, I really appreciate that. 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
Thank you for an amazing tutorial. I have a question since i don't anybody post a question about the issue that i encountered after downloaded your code. If i kept clicking on the purchase and sales button, i noticed that the size is increasing even though the property was locked. Did anybody encounter the same issue that I have? Please let me know if you have a solution for it. I really appreciate that.
HI and thanks. This is possible when it is grouped. However to fix this you can reset the side each time it is clicked just to make sure it does not change such as something like With .Shapes("MoveBtn") .Width = 20 .Height = 20 End with I hope this helps and thanks.
Hi, you can download this file using the links in the description above with either your email or Facebook Messenger to see all of the features. I hope this helps and thanks.
Hi and thanks for your comment. If you are getting the email, but can't access the download, this could be due to some antivirus or security on your computer that is preventing these downloads. Please check with your security software and perhaps temporarily disable it in order to complete the successful download. 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
Amazing tutorial. I do have a question. How can I make this work with a barcode scanner? I am trying to implement that. Having a barcode scanner and automatically fill out the spreadsheet. As soon as an order is complete receive an alert/notification. Thx
Hi and thanks. A barcode scanner, when connected via USB port, will act as a keyboard interface and duplicate the actions of a keyboard. So all you would need is an entry field to enter the ID # and it will automatically fill in. 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
Hello loved your work man, and thank you for the tutorials can you help with a tutorial just for tracking the raw material for a manufacturing business, it dose not have to do any thing with raw materials prices now .. just quantities thank you
Hi thanks so much for your comment. You can simply update the database with the total # of current stock levels. 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
This is fantastic, thank you! A couple of questions: Is it possible to create code to select multiple items from the Product # dropdown? There may be a customer who orders multiple items in one order (i.e. ketchup, mustard, relish, hotdogs and buns) and it may not be time efficient to create a new transaction for each order. My concern is how the sales price would calculate in this format if all the items are different quantities and prices... I'm sure there are ways around that through VBA code though - even though it would be complex :) Any feedback you could provide would be helpful!
Hi Scott, thanks so much and I am really glad you enjoy the training. For multiple Items i have a few videos to help you with that: Invoice Application: ua-cam.com/video/99xVbVMABJ0/v-deo.html Sales Order Application: ua-cam.com/video/4QGIWjSBTUo/v-deo.html I hope this helps and thanks.
Hey..thanks a lot for such a wonderful video.. I have a question.. What if we want to add multiple products in front of one customer..? As here.. We can add only one product, if we want to add multiple products in front of one customer.. we need to do new transaction with same customer if we want to add other product with same customer..
H Utsav, thanks for the great question. I will be creating a full Accounting software that includes Purchase Orders in which we can purchase multiple Inventory Items at the same time and sell multiple items at the same time to the same customer on an Invoice, and a whole lot more. I will be launching this application privately on my website that I call the Mentorship Program. Please feel free to add your email on my website here: Https://www.ExcelForFreelancers.com so that I can alert you when the program launches in a few weeks. Thanks so much
Hi Randy, Thanks for the great video, I have one question. If I want to sent it to someone else, they don't see the pictures. Because they are on my hard drive. What is the solution for this? Thanks for the anser. Clifford
HI and thanks so much. You can use a shared dropbox folder for the pictures. Then, within the admin, have them browse for their picture folder, and you browse for your picture folder. Once this path is combined with the picture name, it will create a proper file path for any computer. I hope this helps and thanks so much.
Hi thanks for your comment. I have a 'Sales Order' video that may be helpful here: ua-cam.com/video/4QGIWjSBTUo/v-deo.html Otherwise I am developing a complete Purchase Order, Invoicing, Inventory and tons of other features in my Mentorship Program in which I am developing a full accounting system here: bit.ly/MentorshipProgram_YTCom Thanks very much for your comment
Hi you are welcome to send it to me, however I would not be able to offer you assistance on it. However if you have a specific question on it, please feel free to upload it in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 23,000 members who would be happy to help you.
thank you very much sir i hope to become one day an expert in excel like you the formula code of the qty is not clear to complete the work book thank you sooo much ilearn from you alot of things
Hey Randy, great work as always! I would like to know if it’s possible to create a delivery note using the sales option and pressing save. For example I currently make Delivery notes on excel and them export to pdf. Is there a way to accommodate this? As this would mean inventory would change as items are sold and a delivery note is made so we do not need to create one manually? Thanks randy
Hi Yaseer, yes sure its possible. You can add additional fields to include notes or any other type of field. You can also then Print to PDF in order to save it as a PDF, or export as PDF. 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
Thank you so much for the lesson you gave us on VBA. I am stuck on the second sheet where the cost of product should go and save correctly. Can you please help me with this? Everything else is okay. Can you please send me the correct VBA code?
Hi Yahya, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
sir it is an amazing tutorial. I have one question. Can we generate periodic reports and summaries from this and further what about the valuation of inventory such as fifo or weighted average for closing inventory at period ends
Hi Ishaaq, you are welcome to download this application using the links in the description and customize it however you like. I am creating an entire Inventory, Invoice & Accounting application with full reporting in our Excel For Freelancers Mentorship program in which you will find helpful here: bit.ly/MentorProgram_YTComment Thank you for your Likes, Shares & Comments. It really helps.
Amazing workbook. I have copied the VBA code to my workbook to compare and ensured everything was the same. However the qty on hand is not being pulled through, when I input new stock onto the product tab, the data is not capturing qty on hand. Also when I input a new product and it asks would I like to save this works but the qty on hand is not affected. Do you have a link to the VBA code for this to work. Keep up the great tutorials
Hi Steve, 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 50,000 Members who would love to help you with this. Thanks so much.
Hi Leyla, thanks for your comment. You can add a unique key such as a number and then use the Max Formula + 1 to add a unique key for each new record, such as Sheet1.Range("A" & InvRow).value = Max(InvNumbers)+1
@@ExcelForFreelancers Okay, so if I call the unique key, all the data about that transaction will display too? Because right now I want to generate a specific primary key for all the transaction and if i want to search for the transaction, I just have to call the ID and no need to scroll to look for the transaction
Hi Guarav, thanks so much for your comment. I will be adding 'Reconciliation' as part of a large accounting program in our Mentorship Program starting this month. Please make sure to follow our website here: www.ExcelForFreelancers.com and our group here bit.ly/groupexcel for the launch. Thank you
Hi thanks so much for your comment. If you want to edit a transaction that has been previously saved you would just have to select it from the list below and make the change. It will be saved/updated automatically.
Hello, thank you so much for this fantastic tutorial! Quick question, is there a way to easily copy all the quantities on hand to a new inventory worksheet? After using it for several months, there may be thousands of transactions and I would like to start fresh using those existing quantity numbers. Maybe a new workbook each month or quarter would be ideal, without having to enter the stock levels starting from 0 each time.
Hi and thanks so much, I am glad you liked the training. You can copy and paste values of the existing data into a new workbook. This will allow you to maintain the current stock levels. 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
Hello, it may be too much to ask..but can you explain how to add a seasonal chart to this workbook? I would like to know which items sold in which quarter, in bar form. thank you.
Hi and thanks you can use date ranges, based on quarters. I cover some of that here in this video: ua-cam.com/video/GrhFMQ7QoSs/v-deo.html I hope this helps and thanks so much.
Your videos are amazing!!! I do not know what I am doing wrong but data validation step and one before with formula for Product Row do not work for me :( Any suggestions please?
Hi Dagmara, I am glad you enjoyed the video and 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 30,000 Members who would love to help you with this. Thanks so much.
The macro is in complete in the sheet transaction for prod_load sheet2.range("h" & prodrow) in the vid it didn't show the full code for it so mine is incomplete
This inventory manager is exactly what I was searching for, thank you for your efforts! I programmed everything, according to your instructions, but there's two problems that I encountered: the selected transaction row (B2) does not update automaticly (therefor the clicked item doesn't get highlited and I'm not able to delete/edit), I tried to get my head around, why that would be, but without any luck. I even downloaded your worksheet to try and figure it out, but it wouldn't work either, I don't know what I'm doing wrong. the second problem I have is, everytime I try to select an existing transaction, I get the error "runtime error 1004 vba method range of object _worksheet failed" which then takes me to the vb line "If TransCol 10 Then .Range(.Cells(16, TransCol).Value).Value = .Cells(TransRow, TransCol).Value ' Load Items Thank you so much in advance!
Hi and thanks for your comment. For the 1st issue it would be difficult to tell, but make sure calculations are set to automatic, and you have the correct ID, and the named range is also correct. For the 2nd issue, make sure you know the value of the 'TransCol' using F8 to step through. Then check row 16 of that specific column (TransCol) and make sure that in that cell there is a cell address such as C6 or D4, or whatever the mapped cell is. 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
@@ExcelForFreelancers I was able to figure it out. I had some issues with the definded ranges in the name manager and and I mapped one cell wrong in row 16 of the transactions sheet. Tank you so much!
Great stuff for sure. Thank you for all your efforts, I am having an issue with Video pat 2 code as the customer cell will not update when I change the entry for cell E5 on the transactions sheet. I have verified all is exactly like that within the video and up to said point, all works fantastic. I receive the error message "Application-defined or object-defined error" Your assistance would be extremely welcomed. Dim ProductRow As Long 'On transaction change, but not on transaction load or new transaction If Not Intersect(Target, Range("E5:H7,E13:K13")) Is Nothing And Range("B4").Value = False And Range("B3").Value = False Then If Range("B2").Value Empty Then Cells(Range("B2").Value, Cells(Target.Row, Target.Column + 10).Value).Value = Target.Value End If Barry
Hi Barry, thanks very much, you will want to make sure that the Target.Column + 10 cell contains a whole number. That means if you add 10 columns to the column you just changed, there should be whole number in that cell (same row) I hope this helps and thanks so much.
Hi, Thanks for the tutorial and really helps a lot. One question though, I might have missed something, but does this macros not allow you to enter New Customer and New Vendor?
Hi Richard, thanks so much for your comment. If i remember correctly this particular training focuses on Inventory items and not as much with Vendors and Customers. I have other trainings such as 'Contact Manager' that will show you how to create Customers and others for Vendors. I hope this helps and thanks so much.
@@ExcelForFreelancers Hi, thanks for the reply. I'm just a bit confused, should i choose this workbook (which I assume will be part of the workbook package) as my inventory manager, does that mean the contact manager and the inventory manager has to linked?
Hi Richard, thanks for your comment. You are welcome to download and customize any of my applications to meet you requirements. You can take bits and pieces of each application to create one that meets all of your requirements. If you need help with this and would like to have a developer create one for you, you can write up a complete and detailed scope, along with your budget, and email it to me here: Randy@ExcelForFreelancers.com. I can then refer it to a qualified developer. I hope this helps and thanks so much.
Sir the way u Expalind this was too Good... THough i m not so Much in Coding.... But i tried to copy Yours to make this Inventory... But at video time 15.02 when u pasted those codes in Sheet1.. Half of the Word were not wisible from right.. Could please Help me with that.... Please help me.... im into the half of that.. Would relly appreciate if u help me with it
Hi and thanks so much., you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
I have just started to use inventory and just wanted to ask , due to the nature of our business (medical products) going forward for us, could product LOT numbers and expiry dates be added as these are a constant change as new products are purchased. An option for VAT/TAX calculations and different prices for the same product dependant on which customer purchases. Thank you
Hi Oswell, thanks for the comment. Feel free to download this application and customize it however you like. If you would like to have a developer customize this for you, please feel free to write a detailed scope and email it to me so that I can refer out a developer to help you with this. Randy@ExcelForFreelancers.com Thanks very much.
It is great video. But i actually looked for in the internet automated one. How to do excel like shop programs. I mean lets say i have shop, i want to sell products by barcode scanner, so i dont need to search products manually, everything will be found by scanning barcode. And as soon as when I click the sell button it will minus automatically from my warehouse.
Hi Ismail you can download this file using the links in the description above with either your email or Facebook Messenger and customize it however you like. Thank you for your Likes, Shares & Comments. It really helps.
Hi Martin, thanks for your question and I am glad you liked the tutorials. The answer is yes, the purchase price should always be less than the sales price. Thanks so much.
Hi again, at the moment when i select purchases and select product id it brings up the sales price and if i change that it changes the info in the products table, when i select the purchase button should it get info from another products table for purchase if so how would i do that and intergrate it into the program. I am new to excel so i hope that i have explained myself properly Thanks Martin
This is probably an issue in formulas or code. Can you upload the details, screenshots and issues in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 25,000 Members who would love to help you with this. Thanks so much.
Thank you for Sharing such a informative video. i would appreciate it if you could make 1 sheet to record daily sales(End of the Day Sales-EOD) with profits from each sale and total profit at the end of the day. Thank you Sir.
Hi! This system is helping me so very much. Im using the version that I got by singing up for your email. One quick question--when I add my own products in (both on the transaction and products tabs) I am not getting any results in the "Qty on Hand" section. I am using this system from the ground up, so i have 0 items on hand at the outset. I purchased 3300 gloves from a vendor and added them into the system via the "new transaction" button, and then sold 240 to a client and added that transaction via sales. However, throughout this process, there is no data in the "qty on hand" field. Any advice would be appreciated. Thank you again!
Hi and thanks for your comment. I am glad you liked the training. Please check your named ranges to make sure they contain the correct data, also double check your formulas by running through the formula. 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
Hi Robyn, to see this in action you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
Hi Lloyd, thanks so much. You can copy data from your source and paste > Paste special into the database sheet. Just make sure the columns match. 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
Hi, Thanks for the video, looking useful. However I have a problem in Visual Basic: at 1:10 in the video you switch from General to Worksheet. When I do that a window pops up: 'Variable uses an Automation type not supported in Visual Basic'. Is it just a setup that I must change? Thanks for you reply.
Hi Bence, Thanks for your comment. Please check your dimensioned variables. 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 50,000 Members who would love to help you with this. Thanks so much.
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.
This stuff is incredible. I didn't even know Excel had that many capabilities. That you could technically write a program within the program! I've got an Indie Publishing biz I'm planning on starting up, and this is really, really going to help a lot because I have to do it on the lowest budget possible, and I'm going to be offering art and writer assets alongside the books I publish. I'll need to have a good inventory system that's customized. Thanks so much!!!!!
Thanks so very much Cinthia. I think this will be a great product to help with your business. If you need help or get stuck please feel free to join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 30,000 Members who would love to help you with this. Thanks so much.
Hello I'm new to VB, thanks for making this great video. Question: in the Trans_Macros module I'm getting an error highlighted for ".Range(TransRow & "." & TransRow).EntireRow.Delete" when I try to use the Delete Button. I'm using Excel 365, any input on how to fix this?
HI and thanks Gessler, you would need to use a colon, not a period between the quotation marks like this: .Range(TransRow & ":" & TransRow).EntireRow.Delete Thank you for your Likes, Shares & Comments. It really helps.
HI and thanks so much. You would want to update the formulas, code and formats however it is more than I can explai inside a UA-cam comment. You can request help in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.
Hello! Suppose a Customer buys multiple products in a single transaction, do you always have to click new transaction after entering 1 product? So it would be one product, then save, then another product and save? Is it not possible to let's say Customer A bought items on a certain date, so can it be entered multiple items under his name then save?
Hi Ahmad, Thanks very much for your comment. In most cases for multiple purchases you would want to use more of a traditional invoice in which multiple products can be purchased at one time by a customer. Likewise, a Purchase Order can be created in which multiple products can be purchased from a single vendor. I plan to release a comprehensive masterclass on Invoicing, Payments, Purchase orders and Inventory later this year teaching that very method. Please stay tuned. Thanks so much.
Hey Randy, I can not say enough about your teaching and replying back to comments. You are way ahead of most on UA-cam, but i do have another questions about Buttons. Is there a place you can see the list of Buttons that are created. Seems there are a few that do not have a good name. Button to coding. This is: .Shapes("ExistTransGrp").Visible = msoCTrue. this is the error. Doesn't like the name of the Button. Just need to know where to go to find the names. thanks much David
Hi David, thanks so much. You can see a list of all Shapes (and Groups of Shapes) when in Excel you click on the main menu item "Page Layout" then click the "Selection Pane". You will then see a list of shapes in which you can edit names direly from that pane. This will also show visible and hidden shapes & groups as well. I hope this helps.
hello sir i have a problem in part 2 vedio showing error in this line: ifRange("B2").ValueChrB$ Emptycells(Range("B2").Value,Cells(Target.Row,Target.Column+10).Value=Target.Value
Hi and thanks for your comment. There are many, many issues with that line of code so you may want to start with the original line or 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/VBADiscount_Randy
Great video again. I did finish the part 1 . but now im stuck in the part where "Worksheet then Change VBA" its like around @1:00 - @6:00 .. im trying it but it's not working. I don't know what I did wrong.
Hi Valentine, 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 40,000 Members who would love to help you with this. Thanks so much.
quick question what if there are multiple products in one order? how does this work? is there some sort of button that show a list of products in one PO?
Hi Lily, thanks for the great question. Having multiple purchase items, such as a Purchase Order, or multiple items in a sale, such as an Invoice will be covered in my upcoming Mentorship Program in which we will be building a full Accounting Application, so make sure to sign up on my email list here: www.ExcelForFreelancers.com
Okay so I have a new question. We can add new product if it is not available and it will save at the product sheets, I want to ask, how do I do that to vendor/customer. The data I've put will be save automatically like for the products.
Hello Randy, Thanks Indeed, I learned a lot from your lessons But I am trying to create this same inventory application and I am blocked with this VBA code "If Not Intersect(Target, Range("H7")) Is Nothing And Range("B6").Value > Empty Then Sheet2.Range("E" & Range("B6").Value).Value = Target.Value" It tells me that there is an executionerror "13", Would you please help me with that Thanks indeed
HI and thanks for your comment. You may be missing a period in front of "Range("B6").Value" 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
Hi Randy: THANK you for this AWESOME tutorial. I see you mentioned in some replies that you are coming out with a workbook like this, but that will allow for P.O.'s with multiple items. Is that one complete, yet? Thanks again, I'm going to be a follower, for sure, now! I would quickly purchase your offer of the masterclass, and pay more if I could get that workbook. I NEED IT BAD! : )
Hi and thanks so much for your comment. IN this mentorship program, starting this month, I will be developing an entire accounting application with Weekly 90 minute trainings for those who join this program. Within that program we will be developing complete Invoices, Purchase Orders, Charge Of Accounts, Recurring Transactions, Entering Transactions, Full Reporting and a ton more. This program will take many months to complete and will be on a subscription basis. I will be announcing it in our group, on UA-cam and within emails so make sure you are subscribing. Thanks so much.
hey man! great stuff! Love your tutorial! I just have one question, when doing the code: Private Sub Worksheet_Change(ByVal Target As Range) Dim ProdRow As Long 'On transaction change, but not on Transaction Load or new transaction If Not Intersect(Target, Range("E5:G7,E13:L13")) Is Nothing And Range("B4").Value = False And Range("B3").Value = False Then If Range("B2").Value Empty Then Cells(Range("B2").Value, Cells(TargetRow, Target.Column + 19).Value).Value = Target.Value End If End Sub I'm getting an error message: "Compile error: Variable not defined" and Private Sub Worksheet_Change(ByVal Target As Range) gets highlighted, how can I fix this error? Thank you for everything!!
HI and thanks for your comment. Looking at your code i cannot see the issue. 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 30,000 Members who would love to help you with this. Thanks so much.
Excel For Freelancers thank you very much for your quick reply! You are awesome! Yesterday I joined to group under a different name and I was just waiting for the acceptance maybe today I’ll upload the images! Thank you!
![Create This AMAZING Excel Application that Tracks Purchases, Sales AND Inventory [Part 1]](http://i.ytimg.com/vi/-1N0L-FDWCs/mqdefault.jpg)
🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom
Peoples are calling me an Excel Expert even though i am still learning it is all by #Excel_For_Freelancers.
I feel nothing better than getting someone like respected Mr. Randy here on UA-cam.
Thank sso much Laxman, I am so happy that I can help. Much appreciated.
Hey! The amount of effort you have put in each and every video needs to be acknowledged. Giving so much value... You are amazing. Keep up the good work!
Thank you so very much, I really appreciate that Jain. Certainly a lot of work, but its well worth it. You will love the one coming out next Tuesday on Clinic Management here: ua-cam.com/video/9oebyN-ivhU/v-deo.html
Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers I need Excel sheet to manage Jet Fuel Farm stock
We have 8 Tanks for each Tank:
Tank Nominal: 53000 Ltrs
Tank Capacity: 50000 Ltrs
and three Sample Tank:
1 Tank Capacity: 800 Ltrs.
1 Tank Capacity: 800 Ltrs.
1 Tank Capacity: 600 Ltrs.
We have non-blended (Jet A-1)
and blended with FSII & CI (JP8)
We have One Unloading Meter
We have One Loading meter for Tank 1 to Tank 6
We have One Loading meter for Tank 7 and Tank 8
Aviation Fuel Farm Tanks Management:
-Receipt (Purchase).
-Issue (Sale).
-Credit (Defuel or Return back to Tank).
-Transfer fuel from vehicle. -Transfer fuel from sample tank.
-Transfer fuel from Tank to Tank.
-Circulation
Fueler Trucks Management:
- Refuel Aircraft from Fueler Truck.
- Defuel from Aircraft to Fueler Truck.
- Circulation.
- Transfer fuel From Fueler Truck to another Fueler Truck.
We have a DIP Chart and System Digital Reading
We need a daily, weekly, monthly & annually Report for Tanks, Fueler Trucks and Customer wise.
Thank you for this educational course. I am working with Excel for a couple of years and learnt to use VB myself. Now I also understand 'INTERSECT'. Very revealing explanation.
Thanks so much Bert, I am really glad you liked it and learning new things.
Thanks for this video. This will help me in my start-up projects as a new learner of Excel.
For sure, you are very welcome. Thank you for your Likes, Shares & Comments. It really helps Darwin
youre teaching blowing my mind, my head exploded on what to do with so many ideas but need to start one, thanks @excel for freelancers
Thank you so very much, I really appreciate that Abdul. Thank you for your Likes, Shares & Comments. It really helps.
WOW .. Sir you're a real genius.. Thank you so much for teaching us by sharing this amazing solution..
I used to do a lot (no code!) in Excel but for years I was away from it.. Now your generosity is going to encourage me again ...
That is really great to here Ardeshir, I am very happy that I can inspire you. Thank you for your Likes, Shares & Comments. It really helps.
God bless you man you are a living legend ❤
Thank you so very much, I really appreciate that and very happy to help and share
Dear Sir. Both Part I and II were excellently presented. Thanks.
I would like to recommend a minor change in logic.
The Price with which we purchase from Vendors is same as the Price we sell to Customers. Ideally, the Cost Price and Selling Price should be separate fields.
Thanks for making VBA interesting for all of us👌👍👍
Hi and thanks so much. I have an updated version, based on your suggestions, right here: ua-cam.com/video/SbjBgqzbA3w/v-deo.html
I hope this helps and thanks so much.
Finally, complete it, and it's working fine. Thanks!!
Great job, glad you were able to get it working.
Thanks for sharing this important lesson .
For sure, you are very welcome Thank you for your Likes, Shares & Comments. It really helps.
I just started watching your video, you have a great content, keep on and God bless
Welcome aboard and thanks so much Rex
Thank-you these are really great. Looking forward to tinkering a wee bit. It's wonderful to lean this and you have a great teaching style.
Thank you so very much, I really appreciate that Stephen.
Thank you very much It's amazing.
For sure, you are very welcome
Thank you for sharing such an amazing piece of work.
For sure Syed, You are welcome and I always appreciate your comments.
Hello Randy, Thanks Indeed, I learned a lot from your lessons
Thank you so very much, I really appreciate that.
Hi Randy, watching the video, I find this is good for tracking inventory totals, but I don't see anything in the program that identifies the location of the inventory which should be part of any inventory program. This would help for inventory picking, restocking, annual physical counts etc. What would be helpful if there were additional fields added for physical location, ie building, row, shelf etc. I have no VBA experience whatsoever, so modding the program for me would be a daunting task. Maybe in future update consider adding a location. Thanks for all of the hard work making these videos/programs, your time and effort is much appreciated.
HI and thanks so much. You are welcome to download this application and customize it however you like by adding additional fields such as Location or anything else. I hope this helps and thanks so much.
It's not that bad to add extra fields, you'd just need to add them to your original box, make sure you map them just like the other boxes, and make sure the fields clear when you go to add a new transaction or item number. I did then when I was following along with the video, added an extra 3 fields or so. I have no visual basic experience prior to this.
Great exercise. What would have to change if you wanted to change product price but only for future sales leaving previous transactions alone?
Hi David, thanks so much for your comment for each transaction such as a sales invoice you can save a history of transactions, so you would just save the price it is sold at within a table. Then, changing the sales price would only affect future purchases. This video on Invoicing may help you with that: ua-cam.com/video/99xVbVMABJ0/v-deo.html
I noticed for this inventory manager that if you click the column headers D to K Range("B1") goes blank, this causes the button to shift to the left , making the button going out of bounds.. For those who are beginners like me, you can simply add a code in in sheet1 (If Sheet1.Range("B1").Value = "" Then
Sheet1.Range("B1").Value = "Purchase"
End If" If there are better ways to do it, please let me know as I'm trying to learn as much as I can.
"Thank you for the wonderful training and video"
Thanks so much for the feedback and update Alfred. I do appreciate that and welcome the modifications. Thanks again.
Thank you. Very helpful tutorial.
For sure, you are very welcome Stelian. Thank you for your Likes, Shares & Comments. It really helps.
not seen such a professional work on youtube, can i get the copy of part 2
Thank you so very much, I really appreciate that. Hi, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
Simply superb video. I would like to tweak this methodology for daily resource planning. Keeping fingers cross :) Thanks.
Thanks so much Samir. I am glad you liked it. Make sure you download the free version using the link's in the description so you can customize it yourself.
Dear Sir ...
Thank you for what you are doing i have done it at my lab top , it is amazing .
I have a request from you , if possible . To add to above amazing inventory manager an actual inventory
using a bar code gun and to know deviation whether + or - or zero with whats on hand on system
Thanks again for your work it is amazing
Hi and yes this would work fine with a bar code scanner and you can add a Point Of Sale application like this as well
ua-cam.com/video/C-jw10s8esw/v-deo.html
Or this one: ua-cam.com/video/1xyvioUP8Ls/v-deo.html
thanks
For sure, you are very welcome
When following the video, the code is different then the download, when i change the "MoveBtn"to "MoveBtn1) it works. here what i changed it to:
Sub MoveBtn()
With Sheet1
.Range("E5").Validation.Delete
If Sheet1.Range("B1").Value = "Purchase" Then
.Shapes("MoveBtn1").IncrementLeft 30 'NOTE: there must be a space between "IncrementLeft" and "30"
.Range("B1").Value = "Sales"
.Range("E5").Validation.Add xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="=Customers"
Else:
.Shapes("MoveBtn1").IncrementLeft -30
if i change it to what your "MoveBtn" code is, it does not work.
Just thought i would let you know.
David
It may have been because I named the Macro the same as the shape, (which I should not have done) when the macro and the shape have the same name, some versions of Excel have a problem with this. I hope this helps. Thanks very much.
@@ExcelForFreelancers i left it at "MoveBtm1", so it does work. just wanted to let you know, that is all. thank you for your reply, nice to know you are one of the good ones out there.
David
Excellent
Thank you very much. I do appreciate that Mohamad. Thank you for your Likes, Shares & Comments. It really helps.
This was an amazing tutorial to watch. The closest that i could find that i can use. Ill be looking through your other videos, do you have any that you would recommend for a MLM that keeps inventory? I'm trying to keep track of customer orders, when i place orders and inventory i have so i can see an accurate end of yr what i made or loss. Thank you
HI thanks so much Melissa. I am really glad you liked it. I have several videos on Inventory and Invoicing, Purchasing and sales right here in UA-cam. I am also creating a complete Accounting application with full Inventory, Invoicing, Purchase Orders, Chart Of Accounts, Customer & Item Management and a full Dashboard. You can learn more about that right here: bit.ly/MentorProgram_YTComment
Thanks again.
Thank you soooo much for your courses. I fully admire how you can think of all these "impossibilities" to become possible! I am following the full tutorial step by step. Just got one question. I have added new columns based on my need so that Range is not 5-11 anymore. However, I receive error and debug is at here:
For ProdCol = 5 To 21
If ProdCol 13 Then .Range(Sheet2.Cells(1, ProdCol).Value).Value = Sheet2.Cells(ProdRow, ProdCol).Value
Does number of columns in Transaction sheet have to match the number of columns in Product sheet? In any case, how should I change the macro?
Thank you so much in advance.
HI and thanks so much for your training. I created a training to help you fix this exact bug, but basically your data mapping is set for the # of columns so when you change that, you then have to update the data mapping. This training should help you find and fix your issue: ua-cam.com/video/ZhxWT2vylIE/v-deo.html
@@ExcelForFreelancers Thank you so much for your reply! I ve managed to fix the issue. But still got couple of other errors. But let me watch your other videos and try to fix on my own 😁. If no luck, i might come back to you to get some direction. ☺️
I am going to attempt creating a store inventory for a family run furniture store. If you could make a tutorial on a returns add on/ variation for this program it would be invaluable
Hello Lucy, Thanks for your comment. I will be creating a full Accounting application which will include Invoicing, Credits, Purchase Orders and more in our Excel For Freelancers Mentorship program. Please make sure you are on our email list to get notified. Thanks so much. www.ExcelForFreelancers.com
Hi! I'm done with the application and I'm so grateful! I just have one question. On the "product" sheet, I have a column for Qty on Hand and Purchase Qty and for these columns, the data is not getting transferred when is loaded on the transaction sheet. How do I manage to get the data transferred to the product sheet? Thanks for everything!
Hi thanks very much for your comment. You can use a straight value to value exchange in VBA or data mapping as I do in many of my videos. I hope this helps and thank's so much.
@@ExcelForFreelancers Thanks for your quick answer! I don't think I have the skillset on excel in order to do that :( I barely manage to follow up your video and just copy the code and everything : / maybe I will ask on the facebook group! Thanks again!!!
Hi! I tried to do the data mapping but the formula on qty on hand gets deleted. I can't figure out how to transfer that data.
Amazing video thanks for the help. Just one question, when I add a new sales transaction, what do I need to do in order to rest the quantity of the product I sold in the product section. What I want is that automatically when I sell/purchase a product, it subtracts/adds in the product section
Hi Roberto thanks so much for your video. Hi, you can download this file using the links in the description above with either your email or Facebook Messenger. This way you can see the formulas I used. Basically it is Total Quantities Purchased - Total Quantities sold. I hope this helps and thanks. Thank you for your Likes, Shares & Comments. It really helps.
Awesome. I had to re-watch everything. Thanks a bunch!!!
For sure, you are very welcome Davy and thank you.
I followed along mostly with the videos, though I did a little modification to add some additional information to each product. I'm having alot of trouble working out bugs and figure out how to add a few useful features lol. For example, when I say I made another purchase of a same item I had already purchased, it shows both transactions on the transaction list, but on the product page it replaces the original information with the new information. It'd be nice if I can get it to average the price between the mulitple purchases, and increase the quantity on hand which stays at 1. Gonna have to invest a bit more research haha also, sometimes I know the total of a transaction, but not the individual price off the top of my head. It'd be cool if I could figure out how to get that total calculation to work in reverse as well if I type the total price in its spot, it'd be cool to see the individual price calculated. I don't know if I'll be able to do that though, have two boxes that calculate to each other.
HI Jomama, thanks for your comment. IF you would like more help with VBA basics I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
If you would like to have more training on Inventory Valuation and Costing I have this video : ua-cam.com/video/0aOVX2F2Ffk/v-deo.html
I hope this helps and thanks so much.
Thank you! You saved me a few hours of work at our food bank, I found a bit of code that wasn't needed on part 1 which was throwing a debugging error in VS, not allowing the purchase, sale button to perform correctly, once fixed worked flawlessly. I noticed in part2 that code was fixed. lol. Great tutorial tho!! subbed/notifications.
Hi Thomas, thanks so much. After creating this video I realized that some versions of Excel threw a bug when using the same name for a shape and a macro (as long as the macro names and shape names are different it works just fine)
So glad this video helped you and thanks for your comment.
@@ExcelForFreelancers for sure I'm a huge fan of your work, can't wait for the next creation!
Thanks so much Tomas, I really do appreciate that.
Thank you so much for your videos. They are gold mines!
You are very welcome Rodell, I am so happy I can bring you them each week.
Another great video...keep them coming- I am learning so much. Thank you...👍
Thanks so much Marlon, I am glad I can help. Every Tuesday a new and unique video is released.
Thanks man really helped me
For sure, you are very welcome
Soooooooooooooooooooooooooooooooooooooooooo Amazing!!
Thank you so very much, I really appreciate that. 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
Thank you for an amazing tutorial. I have a question since i don't anybody post a question about the issue that i encountered after downloaded your code. If i kept clicking on the purchase and sales button, i noticed that the size is increasing even though the property was locked. Did anybody encounter the same issue that I have? Please let me know if you have a solution for it. I really appreciate that.
HI and thanks. This is possible when it is grouped. However to fix this you can reset the side each time it is clicked just to make sure it does not change such as something like
With .Shapes("MoveBtn")
.Width = 20
.Height = 20
End with
I hope this helps and thanks.
It is amazing Excel Application.
Can You please tell features of this Inventory Manager?
Hi, you can download this file using the links in the description above with either your email or Facebook Messenger to see all of the features. I hope this helps and thanks.
Great Vids! I'm having a problem downloading the workbook. I get an error trying to access the file once I receive the email. Help!! 🙂
Hi and thanks for your comment. If you are getting the email, but can't access the download, this could be due to some antivirus or security on your computer that is preventing these downloads. Please check with your security software and perhaps temporarily disable it in order to complete the successful download.
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
Amazing tutorial. I do have a question. How can I make this work with a barcode scanner? I am trying to implement that. Having a barcode scanner and automatically fill out the spreadsheet. As soon as an order is complete receive an alert/notification. Thx
Hi and thanks. A barcode scanner, when connected via USB port, will act as a keyboard interface and duplicate the actions of a keyboard. So all you would need is an entry field to enter the ID # and it will automatically fill in. 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
Hello
loved your work man, and thank you for the tutorials
can you help with a tutorial just for tracking the raw material for a manufacturing business, it dose not have to do any thing with raw materials prices now .. just quantities
thank you
Great suggestion! I will add it to the list of videos. Much apprecaited.
Thanks for your amazing application, Can you please tell me how to enter the starting inventory balance of a product.?????
Hi thanks so much for your comment. You can simply update the database with the total # of current stock levels. 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
This is fantastic, thank you! A couple of questions: Is it possible to create code to select multiple items from the Product # dropdown? There may be a customer who orders multiple items in one order (i.e. ketchup, mustard, relish, hotdogs and buns) and it may not be time efficient to create a new transaction for each order. My concern is how the sales price would calculate in this format if all the items are different quantities and prices... I'm sure there are ways around that through VBA code though - even though it would be complex :) Any feedback you could provide would be helpful!
Hi Scott, thanks so much and I am really glad you enjoy the training. For multiple Items i have a few videos to help you with that:
Invoice Application: ua-cam.com/video/99xVbVMABJ0/v-deo.html
Sales Order Application: ua-cam.com/video/4QGIWjSBTUo/v-deo.html
I hope this helps and thanks.
Hey..thanks a lot for such a wonderful video..
I have a question..
What if we want to add multiple products in front of one customer..? As here.. We can add only one product, if we want to add multiple products in front of one customer.. we need to do new transaction with same customer if we want to add other product with same customer..
H Utsav, thanks for the great question. I will be creating a full Accounting software that includes Purchase Orders in which we can purchase multiple Inventory Items at the same time and sell multiple items at the same time to the same customer on an Invoice, and a whole lot more. I will be launching this application privately on my website that I call the Mentorship Program. Please feel free to add your email on my website here: Https://www.ExcelForFreelancers.com so that I can alert you when the program launches in a few weeks. Thanks so much
Hi Randy,
Thanks for the great video, I have one question.
If I want to sent it to someone else, they don't see the pictures.
Because they are on my hard drive.
What is the solution for this?
Thanks for the anser.
Clifford
HI and thanks so much. You can use a shared dropbox folder for the pictures. Then, within the admin, have them browse for their picture folder, and you browse for your picture folder. Once this path is combined with the picture name, it will create a proper file path for any computer. I hope this helps and thanks so much.
Hello! Thank you for your tutorials. Anything on how to add multiple products for a single PO?
Hi yes sure, I cover multiple products in this video: ua-cam.com/video/4QGIWjSBTUo/v-deo.html
Thank you, great videos.
Glad you like them and thank you for your Likes, Shares & Comments. It really helps.
Amazing
Thank you for your Likes, Shares & Comments. It really helps.
Thank you for the video, it is great.
Do you have a training video in how to create a purchase order?
Hi thanks for your comment. I have a 'Sales Order' video that may be helpful here:
ua-cam.com/video/4QGIWjSBTUo/v-deo.html
Otherwise I am developing a complete Purchase Order, Invoicing, Inventory and tons of other features in my Mentorship Program in which I am developing a full accounting system here:
bit.ly/MentorshipProgram_YTCom
Thanks very much for your comment
Do you mind if I send to you the one I am using?
Hi you are welcome to send it to me, however I would not be able to offer you assistance on it. However if you have a specific question on it, please feel free to upload it in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 23,000 members who would be happy to help you.
thank you very much sir i hope to become one day an expert in excel like you the formula code of the qty is not clear to complete the work book
thank you sooo much ilearn from you alot of things
For sure you are very welcome. I am happy to help.
Amazing tutorial
Thank you so much Anne. I really appreciate that.
Hey Randy, great work as always! I would like to know if it’s possible to create a delivery note using the sales option and pressing save. For example I currently make Delivery notes on excel and them export to pdf. Is there a way to accommodate this? As this would mean inventory would change as items are sold and a delivery note is made so we do not need to create one manually?
Thanks randy
Hi Yaseer, yes sure its possible. You can add additional fields to include notes or any other type of field. You can also then Print to PDF in order to save it as a PDF, or export as PDF. 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
Thank you so much for the lesson you gave us on VBA. I am stuck on the second sheet where the cost of product should go and save correctly. Can you please help me with this? Everything else is okay. Can you please send me the correct VBA code?
Hi Yahya, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
sir it is an amazing tutorial. I have one question. Can we generate periodic reports and summaries from this and further what about the valuation of inventory such as fifo or weighted average for closing inventory at period ends
Hi Ishaaq, you are welcome to download this application using the links in the description and customize it however you like. I am creating an entire Inventory, Invoice & Accounting application with full reporting in our Excel For Freelancers Mentorship program in which you will find helpful here: bit.ly/MentorProgram_YTComment
Thank you for your Likes, Shares & Comments. It really helps.
Nice video
Thanks so much Forhad
Amazing workbook. I have copied the VBA code to my workbook to compare and ensured everything was the same. However the qty on hand is not being pulled through, when I input new stock onto the product tab, the data is not capturing qty on hand. Also when I input a new product and it asks would I like to save this works but the qty on hand is not affected. Do you have a link to the VBA code for this to work. Keep up the great tutorials
Hi Steve, 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 50,000 Members who would love to help you with this. Thanks so much.
First of all this is a great video as usual. I have a question, how do I add a specific primary key or unit code for each transaction
Hi Leyla, thanks for your comment. You can add a unique key such as a number and then use the Max Formula + 1 to add a unique key for each new record, such as
Sheet1.Range("A" & InvRow).value = Max(InvNumbers)+1
@@ExcelForFreelancers Okay, so if I call the unique key, all the data about that transaction will display too? Because right now I want to generate a specific primary key for all the transaction and if i want to search for the transaction, I just have to call the ID and no need to scroll to look for the transaction
There are tons of examples of this in my other videos, so please keep watching.
Plz make the vdo for gst 2a and tally 3b for reconciliation
Hi Guarav, thanks so much for your comment. I will be adding 'Reconciliation' as part of a large accounting program in our Mentorship Program starting this month. Please make sure to follow our website here: www.ExcelForFreelancers.com and our group here bit.ly/groupexcel for the launch. Thank you
Wow...this is amazing...very usefull thanks.
But i have a question..what if I need to edit transaction which is already on list or save?
Hi thanks so much for your comment. If you want to edit a transaction that has been previously saved you would just have to select it from the list below and make the change. It will be saved/updated automatically.
Hello, thank you so much for this fantastic tutorial! Quick question, is there a way to easily copy all the quantities on hand to a new inventory worksheet? After using it for several months, there may be thousands of transactions and I would like to start fresh using those existing quantity numbers. Maybe a new workbook each month or quarter would be ideal, without having to enter the stock levels starting from 0 each time.
Hi and thanks so much, I am glad you liked the training. You can copy and paste values of the existing data into a new workbook. This will allow you to maintain the current stock levels.
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
@@ExcelForFreelancers Thank you for the response! This would overwrite the formula that is in the "Qty On Hand" column though, wouldn't it?
The quantities on hand is always a formula so you would have to make sure that a formula exists in that column. I hope this helps and thanks so much.
Hello, it may be too much to ask..but can you explain how to add a seasonal chart to this workbook? I would like to know which items sold in which quarter, in bar form. thank you.
Hi and thanks you can use date ranges, based on quarters. I cover some of that here in this video: ua-cam.com/video/GrhFMQ7QoSs/v-deo.html
I hope this helps and thanks so much.
Your videos are amazing!!!
I do not know what I am doing wrong but data validation step and one before with formula for Product Row do not work for me :( Any suggestions please?
Hi Dagmara, I am glad you enjoyed the video and 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 30,000 Members who would love to help you with this. Thanks so much.
The macro is in complete in the sheet transaction for prod_load sheet2.range("h" & prodrow) in the vid it didn't show the full code for it so mine is incomplete
Hi, you can download this file using the links in the description under the word DOWNLOAD to get all of the code. I hope this helps and thanks.
When have you upload purchase and sales inventory part 3
Hi and thanks very much for your comment. There are just two parts to this series. I hope this helps and thanks so much.
This inventory manager is exactly what I was searching for, thank you for your efforts!
I programmed everything, according to your instructions, but there's two problems that I encountered:
the selected transaction row (B2) does not update automaticly (therefor the clicked item doesn't get highlited and I'm not able to delete/edit), I tried to get my head around, why that would be, but without any luck. I even downloaded your worksheet to try and figure it out, but it wouldn't work either, I don't know what I'm doing wrong.
the second problem I have is, everytime I try to select an existing transaction, I get the error
"runtime error 1004 vba method range of object _worksheet failed"
which then takes me to the vb line
"If TransCol 10 Then .Range(.Cells(16, TransCol).Value).Value = .Cells(TransRow, TransCol).Value ' Load Items
Thank you so much in advance!
Hi and thanks for your comment. For the 1st issue it would be difficult to tell, but make sure calculations are set to automatic, and you have the correct ID, and the named range is also correct. For the 2nd issue, make sure you know the value of the 'TransCol' using F8 to step through. Then check row 16 of that specific column (TransCol) and make sure that in that cell there is a cell address such as C6 or D4, or whatever the mapped cell is.
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
@@ExcelForFreelancers I was able to figure it out. I had some issues with the definded ranges in the name manager and and I mapped one cell wrong in row 16 of the transactions sheet. Tank you so much!
Ok great, glad you were able to get it figured out. Thank you for your Likes, Shares & Comments. It really helps.
Great stuff for sure. Thank you for all your efforts, I am having an issue with Video pat 2 code as the customer cell will not update when I change the entry for cell E5 on the transactions sheet. I have verified all is exactly like that within the video and up to said point, all works fantastic. I receive the error message "Application-defined or object-defined error" Your assistance would be extremely welcomed.
Dim ProductRow As Long
'On transaction change, but not on transaction load or new transaction
If Not Intersect(Target, Range("E5:H7,E13:K13")) Is Nothing And Range("B4").Value = False And Range("B3").Value = False Then
If Range("B2").Value Empty Then Cells(Range("B2").Value, Cells(Target.Row, Target.Column + 10).Value).Value = Target.Value
End If
Barry
Hi Barry, thanks very much, you will want to make sure that the Target.Column + 10 cell contains a whole number.
That means if you add 10 columns to the column you just changed, there should be whole number in that cell (same row)
I hope this helps and thanks so much.
Bundle of Thanks Sir Nice Video
Thanks very much. I am glad you liked it.
Nice
Thank you so very much, I really appreciate that Faragi
Hi,
Thanks for the tutorial and really helps a lot.
One question though, I might have missed something, but does this macros not allow you to enter New Customer and New Vendor?
Hi Richard, thanks so much for your comment. If i remember correctly this particular training focuses on Inventory items and not as much with Vendors and Customers. I have other trainings such as 'Contact Manager' that will show you how to create Customers and others for Vendors. I hope this helps and thanks so much.
@@ExcelForFreelancers Hi, thanks for the reply. I'm just a bit confused, should i choose this workbook (which I assume will be part of the workbook package) as my inventory manager, does that mean the contact manager and the inventory manager has to linked?
Hi Richard, thanks for your comment. You are welcome to download and customize any of my applications to meet you requirements. You can take bits and pieces of each application to create one that meets all of your requirements. If you need help with this and would like to have a developer create one for you, you can write up a complete and detailed scope, along with your budget, and email it to me here: Randy@ExcelForFreelancers.com. I can then refer it to a qualified developer.
I hope this helps and thanks so much.
Sir the way u Expalind this was too Good... THough i m not so Much in Coding.... But i tried to copy Yours to make this Inventory... But at video time 15.02 when u pasted those codes in Sheet1.. Half of the Word were not wisible from right.. Could please Help me with that.... Please help me.... im into the half of that.. Would relly appreciate if u help me with it
Hi and thanks so much., you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
Good
Thank you for your Likes, Shares & Comments. It really helps.
I have just started to use inventory and just wanted to ask , due to the nature of our business (medical products) going forward for us, could product LOT numbers and expiry dates be added as these are a constant change as new products are purchased. An option for VAT/TAX calculations and different prices for the same product dependant on which customer purchases. Thank you
Hi Oswell, thanks for the comment. Feel free to download this application and customize it however you like. If you would like to have a developer customize this for you, please feel free to write a detailed scope and email it to me so that I can refer out a developer to help you with this. Randy@ExcelForFreelancers.com
Thanks very much.
Extraordinary
Thank you very much.
It is great video. But i actually looked for in the internet automated one. How to do excel like shop programs. I mean lets say i have shop, i want to sell products by barcode scanner, so i dont need to search products manually, everything will be found by scanning barcode. And as soon as when I click the sell button it will minus automatically from my warehouse.
Hi Ismail you can download this file using the links in the description above with either your email or Facebook Messenger and customize it however you like. Thank you for your Likes, Shares & Comments. It really helps.
A great tutorial, i do have a question though. When you do a purchase shouldn't the price be less than the sale price
Hi Martin, thanks for your question and I am glad you liked the tutorials. The answer is yes, the purchase price should always be less than the sales price. Thanks so much.
Hi again, at the moment when i select purchases and select product id it brings up the sales price and if i change that it changes the info in the products table, when i select the purchase button should it get info from another products table for purchase if so how would i do that and intergrate it into the program. I am new to excel so i hope that i have explained myself properly Thanks Martin
This is probably an issue in formulas or code. Can you upload the details, screenshots and issues in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 25,000 Members who would love to help you with this. Thanks so much.
Thank you for Sharing such a informative video. i would appreciate it if you could make 1 sheet to record daily sales(End of the Day Sales-EOD) with profits from each sale and total profit at the end of the day. Thank you Sir.
HI and thanks very much. I will do my best to get that added in the near future.
Hi! This system is helping me so very much. Im using the version that I got by singing up for your email. One quick question--when I add my own products in (both on the transaction and products tabs) I am not getting any results in the "Qty on Hand" section. I am using this system from the ground up, so i have 0 items on hand at the outset. I purchased 3300 gloves from a vendor and added them into the system via the "new transaction" button, and then sold 240 to a client and added that transaction via sales. However, throughout this process, there is no data in the "qty on hand" field. Any advice would be appreciated. Thank you again!
Hi and thanks for your comment. I am glad you liked the training. Please check your named ranges to make sure they contain the correct data, also double check your formulas by running through the formula. 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
Do you have a video that shows this spreadsheet in action? So I know what it does and how it does it? Thanks
Hi Robyn, to see this in action you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
Brilliant
Much Appreciated.
How do I populate the products table with my data without causing formula errors in the Qty on hand column. TIA
Hi Lloyd, thanks so much. You can copy data from your source and paste > Paste special into the database sheet. Just make sure the columns match. 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
Hi, Thanks for the video, looking useful. However I have a problem in Visual Basic: at 1:10 in the video you switch from General to Worksheet. When I do that a window pops up: 'Variable uses an Automation type not supported in Visual Basic'. Is it just a setup that I must change? Thanks for you reply.
Hi Bence, Thanks for your comment. Please check your dimensioned variables. 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 50,000 Members who would love to help you with this. Thanks so much.
This may be a stupid question but which cell was the ProductNumb? I’m having trouble with the data validation at 9:46
The ProductNumb is a named ranged based on the Product Numbers in the database. I hope this helps and thanks so much.
Thanks! But, I can get the MoveBtn to delete Validation and get the customers and vendors executed. please, what do I do?
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.
This stuff is incredible. I didn't even know Excel had that many capabilities. That you could technically write a program within the program!
I've got an Indie Publishing biz I'm planning on starting up, and this is really, really going to help a lot because I have to do it on the lowest budget possible, and I'm going to be offering art and writer assets alongside the books I publish. I'll need to have a good inventory system that's customized.
Thanks so much!!!!!
Thanks so very much Cinthia. I think this will be a great product to help with your business. If you need help or get stuck please feel free to join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 30,000 Members who would love to help you with this. Thanks so much.
😅😅99😅k6666by😅😅😅
Hello I'm new to VB, thanks for making this great video. Question: in the Trans_Macros module I'm getting an error highlighted for ".Range(TransRow & "." & TransRow).EntireRow.Delete" when I try to use the Delete Button. I'm using Excel 365, any input on how to fix this?
HI and thanks Gessler, you would need to use a colon, not a period between the quotation marks like this:
.Range(TransRow & ":" & TransRow).EntireRow.Delete
Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers That did it, really appreciate it!
Understanding
Thanks again.
Hi If we want to add more tool such as products category sup of products. How can we do?
HI and thanks so much. You would want to update the formulas, code and formats however it is more than I can explai inside a UA-cam comment. You can request help in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 40,000 Members who would love to help you with this. Thanks so much.
Hello! Suppose a Customer buys multiple products in a single transaction, do you always have to click new transaction after entering 1 product? So it would be one product, then save, then another product and save? Is it not possible to let's say Customer A bought items on a certain date, so can it be entered multiple items under his name then save?
Hi Ahmad, Thanks very much for your comment. In most cases for multiple purchases you would want to use more of a traditional invoice in which multiple products can be purchased at one time by a customer. Likewise, a Purchase Order can be created in which multiple products can be purchased from a single vendor. I plan to release a comprehensive masterclass on Invoicing, Payments, Purchase orders and Inventory later this year teaching that very method. Please stay tuned. Thanks so much.
Hey Randy, I can not say enough about your teaching and replying back to comments. You are way ahead of most on UA-cam, but i do have another questions about Buttons. Is there a place you can see the list of Buttons that are created. Seems there are a few that do not have a good name. Button to coding. This is: .Shapes("ExistTransGrp").Visible = msoCTrue. this is the error. Doesn't like the name of the Button.
Just need to know where to go to find the names.
thanks much
David
Hi David, thanks so much. You can see a list of all Shapes (and Groups of Shapes) when in Excel you click on the main menu item "Page Layout" then click the "Selection Pane". You will then see a list of shapes in which you can edit names direly from that pane. This will also show visible and hidden shapes & groups as well. I hope this helps.
hello sir
i have a problem in part 2 vedio
showing error in this line: ifRange("B2").ValueChrB$ Emptycells(Range("B2").Value,Cells(Target.Row,Target.Column+10).Value=Target.Value
Hi and thanks for your comment. There are many, many issues with that line of code so you may want to start with the original line or 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/VBADiscount_Randy
Great video again. I did finish the part 1 . but now im stuck in the part where "Worksheet then Change VBA" its like around @1:00 - @6:00 .. im trying it but it's not working. I don't know what I did wrong.
And I also did copy the code .. but yet it's not working .. or it is not changing
Hi Valentine, 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 40,000 Members who would love to help you with this. Thanks so much.
quick question what if there are multiple products in one order? how does this work? is there some sort of button that show a list of products in one PO?
Hi Lily, thanks for the great question. Having multiple purchase items, such as a Purchase Order, or multiple items in a sale, such as an Invoice will be covered in my upcoming Mentorship Program in which we will be building a full Accounting Application, so make sure to sign up on my email list here: www.ExcelForFreelancers.com
Useful
Thanks very much
Super awesome video! Do you know if this can be recreated with Google Sheets?
Perhaps it can, however I have not tried since I am focused on Excel. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Thank you. I'm planning on trying it anyways.
Okay so I have a new question. We can add new product if it is not available and it will save at the product sheets, I want to ask, how do I do that to vendor/customer. The data I've put will be save automatically like for the products.
HI and thanks you can check out my Customer Manager for training on how to do that. Thanks very much.
Hello Randy, Thanks Indeed, I learned a lot from your lessons
But I am trying to create this same inventory application and I am blocked with this VBA code "If Not Intersect(Target, Range("H7")) Is Nothing And Range("B6").Value > Empty Then Sheet2.Range("E" & Range("B6").Value).Value = Target.Value" It tells me that there is an executionerror "13", Would you please help me with that
Thanks indeed
HI and thanks for your comment. You may be missing a period in front of "Range("B6").Value"
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
@@ExcelForFreelancers Thank you I am joining now
Hi Randy: THANK you for this AWESOME tutorial. I see you mentioned in some replies that you are coming out with a workbook like this, but that will allow for P.O.'s with multiple items. Is that one complete, yet? Thanks again, I'm going to be a follower, for sure, now! I would quickly purchase your offer of the masterclass, and pay more if I could get that workbook. I NEED IT BAD! : )
Hi and thanks so much for your comment. IN this mentorship program, starting this month, I will be developing an entire accounting application with Weekly 90 minute trainings for those who join this program. Within that program we will be developing complete Invoices, Purchase Orders, Charge Of Accounts, Recurring Transactions, Entering Transactions, Full Reporting and a ton more. This program will take many months to complete and will be on a subscription basis. I will be announcing it in our group, on UA-cam and within emails so make sure you are subscribing. Thanks so much.
hey man! great stuff! Love your tutorial! I just have one question, when doing the code:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim ProdRow As Long
'On transaction change, but not on Transaction Load or new transaction
If Not Intersect(Target, Range("E5:G7,E13:L13")) Is Nothing And Range("B4").Value = False And Range("B3").Value = False Then
If Range("B2").Value Empty Then Cells(Range("B2").Value, Cells(TargetRow, Target.Column + 19).Value).Value = Target.Value
End If
End Sub
I'm getting an error message: "Compile error: Variable not defined" and Private Sub Worksheet_Change(ByVal Target As Range) gets highlighted, how can I fix this error? Thank you for everything!!
HI and thanks for your comment. Looking at your code i cannot see the issue. 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 30,000 Members who would love to help you with this. Thanks so much.
Excel For Freelancers thank you very much for your quick reply! You are awesome! Yesterday I joined to group under a different name and I was just waiting for the acceptance maybe today I’ll upload the images! Thank you!
Thank you so much Juan. Happy to help.
@@ExcelForFreelancers Hi! I joined the Facebook group under the name: Iansa or Iansa Diagnostics, but I still haven't got a reply to my request.
Hello Juan, please be patient and make sure you have included all of the complete details and screenshots.