look up related data

Hi Team, I am looking for some help in getting the prior day data by compare with today's data table...refer the below two data set and help in formula to achieve the same..thank you <colgroup><col span="4"><col><col></colgroup><tbody> Day 1 Data Day 2 Data Project Probability...

Hello, I want to use autocompletion in a combo-box. I think it's not that hard to accomplish. I already have that code (VBA). Now I want to do the following: I have a sheet (ProductSelection) were I have 3 combo-boxes and a lot of other cells which have to be auto-populated when searching for...

Hi, Im trying to add in some way of tracking debt of customers in a spreadsheet. So far the formula say if a date is over 60 days then it will say Recourse =IFERROR(IF(O2>60,"RECOURSE"),0) But i now need it to do the same thing track if an invoice is over 60 days but also if the customers...

I have a workbook that contains 53 sheets (one for every week of the year and a Totals sheet) where I am downloading production data each week by operator and want to keep a running total in my totals sheet. There are a varying number of operators each week. I want to look for an operator and...

Hi all, I apologise if this has been answered before, but as anewbie all the terms are a little confusing. My challenge is this - I am posting all my accounting posts (lineposts?) in an Excel sheet. As part of the linepost, I enter in column C the account number that the amount of the post...

Hi all, I have been searching for a macro for a while now to cleanup a file that has many columns. I have five columns that are named in row 1. I want to grab only these five columns and move to a new workbook. The only catch is that this file sometimes changes and gets additional columns added...

Hi All, I have two sheets, Weekly Sales and Yearly Sales. Column A on Weekly Sales has the 7 days of the week running from cells A10:A16, On the yearly sales the dates run from cell A3:A368. The idea is that the weekly sheet is populated and then a macro copies all data from the weekly sheet...

Hello to whomever reads this, I am trying to create a Dutch to English dictionary, I have been listing words and their translations into excel. Additionally, I am toying with third and fourth columns that would display notes and an example sentence. I would like to be able to do the follow...