🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom
@spidey420
2 ай бұрын
Hello Randy, Not sure if I followed your instructions to the dot. When I am loading the 2nd project it only loads 2 lines of the project not 3. Can you guide me as to what I did wrong? Double checked code and I can't see if I missed anything. Can you help?
@spidey420
2 ай бұрын
Hi Randy, I had an incorrect formula on the project's items tab in the criteria cell. Sorry for the inconvenience. On a side note, I love your videos and have purchased your 250+ workbooks. Quick question, do you have any projects on estimating for residential painting jobs. ie. do painting job estimate and write up the bid?
@jadaperez2169
Ай бұрын
Thank you!!!!!!!!!! I went for an interview with a construction Co last week. I've been in Construction for years but the position was for Accounts Payable. The Interviewer thought I was there for a different reason. I went from interviewing for a 15/hr position to making more than double that; I'm now the new Project Manager/Estimator for the company. I've spent the last four days learning Excel and I took this chart in this morning, and watched the owner's and Office Manager's eyes blend into their hairline. You have made me look like a frikin genius.
@ExcelForFreelancers
Ай бұрын
Wow that is an amazing and awesome story. I am so happy that i can help and share and inspire you. I used to run a Construction company for 10 years so its an area i know well. I have two other training and templates for you to look at Construction Estimator: kzitem.info/news/bejne/lI6Llmp7oGKBdJw Construction Project Manager: kzitem.info/news/bejne/yoZszZ-DkZqFg6Q I hope this helps and thanks so much.
@DrJohnPollard
4 жыл бұрын
Randy, I don't know how you do it. Every week you come up with a functional, simple, clear, useful video with a matching software project. It's not possible to do this, and yet you achieve it week after week. It truly is amazing. You are inspiring multitudes of excel worshipers. It's quite impressive.
@ExcelForFreelancers
4 жыл бұрын
Thank you so much Dr. John, and each week I look so very forward to your feedback and comments. It is what pushes me to create new and useful applications each and every week. Thanks again.
@israelmobley4499
Жыл бұрын
Buddy, let me just say. I have never, ever, EVER seen this before in my life. But you are certainly skilled. I could tell when you were in your groove and just moving through the coding for the macros, that shows experience. Thank you so much for taking the time to make/explain this and then offering the template for free to any person who is fortunate enough to see this. I am a young construction business owner looking to revamp and revise the way the family company assesses it's finances. I watched your entire video even after downloading the template just so I can make sure I use it correctly. Thank you again, you are awesome
@ExcelForFreelancers
Жыл бұрын
Thanks so much. I really appreciate that. Before teaching Excel, I ran a construction company for 10 years, so i have a good amount of experience in this field. I am glad I can help and share. Please check out my Mini-Accounting application to help you in your business here: kzitem.info/news/bejne/yqp-z6CwrId5lqA Thank you for your Likes, Shares & Comments. It really helps.
@LawrenceLWWong
4 жыл бұрын
This is the first time i leave a comment to a youtuber. I just cant wait to express my excitement when i see this! I just randomly bumped into your content and it has been quite a while since i see a high quality video tutorial before this. Thank you so much you have made my day so meaningful.
@ExcelForFreelancers
4 жыл бұрын
Thank you so very much, I really appreciate that Lawrence. Feel free to check out many of my videos and applications.
@czechyorker
4 жыл бұрын
I keep missing the premiere but Always come here to learn something new. Many thanks for the great projects.
@ExcelForFreelancers
4 жыл бұрын
Thanks so much and no worries. I am so glad you enjoyed the video training.
@harryjeganathan5276
4 жыл бұрын
Hi Randy, I really enjoy the your training videos. Every Tuesday I look forward the videos. Thank you 👍
@ExcelForFreelancers
4 жыл бұрын
Thank you so very much, I really appreciate that Harry.
@joemanflyer2001
Ай бұрын
Good for construction too !
@ExcelForFreelancers
Ай бұрын
Yes for sure. In fact I have one specifically for construction here: kzitem.info/news/bejne/yoZszZ-DkZqFg6Q I hope this helps and thanks so much.
@aakashpatel164
4 жыл бұрын
Sir, it really great... Your knowledge helps millions of people.
@ExcelForFreelancers
4 жыл бұрын
It's my pleasure and thanks so much.
@dougmphilly
9 ай бұрын
i'm looking for an AIA like tracking model. this is a good start. thanks.
@ExcelForFreelancers
9 ай бұрын
Thank you for your kind words! I'm glad to hear that this video was a good starting point for you.
@smathers3104
4 жыл бұрын
Thanks Randy..another great Excel model. In the real world though often something like this application would need to interface with an accounting system either as front end input or more likely read transactions exported from it.
@ExcelForFreelancers
4 жыл бұрын
Hi Scott thanks so much for your comment. You could certainly combine this with my Invoice application on KZitem to create a powerful budget and Invoicing application. Thank you for your Likes, Shares & Comments. It really helps.
@moveonnasir
2 жыл бұрын
You are great Randy. Thanks buddy.
@ExcelForFreelancers
2 жыл бұрын
You are very welcome and I am happy to help Nasir
@charlenemack9443
Жыл бұрын
I need a spreadsheet to track IT Project Costs, in addition to budget vs actual. Customer does not issue PO so I need a form for that. I enjoyed watching this video. I'm going to go through the rest to see of you have something I can use
@ExcelForFreelancers
Жыл бұрын
Thanks so much. I am glad you like it. I think this video, Project Costing, is the closest I have, however I do have a lot, so please feel free to search for more as I have nearly 300 templates and trainings. Thank you for your Likes, Shares & Comments. It really helps.
@johnreyaurellano1673
4 жыл бұрын
This is really what i need, thanks for the knowlegde you sharing bro!! 👊
@ExcelForFreelancers
4 жыл бұрын
For sure, you are very welcome John. I hope you enjoy it.
@jackhammer3793
4 жыл бұрын
Unsung hero. Thanks!
@ExcelForFreelancers
4 жыл бұрын
Thank you so very much, I really appreciate that.
@ahmedqasim7761
4 жыл бұрын
Thanks so much for such great helpful videos
@ExcelForFreelancers
4 жыл бұрын
For sure, you are very welcome
@tanghingkwong4396
3 жыл бұрын
Thanks for informative video. Useful for teaching & learning purpose.
@ExcelForFreelancers
3 жыл бұрын
For sure, you are very welcome Tang
@asimsiddiq475
4 жыл бұрын
very,very, excellent collection of project achievements.
@ExcelForFreelancers
4 жыл бұрын
Thanks so much. I am so glad you enjoyed the training.
@druckrc
4 жыл бұрын
HI Randy I really in joy watching your video I think I have watched over half on them . I tried reproducing your inventory mange with not much success . So I tried to reproducer this one once I thinking that it would really help me out at work. I think I spent total of 16 hrs checking the code making sure I have the right formulas in the right cells success.
@ExcelForFreelancers
4 жыл бұрын
Awesome! So happy to hear that Robert. Super glad you enjoy the training. Make sure you catch my newest one, Product Catalog Creator, released in just 3 hours here: kzitem.info/news/bejne/yoef2It9gJWcbIY
@mmmrizley3923
Жыл бұрын
Very useful
@ExcelForFreelancers
Жыл бұрын
Thank you so very much, I really appreciate that
@mdlokmanhossain2813
2 жыл бұрын
This abosletuley amazing advice...❤️❤️❤️❤️❤️
@ExcelForFreelancers
2 жыл бұрын
Thank you so very much, I really appreciate that
@mdshahidul2181
2 жыл бұрын
So beautiful advice
@ExcelForFreelancers
2 жыл бұрын
Thank you so very much, I really appreciate that Shahidul
@tienngotk
4 жыл бұрын
This is the template i ha ve found so far. Thank you so much for sharing your great dashboard
@ExcelForFreelancers
4 жыл бұрын
For sure, you are very welcome, I am happy to help
@mdborhankhan3559
2 жыл бұрын
Thanks
@ExcelForFreelancers
2 жыл бұрын
For sure, you are very welcome Borhan
@alsam26
2 жыл бұрын
the program works great
@ExcelForFreelancers
2 жыл бұрын
Thank you very much, I really appreciate that Daddy A
@MeyerZevallos
4 жыл бұрын
I really apreciate your time to get us this excellent video. Thank you so much Randy
@ExcelForFreelancers
4 жыл бұрын
Thank you so very much, I really appreciate that Meyer.
@keep_digging
4 жыл бұрын
this is the first time i have caught this while it is live, others i have had to watch afterwards
@ExcelForFreelancers
4 жыл бұрын
Thanks so much Steve. I do these every week at the same time. I hope to see you next week. Feel free to live chat with me during the video. Thank you for your Likes, Shares & Comments. It really helps.
@wayneedmondson1065
4 жыл бұрын
Hi Randy. Another epic and awesome video and lesson! Thanks for sharing it. Thumbs up!!
@ExcelForFreelancers
4 жыл бұрын
Thank you so very much, I really appreciate that Wayne
@shaileshmayekar2495
4 жыл бұрын
Thanks a lot Randy. This is what I was looking for as I work in project controls.you are great.
@ExcelForFreelancers
4 жыл бұрын
Glad I could help Shailesh. Thank you for your Likes, Shares & Comments. It really helps.
@richardhainsworth9428
4 жыл бұрын
Great tool Randy, really like this. Thank you as always
@ExcelForFreelancers
4 жыл бұрын
Thanks so much Richard. I always appreciate your kind comments.
@osamasaid8476
4 жыл бұрын
Thank you words are not enough
@ExcelForFreelancers
4 жыл бұрын
For sure, you are very welcome Osama
@JVCHIOCO
4 ай бұрын
Correct me if I'm wrong but it would seem that automatic filling of succeeding cells can also be achieved by lookup functions rather than VBA right?
@ExcelForFreelancers
4 ай бұрын
HI and thanks for yoru feedback. There are many ways to complete this type of autofill, that is correct. I hope this helps and thanks so much.
@samkroon9869
3 жыл бұрын
Thanks a lot Randy this helps!
@ExcelForFreelancers
3 жыл бұрын
For sure, you are very welcome and happy to help Sam.
@phucnguyen-ym2cz
3 жыл бұрын
Thanks for your sharing Amazing job !
@ExcelForFreelancers
3 жыл бұрын
Cam on ban :)
@mateodemateus5444
3 жыл бұрын
wow that a lot great information thank you for sharing.
@ExcelForFreelancers
3 жыл бұрын
For sure, you are very welcome and happy to help Mateo
@abdulganishaikh990
4 жыл бұрын
Awesome, please upload more such a useful tutorial
@ExcelForFreelancers
4 жыл бұрын
Thanks so much I will do my best.
@jetnorshkullaku4932
4 жыл бұрын
Thank you! Great lesson!
@ExcelForFreelancers
4 жыл бұрын
Thank you so very much, I really appreciate that Jetnor
@zakiaali5562
3 жыл бұрын
Thank you so much for this video
@ExcelForFreelancers
3 жыл бұрын
For sure, you are very welcome Zakia
@righteousncube4111
2 жыл бұрын
This is incredible.
@ExcelForFreelancers
2 жыл бұрын
Thank you so very much, I really appreciate that.
@sunny-handa
4 жыл бұрын
You are excel god
@ExcelForFreelancers
4 жыл бұрын
Thank you so much Sunny. Much appreciated.
@mdbulbul3
2 жыл бұрын
Beautiful video
@ExcelForFreelancers
2 жыл бұрын
Thank you! Cheers!
@namanshetty64
4 жыл бұрын
Sir can you please make a video on the Hospital database management system.
@ExcelForFreelancers
4 жыл бұрын
Hi and thanks so much. This would be a very big software, much more than I can do in an hour training. If you need this software please feel free to post a PAID JOB in 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.
@enninsimon1588
4 жыл бұрын
you are so amazing. God bless you
@ExcelForFreelancers
4 жыл бұрын
Thank you! You too Ennin.
@grahamparker7729
4 жыл бұрын
Love this Randy 👌🏻 For a future lesson how about creating a project manager app? I know we have MS Project but some of us prefer using Excel.
@ExcelForFreelancers
4 жыл бұрын
Hi Graham thanks so much. I am glad you enjoyed the training and always appreciate your suggestions. I do have a 10 Part Project Manager series on my channel you can check out. I think you would enjoy it.
@grahamparker7729
4 жыл бұрын
Thanks Randy - just had a look and found the series. I then realised I’ve watched them all previously but I will go back and watch again. Keep up the good work!
@ExcelForFreelancers
4 жыл бұрын
Thanks so much Graham. Much apprecaited.
@garyturenne5564
4 жыл бұрын
Great stuff! I am learning something new every time I watch a video of yours. I was confused on this one a a bit with your reference to D6 in "If Not Intersect(Target, Range("D10:D999")) Is Nothing And Range("D6").Value = False". D6 is just a blank cell. I thought it was going to be B6.
@ExcelForFreelancers
4 жыл бұрын
Hi Gary yes that should be B6, correct. I have made the update on the downloaded version. Thanks again for your following. I don't always catch every issue during the training. Thank you for your Likes, Shares & Comments. It really helps.
@abdalaalabdalaal9085
2 жыл бұрын
@@ExcelForFreelancers where is the download version sir?
@kyeleeharper9644
7 ай бұрын
Can you please tell me if there is a prequel video on how to create the tabs your using for this sheet?
@ExcelForFreelancers
7 ай бұрын
Hi and thanks for your comment. This is the only version I have, however i have other videos on 'Tabs' which may be helpful to you. Please search my channel for "Tabs" I hope this helps and thanks so much.
@sdas27_9
2 жыл бұрын
Great Boss
@ExcelForFreelancers
2 жыл бұрын
Thank you so very much, I really appreciate that.
@runelchakma9032
2 жыл бұрын
Nice video
@ExcelForFreelancers
2 жыл бұрын
Thank you very much. So nice of you Runel
@kanoo3285
4 жыл бұрын
Thanks a ton for the upcoming video on Project costing. I have a humble request, in my construction business excel worksheet I want to be able to click on an entry and the receipt from the vendor should open (stored in my computer). Thanks
@ExcelForFreelancers
4 жыл бұрын
HI and thanks I do have something similar, check out "Mobile Inventory" in which receipts can be uploaded and viewed through Excel.
@rofiqulislam7544
2 жыл бұрын
Very good video 💖
@ExcelForFreelancers
2 жыл бұрын
Thanks for the visit. So nice of you Rofiqul
@JoseSegundo65
4 жыл бұрын
Waiting this super training! 👍🏻
@ExcelForFreelancers
4 жыл бұрын
Hope you like it, thanks so much Jose.
@vimalsidhartha7625
4 жыл бұрын
Eagarly waiting to learn And see videos of Excel
@ExcelForFreelancers
4 жыл бұрын
Thank you very much. I do appreciate that Vimal
@hrp1800
4 жыл бұрын
Awaiting for another awesome video.👍
@ExcelForFreelancers
4 жыл бұрын
Thank you so much 😀
@ikesonikesonweb5057
Жыл бұрын
Good afternoon sir, please I really love all your excel tutorials But please I need a favor from you, by the I am Africa "Ghana" I want to design hospital management system for my project "HRMS" Thanks
@ExcelForFreelancers
Жыл бұрын
Hi and thanks very much, you can use this training here: kzitem.info/news/bejne/mqWbyK2EZpunm4o I hope this helps and thanks so much.
@marmakyky2941
2 жыл бұрын
Nice vedio
@ExcelForFreelancers
2 жыл бұрын
Thank you so very much, I really appreciate that Marma
@aishu58
4 жыл бұрын
Eagerly waiting sir Your sheets help us a lot
@ExcelForFreelancers
4 жыл бұрын
Thank you very much. I do appreciate that.
@user-hr8jt5gv7g
Жыл бұрын
Hi Randy. I have a question and I need your help. How do we create and the formularr in the name manager for the print area
@ExcelForFreelancers
Жыл бұрын
HI and thanks for your question. This Print area is automated when you set the Print area either manually, or with VBA code. I hope this helps and thanks so much.
@pt2312Jjun
4 жыл бұрын
can't wait for this !!! OMG !!! amazingggg
@ExcelForFreelancers
4 жыл бұрын
Thanks so much. I hope you enjoyed the training.
@nontobekozwane6548
2 жыл бұрын
Dear Randy, Thank you so much for your wonderful work. It has been of great help to me learning excel. I am struggling with the VBA codes, I did everything as you show it but when testing it out it does not pull through the ( Item type, Item name Item Description, Qty and Cost) as well as the address 1 and 2
@ExcelForFreelancers
2 жыл бұрын
Hi Zwane, 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.
@nontobekozwane6548
2 жыл бұрын
@@ExcelForFreelancers HI Randy, I can do that.
@jamesbrown80
4 жыл бұрын
Hi Randy Love your videos they are so educational and helpful. I have been inspired to work on a spreadsheet myself to track our hours and overtime hours worked in a month. Although I am using formulas as I don't know much about VBA. It seems though that I could stream line my spreadsheet quite a bit by using VBA. Maybe you could take a look and give me some pointers?
@ExcelForFreelancers
4 жыл бұрын
Hi James, thanks so much. While I am unable to provide any one on one support, 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/
@mdsaiful6294
2 жыл бұрын
Nice video 😊
@ExcelForFreelancers
2 жыл бұрын
Thank you so very much, I really appreciate that Saiful
@keriould2417
4 жыл бұрын
Thank you Mr. Randy for all the good everyday I have a question please. Is it possible to print Budget 1 and 2 with one click?
@ExcelForFreelancers
4 жыл бұрын
Hi and thanks the Print Budget will work just fine with whatever budget is displayed. You can write additional macros to loop through budget and print them as well. 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
@abdulnoman1898
2 жыл бұрын
Nice
@ExcelForFreelancers
2 жыл бұрын
Thank you so very much, I really appreciate that Abdul
@sanilalkuttimon1755
4 жыл бұрын
really great!!!
@ExcelForFreelancers
4 жыл бұрын
Thank you so very much, I really appreciate that Sanilal
@emiliaalejandrakuschnir5199
2 жыл бұрын
is there an option to purchase all this amazing files?
@ExcelForFreelancers
2 жыл бұрын
Hi Emelia, you can download this template for free using the links in the description above with either your email or Facebook Messenger. If you are looking for a completed version of the application, I can refer a developer to help you with this (Randy@ExcelForFreelancers.com ) I hope this helps and thanks.
@lannguyen-ww5jr
2 жыл бұрын
Hay quá
@ExcelForFreelancers
2 жыл бұрын
Thank you so very much, I really appreciate that
@muruganpanneerselvam1382
2 жыл бұрын
Hi Randy, Its work well, i have a doubt that when i save in Proj 1 then start to fill Proj 2, but outcome details are came to Proj 1, Please advise
@ExcelForFreelancers
2 жыл бұрын
Hi and thanks very much. Make sure that you have the correct project row and project id when loading a project. You may want to go over the training again and double check that the correct project row is being calculated. I hope this helps and thanks so much.
@mohamedjamal3952
2 жыл бұрын
Fine
@ExcelForFreelancers
2 жыл бұрын
Thank you so very much, I really appreciate that Jamal
@MdEmon-oh1vi
2 жыл бұрын
Nice🥰🥰
@ExcelForFreelancers
2 жыл бұрын
Thank you so very much, I really appreciate that. Emon
@dexitk
4 жыл бұрын
Nice, have a like to download this file
@ExcelForFreelancers
4 жыл бұрын
Hi Dorin, 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.
@investinumkm7987
3 жыл бұрын
Hi Randy, I really appreciate for your excellent video , How to retrieve / print the project data from the project list. thanks
@ExcelForFreelancers
3 жыл бұрын
HI Damirock you can set the print range by highlighting the cells you want to print and then click the print button. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@TheJaebeomPark
4 жыл бұрын
Awesome work!
@ExcelForFreelancers
4 жыл бұрын
Thank you so very much, I really appreciate that.
@naeembutt4236
2 жыл бұрын
And he been in my sa situation obviously
@ExcelForFreelancers
2 жыл бұрын
Thank you for your Likes, Shares & Comments. It really helps.
@gurvindersaini8318
3 жыл бұрын
Thank you Randy for making this wonderful video. I have a question regarding the formula that you use to move guage needle (Actual Cost-20% below budge cost)/(20%above budge-20% below budget cost)*100. Is this a standard formula that is using in budgeting or this was used to show how guage needle move. I searched in google many times but could not find this formula anywhere.
@ExcelForFreelancers
3 жыл бұрын
Hi and thanks so much Guri for your comment. The 20% was just an arbitrary # that I chose to show the different levels. You can download this and customize it however you like using your own #'s and formulas. I hope this helps and thanks so much.
@shaileshgurjar4421
3 жыл бұрын
Is possible to work on cowshed project report from perching of land till sale of the products (Milk, cow dung & Urine) with investing, wages & profit.
@ExcelForFreelancers
3 жыл бұрын
Hi and thanks for your comment. This is certainly possible. If you need a specific application built for you, please feel free to post your requirements in 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.
@RaceMentally
Жыл бұрын
Are we able to get this template and put it into excel? Sorry im new to this
@ExcelForFreelancers
Жыл бұрын
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@maddinenirajeshbabu3143
4 жыл бұрын
Thanks for your video I have one doubt in vba one cell contains 75 lines of data is there any way to read by line by line content two breaking down to multiple cells Thanks in adavance
@ExcelForFreelancers
4 жыл бұрын
Hi and thanks you can use a For/Next Loop or perhaps an Advanced Filter based on your data. 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
@ruiandrade264
4 жыл бұрын
Hi Randy, I noticed that all these kind of projects You never add the option to eliminate projects. For instance, in "Invoice from Scratch" You didn't also. I'm doing something like that and have serious trouble eliminating an Invoice and its current lines of products. I can but it turns out ver slow.
@ExcelForFreelancers
4 жыл бұрын
HI Rui thanks so much. I do at times add the ability to delete records however i am limited in time so there are always features that are needed for complete application. I will try to add delete feature in more records in the future . (I do have it in my Employee Manager series on KZitem so please check it out) Thank you for your Likes, Shares & Comments. It really helps.
@eithanschonberg1768
4 жыл бұрын
check out microsoft access. you can do all those things faster, easier, and better. Try it out.
@ExcelForFreelancers
4 жыл бұрын
Access is a great software for sure, however Excel is what people want and love around the world, and so that is the software i use to create my applications. Sometimes 'best' is not always best for everyone. Thank you for your Likes, Shares & Comments. It really helps.
@kazinasid9398
3 жыл бұрын
Sir, it really great. How can I download this Excel worksheet?
@ExcelForFreelancers
3 жыл бұрын
Hi Kazi, 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.
@proenixinternational7217
2 жыл бұрын
hi how we can connect with you, for projects work
@ExcelForFreelancers
2 жыл бұрын
Hi and thanks, Feel free to email me here: Randy@ExcelForFreelancers.com I can refer projects to qualified developers.
@nurulislamnurulislam2660
2 жыл бұрын
Love
@ExcelForFreelancers
2 жыл бұрын
Thanks so much. Very kind of you
@Ppatte765
Жыл бұрын
Hello. Upon following your video I did the same project with you. When it comes to the developer mode and the coding I run into a persistent issue in the debug process when it reaches the advanced filter code. I entered the same code as you had put and no matter how many times I try and debug this the issue still remains. Is there any possible fix I can do to make it work?
@ExcelForFreelancers
Жыл бұрын
Hi Leiderson, 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.
@wallyandkelly50
Жыл бұрын
When trying to finish the project, it is saying there is a compile error: Variable not defined under the Sub Project Load (LastItemResultRow) Line 4 under Last Item Row. Can you please help me figure out what the issue is? LastItemResultRow = Sheet3.Range("N99999").End(xlUp).Row
@wallyandkelly50
Жыл бұрын
I figured it out after some investigating. At the top of the page, I misspelled the LastItemResultRow As Long. This Video was amazing and with no experience what so ever, I was able to follow through your video and learn a lot.
@ExcelForFreelancers
Жыл бұрын
Thank you so very much, I really appreciate that Wally and I am glad you were able to figure it out. I am happy to help and share
@kellydelagarza2519
3 ай бұрын
Do you sell this excel format?
@ExcelForFreelancers
3 ай бұрын
Hi Kelly, Thanks for your comment. You can download this file for free using the links in the description under the word DOWNLOAD. If you would like to purchase this & 300 of my best Excel templates, you can do so from here: bit.ly/300WkBks_Randy I hope this helps and thanks.
@kraei9799
29 күн бұрын
I never received the free template after putting in my email.
@ExcelForFreelancers
29 күн бұрын
Hi If you have tried to download this workbook using the links but had a problem please email Shane@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
@vincentcalmang4590
4 жыл бұрын
Hi sir. May I request a video tutirial and template for Savings and loans. Thank you
@ExcelForFreelancers
4 жыл бұрын
Great suggestion I will do my best and thanks. I do have a General Ledger training here in KZitem that you may like. Thanks again.
@vincentcalmang4590
4 жыл бұрын
Looking forward for your positive response sir. Thank you again
@hajjiMalulu1
Ай бұрын
Hi, I cannot reach any of your links and cannot download the free files Regards
@ExcelForFreelancers
Ай бұрын
Hi and thanks. I have just checked the link myself. The one under "⬇DOWNLOAD THIS WEEKS WORKBOOK FREE: " it is working fine. Please make sure to use that link. I hope this helps and thanks so much.
@user-rt6dw6xi9u
4 жыл бұрын
Have your any basic vedio in excel? then day by day i will developed my skill?
@ExcelForFreelancers
4 жыл бұрын
Hi Nahid, 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/
@qualityhardwood5356
2 жыл бұрын
Can I buy a product like this from you?
@ExcelForFreelancers
2 жыл бұрын
Hi and thanks so much. You can purchase this template along with 200 of my best templates here: www.excelforfreelancers.com/product/200-of-my-best-excel-workbooks I hope this helps and thanks so much.
@bhavneshparikh8283
3 жыл бұрын
I have mfg more than 800 product every product item wise batch wisi costing any format can be available?
@ExcelForFreelancers
3 жыл бұрын
Hi and thanks, yes sure this is possible. You can download my application and customize it however you like. I hope this helps and thanks so much.
@gimdawis4472
4 жыл бұрын
Hi sir, does the availment of the 150 worksheets one time? And if you have future new worksheets, it will require new payment?
@ExcelForFreelancers
4 жыл бұрын
Hi Gim, thanks so much for your interest in the 150 workbooks. Any new workbooks created can be downloaded for free directly from the KZitem video. I hope this helps and thanks.
@tomislavvukovic5118
3 жыл бұрын
Hello Randy, well i download your project and when i click "add new one" i got "run- time error 1004" and message "method- row of object range failed" ?.. btw i use office 2016 on mac os
@ExcelForFreelancers
3 жыл бұрын
Hi Tomislav, 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.
@Verifierabfi
3 жыл бұрын
Could you solve the problem?? It also happened to me.
@ssa5048
2 жыл бұрын
Good video, but not for someone who is new To macs
@ExcelForFreelancers
2 жыл бұрын
Hi and thanks so much. For beginners, 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/
@ArifulIslam-gr2yw
2 жыл бұрын
Gd video
@ExcelForFreelancers
2 жыл бұрын
Thank you so very much, I really appreciate that Ariful
@shohagsumon7933
2 жыл бұрын
গুড
@ExcelForFreelancers
2 жыл бұрын
Thank you so very much, I really appreciate that Shohag
@victoriakipchumba7717
10 ай бұрын
How do I delete a project?
@ExcelForFreelancers
10 ай бұрын
Hi and thanks very much. Range("B4").value holds the project row. You would then write a macro that takes this row and deletes it from the project sheet such as Sub DeleteProject() Dim ProjRow as long ProjRow = Sheet1.Range("B4").value Sheet2.Range(ProjRow & ":" & ProjRow).EntireRow.Delete Project_New End Sub I have not tested this out however it should work for the most part I hope this helps and thanks so much.
@mdshohag9170
2 жыл бұрын
wow
@ExcelForFreelancers
2 жыл бұрын
Thank you so very much, I really appreciate that
@Haniyamahmed
Жыл бұрын
Can i have excel sheet
@ExcelForFreelancers
Жыл бұрын
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@shyladdu9053
2 жыл бұрын
Can you share this file please
@ExcelForFreelancers
2 жыл бұрын
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.
Пікірлер: 236