expense

Hi, So what I am trying to accomplish is Cell B1-D1 is the dates 9/25/17-9/27/17. A5-A15 are my vendors listed B5 is where I would like to start inputting information. What I am trying to do is make a formula that looks up to a table on tab 2 (A3 "Vendor Name", B3 "Expense Category",C3 "invoice...

Can someone share or point me in the direction of a spreadsheet template where I can enter in my bills due and figure out how much in expense versus income for the bi weekly pay periods? any ideas would be helpful as well.

Hi all, I'm new to the forum. So I've never done formulas before & I want to create one. I need the total amount on the sheet (would it go at the top?) & then I will add the expenses in the rows (I assume it's one expense per line), & then as they are added, they subtract from the total &...

Hi everyone, Thank you all in advance for your assistance. Background: I work for a construction company and am trying to make a workbook that I can use to track the expenses incurred, deliveries received and revenues produced on a day to day basis. My goals. 1. (1) master work sheet that i...

Hello, I'm trying to build an expenses management tool in Excel 2007. The main sheet should scan the app directory for another xls_ files and extract my expenses data from them. I wrote this VBA code for the data import: Public Function sumMonthExpenseByCategory(ByVal istr_WbFilename As...

Hello I've been writing long, computationally expensive macros lately, and have noticed that VBA is considerably slower at certain types of computations than others. Copying/pasting, debug.prints, and Application.ScreenUpdating = True are some expensive operations that stand out to me. I was...

Dear Excel experts, Is it possible to do this WITHOUT Visual Basic or programming or even without a table, because I want it to be as simple as possible, but I might settle for having a table column A is for date, column B is for daily subtotal (I want it to appear next to the date), column...