![Cris Minas](/img/default-banner.jpg)
- Видео 30
- Просмотров 3 692 941
Cris Minas
Добавлен 23 дек 2015
2 Ways to Unhide Selective Rows in Excel ( Unhide one at a time )
REFRESH BUTTON CODE
Application.ScreenUpdating = False
'clear contents
Range("B10:F19").Select
Selection.Clearcontents
'hide rows
Rows("11:19").Select
Selection.EntireRow.Hidden = True
ADDMORE BUTTON CODE
Application.ScreenUpdating = False
On Error Resume Next
Dim lHiddenRws As Long
With Cells.SpecialCells(xlCellTypeVisible)
lHiddenRws = .Areas(1).Rows.Count + 1
.Areas(1)(lHiddenRws, 1).EntireRow.Hidden = False
End With
SAMPLE TEMPLATE ( Download Here )
drive.google.com/file/d/1V6QTuIzwjGV4TlH3RgqRBtMvph4lZrI0/view?usp=sharing
Application.ScreenUpdating = False
'clear contents
Range("B10:F19").Select
Selection.Clearcontents
'hide rows
Rows("11:19").Select
Selection.EntireRow.Hidden = True
ADDMORE BUTTON CODE
Application.ScreenUpdating = False
On Error Resume Next
Dim lHiddenRws As Long
With Cells.SpecialCells(xlCellTypeVisible)
lHiddenRws = .Areas(1).Rows.Count + 1
.Areas(1)(lHiddenRws, 1).EntireRow.Hidden = False
End With
SAMPLE TEMPLATE ( Download Here )
drive.google.com/file/d/1V6QTuIzwjGV4TlH3RgqRBtMvph4lZrI0/view?usp=sharing
Просмотров: 6 466
Видео
EXCEL INVOICE GENERATOR (w/ Inventory System + Login Features) FREE DOWNLOAD
Просмотров 28 тыс.5 лет назад
(For Windows Only) Download Here: drive.google.com/file/d/10dnswkDcc-39dw_h5kE3Vr_EyXiUonys/view?usp=sharing How to use the Invoice Generator w/Inventory System ruclips.net/video/E0TKlar1ZtA/видео.html Sheet and VBA Password: crisminas
How to Create Expandable IN & OUT Inventory System
Просмотров 271 тыс.5 лет назад
Dynamic/Expandable Inventory System Sample DOWNLOAD HERE: drive.google.com/file/d/1wnpyMXebhaoVANaJ0jRRjQV411A-NPzo/view?usp=sharing
EXCEL INVOICE GENERATOR (w/ Inventory System) FREE DOWNLOAD
Просмотров 53 тыс.5 лет назад
(For Windows Only) DOWNLOAD HERE: drive.google.com/file/d/1cM09hNq7-6zOKm42panLl5nlLj8FmyQ8/view?usp=sharing Note: The VBA of this template is not editable.
How to Auto HIGHLIGHT INVENTORY when Stocks Level Reaches the Re-Order Level
Просмотров 81 тыс.5 лет назад
Download this template as your starting point... Download this sample template for your starting point... drive.google.com/file/d/1wnpyMXebhaoVANaJ0jRRjQV411A-NPzo/view?usp=sharing
How to Add Sales Return Update to your Inventory
Просмотров 6 тыс.5 лет назад
✅Download this template for your starting point.... 📎Download Here: drive.google.com/file/d/11gzF0_r2JeYGvfj3AGMLGABnq22Ap8aE/view?usp=sharing ✅How to Create a Dynamic/Expandable In and Out Excel Inventory 🎬Watch here: ruclips.net/video/YRkz62C235g/видео.html
Excel 2007: How to Switch Ribbon into a Classic Menu
Просмотров 4,8 тыс.6 лет назад
I recommend you to familiarize Ribbon UI, it's actually much better and easy to use than classic menu. But in case you loss your sanity trying to find what you looking for, this is an easy way to get back on classic menu.
Excel Automated Invoice Generator (FREE DOWNLOAD)
Просмотров 226 тыс.6 лет назад
EXCEL INVOICE SYSTEM TEMPLATE Note: The VBA of this template is not editable. 📌To save the invoice as PDF on your computer, create a new folder on your C: Drive and name it INVOICE. Tutorial @ 7:43 of this video. 📌To add more items? Watch at 8:51. 📌FILE PASSWORD: crisminas DOWNLOAD HERE: EXCEL INVOICING SYSTEM TEMPLATE for Windows drive.google.com/file/d/1i4xFAy1pdCGmcHwS7-VxrmqVn68a4iSl/view?u...
How to create AUTOMATED PAYSLIP in Excel
Просмотров 397 тыс.6 лет назад
AUTOMATED PAYSLIP TEMPLATE SAMPLE DOWNLOAD HERE: drive.google.com/file/d/1a-94VakzYFP7-jtaO1CXE8VpL15nUqF2/view?usp=sharing
Excel Inventory System Template (FREE DOWNLOAD)
Просмотров 266 тыс.6 лет назад
DOWNLOAD HERE: Excel Inventory System Template drive.google.com/file/d/1FjsCRjYsNrTgpw6gcL4zYvM5M1dajMHW/view?usp=sharing ⚠File Password: crisminas
AUTOMATED INVOICE: How to add More Items or Products
Просмотров 8 тыс.6 лет назад
Convert your ordinary list into a dynamic table so you can add more items or products to your ITEMS LIST and INVOICE.
Paano mag Encash ng Adsense/Youtube Earnings sa Western Union
Просмотров 2,5 тыс.6 лет назад
Hi Co-Pinoy RUclips Beginners!!! Did you know that you can encash your Adsense or RUclips earnings in a fast way, hassle free, safe and CHARGE FREE?
How to Add Markup Price,Tax and Discount in your (EXCEL INVENTORY SYSTEM)
Просмотров 9 тыс.6 лет назад
Aside from stocks, you can also monitor your sales right in your inventory. NOTE: If you find this incomplete or a bit confusing watch first my tutorial on "How to Create Inventory System Using Excel".
How to Register Essensa New Members (TAGALOG)
Просмотров 4066 лет назад
Newbie sa Essensa? Here's the full tutorial on How to Register your New Member.
Update Product Prices w/o Losing the Old Price Records (EXCEL INVENTORY SYSTEM)
Просмотров 12 тыс.6 лет назад
Now you can update the Product Prices w/o Losing the Old Price Records. NOTE: This video is an update to my Excel Inventory. If you find this a bit incomplete or confusing, you may watch first the main Excel Inventory. Watch here: How to Create Inventory System Using Excel ruclips.net/video/Hlj4iENANnQ/видео.html NEW UPDATE: Add Selling Price with Profit/Tax/Discounts ruclips.net/video/1DyKK5VV...
How to Encode Essensa PV CODES (TAGALOG)
Просмотров 1,6 тыс.6 лет назад
How to Encode Essensa PV CODES (TAGALOG)
How to create Simple and Auto-Fill Invoice (w/ Drop List)
Просмотров 117 тыс.6 лет назад
How to create Simple and Auto-Fill Invoice (w/ Drop List)
How to create Simple and Auto-Fill Invoice in Excel
Просмотров 221 тыс.6 лет назад
How to create Simple and Auto-Fill Invoice in Excel
Extra Special Chicken Macaroni Salad
Просмотров 312 тыс.7 лет назад
Extra Special Chicken Macaroni Salad
How to create simple IN and OUT Inventory System in Excel
Просмотров 1,6 млн7 лет назад
How to create simple IN and OUT Inventory System in Excel
How to Make Mango Float/Graham Cake |crisminas
Просмотров 3,6 тыс.7 лет назад
How to Make Mango Float/Graham Cake |crisminas
Easy Max's Style Fried Chicken |crisminas
Просмотров 87 тыс.7 лет назад
Easy Max's Style Fried Chicken |crisminas
Fortune Island Nasugbu Batangas - Philippines
Просмотров 6987 лет назад
Fortune Island Nasugbu Batangas - Philippines
Stir Fry Beef with Ampalaya - crisminas
Просмотров 6 тыс.7 лет назад
Stir Fry Beef with Ampalaya - crisminas
Kanlungan Lyrics (Dedicated to Saturn Batch 2004)
Просмотров 1297 лет назад
Kanlungan Lyrics (Dedicated to Saturn Batch 2004)
Anawangin and Pundaquit Zambales - Philippines
Просмотров 4817 лет назад
Anawangin and Pundaquit Zambales - Philippines
Can I get the unprotected version of this as I would love to customize it. This is exactly what i am looking for. Great job
Can some Please share link of the Excel Sheet they made they made Thanks
HELLO!!! I have a issue when I enter Item eleven and try to purchase the same item from 11, 12, 13 ....... I get the message stock not available...... help please the system is so simple and understandable to use in my small bussness
Hi Ms cris, I have an issue on your excel sheet , when I input the purchased items it says stocks not found. I tried everything, I double triple check the product code its correct but it cannot find the stocks. Eats the solution for this? Thank you
thank you so much big help
I might look dum, but if the quantity is less then?
I need formula for entering same data for like customer name is abc its address and phone number if i enter abc in cell a then its address and number is automatically fill in cell c and d please help
The Caesar King now orders the reorganization of every U.S states per profit systematically arranged, each U.S state businesses shall be recorded which and how many U.S owned business overseas and in mainland U.S, then each enlisted business per State shall be required to allocate percentage of profit contribution for the repurchase and creation of more U.S treasury assets, money, properties and other fund sources meaning there must be a standardized required percentage calculation of percentage contribution with consideration of the business history and earnings and business performance like annually in a pre selected time period wherein the money percentage calculation shall be offsetted or reimbursed in company tax payments by partial method with minimum to maximum tax reduction and with minimum to maximum money percentage contribution per business in each and every state wherein policy can be better implemented because each U.S State holds or hosts those businesses located and registered there. Meaning proper tabulation is needed, and if there's shortage from the minimum money percentage contribution for boosting U.S Treasury reserves due to Business problems, then the lacking percentage be payed next time with full payment of the next percentage calculation, wherein each state who do not miss any payments or have minimal misses of percentage money contribution for U.S Treasuries, like the U.S flag stars arrangements their state named on top or the next line of stars to whatever their business performances and U.S Treasury contributions and those states who branch out in money making and created more businesses per time allotment standards and always above the other star states in record, shall be prioritized for investors traffick and business type traffick of newly cropped U.S businesses and foreign businesses coming to America, and shall have better business accolade and attention in U.S social media and business news. And U.S state businesses going overseas for business ventures should be required to pay some percentage to U.S treasury but some percentage funds payed shall be recorded as their company bonds in relation to U.S treasury for their return for business in the States and to encourage them to do that. The Caesar King order for U.S.A Treasury shall be effective now as ordered and a programmed event. Let it be
sa login po nakahide po yung form niya
2:25 Index and Match Function
password
Hello team, where is the download link for template? I can't access it, or it was removed?
Today, I found a gem on RUclips named Chris Minas. Amaizing
"You didn't speak a single word, and I didn't hear a single word, yet you explained everything, and I understood it all. Amazing! Hats off to you, Chris, for your incredible knowledge and teaching skills. God bless you for helping us learn and gain knowledge. Keep up the amazing work!"
This Video Was Awsome. and too much easy to apply Thanks Brother
the password to unlock the sheet is crisminas
Hello Cris...Do you have semi monthly payroll tutorial?
Its still available?
Im looking for plastic pallet inventory system trucking the coded out return plastic pallet, agieng,total out and in per customer,something like that, thank you and hoping...
wow, ang ganda, pero pwede po bang palitan ang mga header names?
Can you use this setup with a barcode scanner if so how would you intergrade it thank you
Thank you so much sir. big help to us :D
Hello Sir! Do you have a template for semi monthly?
Thanks a lot!!!
well done, u did a great job. is it possible to have this file ?
Yes, link is in the description.
Can this be done with multiple tables on the items page??
Thank you so much for this
sir HM po pa customized ganito system?
Thank you dear for such type of video
Hello po, pwede po ba mapalitan ang SI?
lmao Konoha payroll. Perfection!
Thanks
It's really impressive inventory management but how can we convert to automotive Systems while using part numbers and not color and size ,pls assist i want to implement this...
How can I do this with GSheets :3
What I really do not like about this video is that there is no narration. How will blind people ever know this stuff when nobody is talking in this video?
This gives me the basics for EXACTLY what I was looking for. I wish you had a voiceover explaining what you're doing to give a better understanding though. I do really appreciate you sharing this!
This was really helpful! Thank you so much.
Can be available manufacturing inventory
Why is some columns not clickable? Please 🙏
Is it available for Mac ?
HI CRIS. Thanks for the form. I just can't figure out how to add another row because I pay salaries every 2 weeks. Is it possible to add an extra row for the extra week?
Thank you for this great video. One question/suggestion: to solve the identical names issue, refer to item codes instead of item description and you won't need to change or edit the item descriptions.
Oh my god thank you, I almost murdered my laptop by shanking a shard of glass through it, luckily i found you
Thank you maam
Hi, Cris, can you please share the VBA password, I want to learn the code, thanks
Hello Cris Minas, How can I contact you?
I include only 20 products. More than 20 are not allowed. How to include
You lost me in the stock inventory section bruh lol
I need a premium version of this excel file
Thank you sir for good helping video and new learning point