• excel_combi

    VBA macro combines multiple Excel files from a selected folder into a single workbook, seperated as tabs.

    VBA combine_files.txt

  • excel_cheat_sheet

    The link provided leads to a live OneDrive document, as I have plans to continually update the linked Excel file periodically…

    LINK CheatSheet.xlsx

  • bionic_vba_converter

    Bionic Document Converter – use VBA to apply the Bionic Reading technique to selected text in documents.

    VBA bionic_VBA.txt

  • barcode_generation

    Easily convert data to barcode. Note: file requires Fre3of9x Font

    Basically, whatever you scan or type into column A will be in text format (to reduce Excel’s unwanted automation of converting data to number) and have conditional formatting to highlight duplicates. You’ll then press the magic button and barcodes will be generated in column B. Delete data from column A and press the button again, and all barcodes will disappear too. This makes data barcode ready by inserting asterisks before and after data, then applying font changes

    CODE sub_apply_formula.txt

    README barcode_vba_README.txt

    FONT font_Fre3of9x

  • amazon_price_scraper_excel

    Microsoft Visual Basic for Applications – Tools – References – enable Microsoft XML, v6.0
    Add Module –

    Excel – copy Amazon product link to cell
    Excel – formula – amazon_price(refer to link cell)

    VBA Module_pricechecker.txt

  • no_man\’s_sky_resources_planner

    Simply enter how many of which building blocks you desire to generate a shopping list of resources required to fulfil the build. This was unfinished as not all building blocks have been entered into the data tab.

    Requires basic Excel knowledge.

    I did also attempt to calculate power requirements, but there are a lot of unknowns and the amount of power you can generate has too many outside variables.

    Also includes bonus Craft tab listing all resource recipes should you find yourself short on anything

    EXCEL NMSresourcesPlanner.xlsx

  • destiny2

    Bungies Destiny 2 armour combination calculator, not fully user friendly yet so requires basic Excel knowledge. As highest armour is not always the best due to anything under ten is dropped, so having the correct combination is key. Excel sheet – basically, tabs house all armour type stats, additional tab then uses filters to determine the best combination.

    EXCEL Destiny.xlsx

  • animal_crossing_excel_workbook

    Animal Crossing New Horizons Excel workbook, garden planning, villager combination planner, and effective Bell farming by season

    EXCEL Animal Crossing.xlsx