asset

  1. M

    Enter "today's" date when data entered into a specific cell?

    Hi guys, I'm setting up an Excel sheet to maintain a spreadsheet for asset management. We have an asset management system in place, but there are occasional times where it's offline(Or I am), so I wanted to make something that I could chart these items on, and I wanted to get a little fancy. So...
  2. R

    Concatenate column into textbox on input form - VBA

    hello All.... I have an excel input form where the user enters a WORKORDER NUMBER (WONUM) and Asset assigned. Most of the time there will be multiple assets per wonum, each of these assets are a separate entry. What I'm trying to accompish: I want a text box that will list these assets in a...
  3. S

    Lookup If Blank Or only have certain value

    Good day, I have a sheet with Asset Type code, Customer plant and Asset Number. The Asset Type code indicates the configuration on the machines and is not a unique number. The Customer plant is also not unique but Asset Number is unique. There can be numerous Asset numbers for one Asset Type...
  4. S

    Lookup If Blank Or only have certain value

    Good day, I have a sheet with Asset Type code, Customer plant and Asset Number. The Asset Type code indicates the configuration on the machines and is not a unique number. The Customer plant is also not unique but Asset Number is unique. There can be numerous Asset numbers for one Asset...
  5. P

    Multiple Dynamic Lists

    I’m trying to set up a table where you can have multiple dynamic lists. For example, column 1 has a drop-down list containing the asset group, column 2 would then have a sub-category if there is one otherwise it would remain blank and column 3 would then show the correct assets attributable to...
  6. A

    Limitation on rules in power query

    Hai, Can i know that how many number of rules maximum in power query? I have some rules in power query as below, the problem the query not functioning if i add few more query to this. Really need your help and how to increase numbers rules or any other alternative. Thank you in advance...
  7. W

    Using Indirect to reference another WORKBOOK

    Hello All, I have a large accounting file with parallel construction which I need to pull into each of my assets Profit and Loss Statments. Each asset has a separate PnL page, and in my accounting worksheet, I have each asset named seperately. I'd like to create a formula where I type in the...
  8. T

    Amalgamate rows onto new worksheet

    Hello, I hope someone can help. I have a sheet of data (Sheet1) which I need to manipulate using VBA. I want to keep the existing data (for sanity checking) and generate an amalgamated version on a new sheet. The rules are quite straightforward: (a) if an asset has a freehold status only...
  9. A

    Current Depreciation Not to exceed cost of asset

    I would like to calculate current depreciation which should not exceed the cost of the asset, which is in cell b2. Thanks. The current depreciation is being calculated as under: =IF(A8="","",ROUND(IF(A8=1,SLN($B$2,0,$B$3)/12*DATEDIF($B$4,$B$6,"M"),SLN($B$2,0,$B$3)),0)) <tbody> A B C D E F...
  10. N

    Depreciation schedule in Excel for Straight line method

    Hi, I am trying to create a straight line Depreciation schedule forecast in Excel , based on the asset register received , for the purpose of Forecast , <colgroup><col><col><col><col><col></colgroup><tbody> Asset Current Cost Accumulated Depreciation Net Book Value Date Placed In Service...
  11. P

    Charting Descending Values with Bars Coloured by Type

    Hi, I have a set of data that has three colums; a centre identifier, the type of asset it is (each centre will be classified as an asset type and I have 5 different asset types) and the profit it makes. I have seen a chart before where it shows each centre's profit as a bar (so you get a visual...
  12. N

    DB depreciation function

    Hello, I have a list of assets that went in service in different dates and I want to use DB function to calculate depreciation BY MONTH. I tried =DB($J$43,0,60,R2,4) where: J43 is end of PPE balance 0 salvage value useful life 60 months R2 =1 or the first period when depreciation start 4 is 4...
  13. R

    eVTOL distro algorithm help

    To whom might be able to help. In the example above location 1 fulfill their 50000 lbs delivery with the first two assets. Would like to modify algorithm so that location 2 is fulfilled with the next available asset (right now starts again with the same assets) and on to the next location so...
  14. B

    Separate numbers into separate cells on another sheet

    Hi, first time poster here...go easy! LOL I have a spreadsheet and in the asset column i have a list of numbers related to that one line of information. All separated by a comma <tbody> Number Title Rev Asset total amount of assets UC02-WPD-UT-REP-N001-000012 Network Design - N1 P01...
  15. M

    Confirm existing serial number entry in excel using a barcode scanner

    Hi All. So I am smack in the middle of a full hardware inventory audit. This means I need to use an existing excel sheet that contains asset numbers and serial numbers. My excel headers are like this: Asset | Name | Serial | Model | Site | description | Change Typically I just print this...
  16. D

    Formula to flip asset to liability and vice versa

    I have financial instruments that need to be recorded as an asset or liability depending on their values. Any suggestions on a formula for the journal entries in columns E and F?
  17. S

    Updated Value from 1 Sheet to another

    Hello all, I have excel in the below format. <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color...
  18. L

    Conditional Formatting Based on List

    Hello! Simply, I was wondering if anyone had a method for conditional formatting (Font Color) for a row based on whether or not the last four digits of an asset appear in a separate table. (Table A) I've got a spreadsheet that has a large list of equipment as well as columns with current...
  19. A

    Removing duplicate entries from a data validated drop down list in a three tier Cascading List.

    I've managed to create a spreadsheet for subcontractors (i work in construction) to auto generate document numbers from 18 mandatory metadata fields (Only 8 fields fill the Document number but the others are mandatory to the EDMS system we use (Aconex)). One section is looking for specific...
  20. X

    Transposing cells using macro and adding additional data

    Hey Guys, in a bit of a pickle. How do I transpose cells from Columns to rows using a macro and also include the Asset Number and Date next to its respective element. <tbody> Asset Number Date Iron Cr Nickel Al Pb Cu Silver TA20 12/12/2018 24 25 26 52 45 85 65 TA22 10/04/2018 65 875 45 895...

Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
  • IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top