purchase

So I am creating a portfolio model for real estate and there is 4 possible ways to purchase a property. Creating 4 different possible cash flows. I need to pull the cash flow based on the way I am purchasing a property and based on which year it was purchased. So for example...

I'm trying to build a worksheet to help me calculate the lifetime costs of various vehicle ownership strategies. (Finance, Lease, Buy with cash, Buy Used, etc.) I've got the whole sheet working, except that I'd like to be able to modify a value in a single cell (Length of Ownership) and have it...

I've been tasked with a project that requires something more robust and secure than Excel macros. In the distant past, I wrote projects like this using Visual Basic. Since Visual Basic has gone the way of the Pony Express, it's not an option. I was thinking about using Visual Studio, but...

Hello, I run a spread sheet to record orders for manufacturing. To produce a purchase order for suppliers I use a macro that pastes my raw data into a template tab which in turn is linked to an Purchase Order tab. This just rearranges the data into a format that is a bit more readable. My...

Hi Guys On sheet 1 I have invoice totals input for various suppliers on various dates. They are not input in date order or supplier order but as they are taken off the pile. I need to take all that data and sort it on sheet 2 by supplier(Column B) and then date (Column D). Multiple invoices...

<tbody> Name purchase 1 purchase 2 purchase 3 Amount customer since years membership <colgroup><col></colgroup><tbody> Abricht </tbody> <colgroup><col></colgroup><tbody> 1 </tbody> 4 0 <colgroup><col></colgroup><tbody> $291 </tbody> <colgroup><col></colgroup><tbody>...

Hello everyone, Nice forum you've got here, I hope my first thread will be useful for others with similar problems. I need to count how many different values are there in a column which meet a condition. I intended to use this formula...

Hello guys, I have a list of purchase orders (PO's) in sequential order (one below the other) all in excel that begin with a company name in Column A, "Cardiac.." and ends with a "Signature" line also in column A. The PO's data are occupy Column A to Column I. Each purchase order is of...

Hi, I have 4 columns, as you can see below (Excel) <colgroup><col><col><col><col></colgroup><tbody> CustomerID TransactionDate Amount Date of 1st purchase 19 19/12/2016 131.5 19/12/2016 1465 24/12/2016 73.44 24/12/2016 2389 25/12/2016 49 25/12/2016 367 26/12/2016 25.9 26/12/2016...

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