Cris Minas
Cris Minas
  • Видео 30
  • Просмотров 3 692 941
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
Просмотров: 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
No-Bake Banoffee Pie
Просмотров 4,2 тыс.7 лет назад
No-Bake Banoffee Pie
Dulce De Leche in a Can
Просмотров 4377 лет назад
Dulce De Leche in a Can
Fortune Island Nasugbu Batangas - Philippines
Просмотров 6987 лет назад
Fortune Island Nasugbu Batangas - Philippines
Grow Mung Beans in 3 days :)
Просмотров 10 тыс.7 лет назад
Grow Mung Beans in 3 days :)
Stir Fry Beef with Ampalaya - crisminas
Просмотров 6 тыс.7 лет назад
Stir Fry Beef with Ampalaya - crisminas
Block Certain Friends from your Post
Просмотров 2217 лет назад
Block Certain Friends from your Post
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

Комментарии

  • @WendyShowers-ke4fj
    @WendyShowers-ke4fj 23 дня назад

    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

  • @iZacq
    @iZacq Месяц назад

    Can some Please share link of the Excel Sheet they made they made Thanks

  • @mathayothomas6429
    @mathayothomas6429 2 месяца назад

    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

  • @rosesuam9776
    @rosesuam9776 2 месяца назад

    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

  • @rosesuam9776
    @rosesuam9776 2 месяца назад

    thank you so much big help

  • @what24by7
    @what24by7 2 месяца назад

    I might look dum, but if the quantity is less then?

  • @vivekpatel1491
    @vivekpatel1491 2 месяца назад

    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

  • @francishubertovasquez2139
    @francishubertovasquez2139 3 месяца назад

    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

  • @Rhoda_May_Magday24
    @Rhoda_May_Magday24 4 месяца назад

    sa login po nakahide po yung form niya

  • @user-mq7oi4cy3m
    @user-mq7oi4cy3m 5 месяцев назад

    2:25 Index and Match Function

  • @graphicspoint4925
    @graphicspoint4925 5 месяцев назад

    password

  • @corradommeta7513
    @corradommeta7513 6 месяцев назад

    Hello team, where is the download link for template? I can't access it, or it was removed?

  • @85MA
    @85MA 6 месяцев назад

    Today, I found a gem on RUclips named Chris Minas. Amaizing

  • @85MA
    @85MA 6 месяцев назад

    "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!"

  • @aminmedicalsotre5094
    @aminmedicalsotre5094 6 месяцев назад

    This Video Was Awsome. and too much easy to apply Thanks Brother

  • @user-fc9kf2jm9d
    @user-fc9kf2jm9d 7 месяцев назад

    the password to unlock the sheet is crisminas

  • @sharmainemiroy2857
    @sharmainemiroy2857 7 месяцев назад

    Hello Cris...Do you have semi monthly payroll tutorial?

  • @tokitohkii
    @tokitohkii 8 месяцев назад

    Its still available?

  • @bonsainitruepa5195
    @bonsainitruepa5195 8 месяцев назад

    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...

  • @Mychannel4you0719
    @Mychannel4you0719 9 месяцев назад

    wow, ang ganda, pero pwede po bang palitan ang mga header names?

  • @MrTimgrimm
    @MrTimgrimm 9 месяцев назад

    Can you use this setup with a barcode scanner if so how would you intergrade it thank you

  • @jdstv6914
    @jdstv6914 9 месяцев назад

    Thank you so much sir. big help to us :D

  • @kennethdizon8747
    @kennethdizon8747 10 месяцев назад

    Hello Sir! Do you have a template for semi monthly?

  • @faroukelkiouas7828
    @faroukelkiouas7828 10 месяцев назад

    Thanks a lot!!!

  • @frozenheart7027
    @frozenheart7027 11 месяцев назад

    well done, u did a great job. is it possible to have this file ?

    • @CrisMinas
      @CrisMinas 11 месяцев назад

      Yes, link is in the description.

  • @slantedcn6690
    @slantedcn6690 Год назад

    Can this be done with multiple tables on the items page??

  • @rodelvaldez8292
    @rodelvaldez8292 Год назад

    Thank you so much for this

  • @junbabida3052
    @junbabida3052 Год назад

    sir HM po pa customized ganito system?

  • @junaidjaved1941
    @junaidjaved1941 Год назад

    Thank you dear for such type of video

  • @annrosetan
    @annrosetan Год назад

    Hello po, pwede po ba mapalitan ang SI?

  • @infoonyx3797
    @infoonyx3797 Год назад

    lmao Konoha payroll. Perfection!

  • @alializadeh8195
    @alializadeh8195 Год назад

    Thanks

  • @joshuamumba9736
    @joshuamumba9736 Год назад

    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...

  • @florenzepomento3981
    @florenzepomento3981 Год назад

    How can I do this with GSheets :3

  • @seanhamilton4169
    @seanhamilton4169 Год назад

    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?

  • @deandagostino9305
    @deandagostino9305 Год назад

    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!

  • @edenrosales9849
    @edenrosales9849 Год назад

    This was really helpful! Thank you so much.

  • @bhavneshparikh8283
    @bhavneshparikh8283 Год назад

    Can be available manufacturing inventory

  • @Choosing_a_career_path
    @Choosing_a_career_path Год назад

    Why is some columns not clickable? Please 🙏

  • @waniyswork936
    @waniyswork936 Год назад

    Is it available for Mac ?

  • @candykatigbak4144
    @candykatigbak4144 Год назад

    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?

  • @MostAwesomestChannel
    @MostAwesomestChannel Год назад

    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.

  • @pills5310
    @pills5310 Год назад

    Oh my god thank you, I almost murdered my laptop by shanking a shard of glass through it, luckily i found you

  • @rheapeter9709
    @rheapeter9709 Год назад

    Thank you maam

  • @agustama4326
    @agustama4326 Год назад

    Hi, Cris, can you please share the VBA password, I want to learn the code, thanks

  • @damirishmukhamedov7076
    @damirishmukhamedov7076 Год назад

    Hello Cris Minas, How can I contact you?

  • @jothis7848
    @jothis7848 Год назад

    I include only 20 products. More than 20 are not allowed. How to include

  • @sweetvonbettie1
    @sweetvonbettie1 Год назад

    You lost me in the stock inventory section bruh lol

  • @salmanyounas1189
    @salmanyounas1189 Год назад

    I need a premium version of this excel file

  • @RahulKumar-ux8rb
    @RahulKumar-ux8rb Год назад

    Thank you sir for good helping video and new learning point