asset

Hi all, I have a cash flow model I am building with over 50 assets. Each asset tab's format is exactly the same. However, cell A1 of each asset tab has the name of the asset. I am trying to prepare an asset summary table. Is there a way I can do the following: If cell A1 between Asset Tab 1...

Hi All, i have 2 columns; COlumn A is the asset number. The asset number comes up multiple times as we need to do maintenance on our assets Column B is the date the asset number had its last maintenance completed if there a formula i can use to highlight to show the last date for that asset...

<tbody> Hi Would someone be able to help with the VBA code if cell does not contain "data" the go to next code? Eg: skip cell does not contain "Asset" the go to next code cell contains "Same"? I have the below code which I use to generate cell range contains "asset"...

Hello all, I know MS Access would be better for this but excel is what I have to work with. I am trying to create a macro that will allow me to scan the bar code serial number of an asset and log it in cell A2, then scan the location Out to B2, Check out, to C2, and Check in, to D2, Location...

Hello all. Here I am again in the need of your help. I have a VBA that I use to set values in my excel model. Each of those values are linked to a cash-flow schedule that I use to calculate IRR (using XIRR). The same VBA that set the values of the cash-flows also writes the resulting IRR in one...

Hi! So I have an existing worksheet that calculates SLD in a way that is somewhat manual. The columns are the years 2017-2027 onward and the life of the asset. The rows are: <tbody> Life 2017>>2027 (each column is a year) Asset 1 5 For each year is the asset purchase amount Asset 2 3...

HI all, I am having some trouble with grouping / binning type analysis. My data has the following columns of interest. Property ID: = Text string unique for each property Asset ID: = Whole number unique to each asset. Multiple assets belong to each property Value:= The value of each asset...

Hi All, As a novice using access I'm using the asset template database to create a (hopefully) simple vehicle registry for work. The current asset template included in access has a search box in the 'Asset List' form header which when used displays the relevant records. My vehicle registry...

I'm trying to create a graph. I can calculate the days of inactivity based on a "last active date". I have an asset number and a date the asset activity was measured. I want to measure the asset over time every ~7 days. The asset might sit for 90 days before being used and the measured...