finance

Hi everybody, I use this forum as much as I can to look for better ways to use Excel, but I'mn ot that good with VBA and I need ome help for restructuring some finance data into a Database tab. I have 4 tabs, identical formatting except the amounts per Month are different. The 4 tabs represent...

Hello, I need help in creating a custom function that will calculate variance of a stock using its raw prices. This means that the returns calculation will take place within the function. I have written the code, but its not giving the right answer, could anyone please guide me? Thanks in...

Hi, I am having an issue in using FV (Future Value) function in Excel. I am suppose to be comparing four different plans. FV function works fine for three of them. I am hoping someone to have a look at my Excel sheet and let me know where I am making a mistake? Regards

I've found some information online to help our finance department with expense amortization, however rather than having the amortization happen over days within the month (calculating the dailyrate * days in month), I'd simply like for this same functionality to work at a month scale, where the...

Hello All, I have this issue have been trying to solve for a while now and cant seem to find any solution. I'm hoping someone here can help me. Here is the issues. I have data that comes to me in this format and it have a few more columns and rows. Dept Users Finance I...

Trying to figure out the best way to turn my rows into columns, while maintaining the values and headers. Looks like a reverse crosstab query or something. I'm an amateur btw... I have about 35 columns that I want to stay the same (keep as columns), then about 50 column that have months...

Hi All, Kindly find the attached file in which I need formula to count data based on Account. The attached sheet will self-explain the exact requirement. Your help in this regards will be highly appreciated. <tbody> Desk Location Emp. ID Employee Name Account P4001 #N/A...

Morning all I was wondering if anyone could help me with a formula. I need to create a lookup using 2 criteria (department in column A and department in row 4. All the departments are listed A5 to A50 and Months B4:L4. So the first one would be Finance is in cell A5 and January is B4 and so...

Hello, I have to build monthly Income statements (IS) for 47 projects and one combined (IS) based on Trial Balance (TB) exported from accounting system into Excel. Under each account of the TB there are 48 rows related projects (47 projects and one not assigned to projects, in total 48...

Hi, I have taken over a cashflow model which is do with land acquistion. The model calculates in a land value before cost of finance. Then you take the cost of finance off however that is worked out on the site value which is being discounted to take account of the cost of finance. The cost...

Hi, I am almost there but struggling with the last part - I have a command line in an Excel workbook (SHEET1 cells A1 to A10) - I would like to have a macro to open cmd (command in MS DOS) and then copy the text in cells A1 to A10 to the command (CMD) line. So far I have Shell "cmd.exe /k...

Hello all, I would like some help with an issue I am having when I am running my macro. I am using Moody's Excel Add In, and as I pull in DataPoints using their API function it requests the data that I need. Although when I run a marco that has these formulas built with their API functions...

Hello, I am struggling with a formula to create a sumif with a dynamic range. The data I have is as follows: <tbody> ROW/COLUMN A B C D E F G H I J K L M N 1 Department Expense Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 2 Finance Phone 199 90 10 7...

Hello All - You were extremely helpful on my post about looking through multiple columns to see if a keyword was in there, but was wondering if you could help on this. The below is the formula you provided on my original post accomplished finding if a certain keyword was in columns H3 - R3...

Need a macro that will find every cell that contains text within columns A to E all the way down to the bottom. Then paste them in that exact order, but all in column A.

Hi, need to automize the description based 3 criteria. - Personnel number (#3 and #4 are letters short for department) - Personnel code (random) - Appointed period would like to have the description within such format: e.g:Finance_Department_01.01- 01.07.2012_PN_876789 (Indicated in red)...

Hi all, first time poster here, I am trying to build a spreadsheet where I can have a list of stocks I am tracking and notify me when a stock makes a new 20 day and 55 day high. I want to link yahoo finance data or google finance data. I found a formula that others said this will work with...

Can someone help me solve this.. I'm stuck :(

Hi, this one is completely beyond my level of VBA experience. I'm hoping someone can help with this. I have a rather complex Userform for easy data entry into a Excel Database. I now need help with the following, when the user clicks a Purge button, it looks for data in two columns (32 and 34)...

Hello everyone, Do anyone know a way to pull any stock price just by typing the ticker of the stock in excel, hence can get a daily rate on the stock. For example, using the ticker of Microsoft MSFT, pull the current stock price. Thank you