date lookup

Thanks all in advance. So I am trying to use Excel to automate Accounting Financial Reports, in particular, a Balance Sheet which shows the balance of all accounts as at a particular date, essentially a snapshot of accounts. I will be pulling this data from Bank statement transaction data...

Hi, I'm trying to find a formula that will help with the below conundrum (sorry for not using the XL2BB, but I don't have permission to download on my work laptop). Basically, The criteria can be found in cell B7, B8 and B9 and the correct result of 3 has been returned in cell B10. What this...

Good Day, I am a commercial pilot and I am developing my own flight logbook sheet (I know there are 1000'ds out there, but I want my own.) I have it fine tuned, I just need some help with what I think is a VLOOKUP function, but I am not sure. So what I have done is I have 2 Tabs, Tab 1 is the...

Hi, I'm looking to pull a date (call it D1) from 1 tab, and look it up with the match function (yes, must be the match function because there are other criteria involved). Problem is, the date i am looking up can be Any day of the year, but the table i am looking it up in (call it D2), is only...

Hi, I have two different data sources which gather information on users. One is a telephony recording system and the other is a CRM type system. I have generated CSV dumps from both systems. I would like to build a formula which would use a name and date/time from the CRM sheet and then find...

Hello, I have two tabs on my excel sheet, one is the summary and the other tab is the data tab. I need to find the most recent date for the "State" and "Store" combination where a sale occurred. Example: PA had a most recent sale on 1/21/13 in Store 20 NY had a most recent sale on 1/22/13...

So I have been researching this issue for days and I have to say I am stumped. What I am trying to do is put together a perpetual Calendar that is it's own worksheet that can change month to month and year to year. I have been successful building the Calendar and many other upgrades with out...

Hi I have several files which I need to run a report for, I'm looking for a macro which can look up the date in Column "V", in workbook xyz worksheet1 & return back values in column A,B,D of the same row. Thanks in advance

hi, i have sheet1 that has a list of dates in column J, starting at J2 down to J42. in sheet two i have another list of dates in column E starting at E5 down to EX, X because these dates are being populated from an external feed and I don't know how far down the rows it will be populated (i.e...

What would be the macro and vba code for this project? Here is a print screen of a project I have designed. It is for a small hotel, for group sales managers. I don't want them to have access to change the excel file. Currently they manually put in all the dates they are looking for to get a...