lookup between sheets

I have one file (Pay Statement) with Employee numbers (column B) and pay period dates (column E). In column M I am trying to pull in data from another file (History). The History file has the employee number (column A), the effective begin date (column C), effective end date (column D) and the...

I am struggling with finding a way to highlight cells in my data preferably using conditional formatting in colour for sorting the following or flagging in some sort. My actual data source has about 8,000 people so manual sorting is not needed and I need to make sure I record each step for...

looking for a formula where by i enter a sheet name and it will retrieve values from that specific sheet, all sheets will have the same formatting and cell locations such as names, id, etc. Application form: <tbody> Name Employee ID Date Start Date End No. Of Days Reason Department...

Hi. I have an worksheet that is updated every week. However, I want to copy and paste the values from 2 different cells into another worksheet. Worksheet 1 will have a date entered in cell H1. I want to find that date in Column A on worksheet 2, and then I want it to copy the value (as the cell...

I have a multi-sheet workbook which has some sheets called Week1 Week2 etc. I also have a sheet with a range of dates in column AB4 to AB35 In the worksheet Week1 etc, I have dates stored in row B5 to H5. I have a named range called "SheetList" which contains the names of the worksheets Week1...

Hi, I am looking for a solution to check redo based on multiple criteria. There are basically 2 values in column P and Q it should check both in another sheet named "Previous" if value of P Q matches values in "Previous" and is with 1 month (matching value "Visit") or 3 months (Matching value...

Is there a way I can modify this Index Match formula, or use a different formula, so that I can reference by column/field names instead of clicking on specific column references?: =INDEX(source!E:E,MATCH(A2,source!D:D,0)) Instead of source!E:E I'd like to find "DESCRIPTION" in row1 of the...

Giving an example because its very hard to explain. IE: I have formulas that searches for employee names on sheet 1, A2:A15. All ten rows are locked with those formulas and formatted as "text". Some rows are blank and some have names in it. I am on sheet 2, and I want to transfer those the...

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, An urgent question and any help appreciated I am working with a model which uses two tables. The first one is historical (there is column Updated Date)and is updated every week. So lets say it is my fact table where I have many lookupvalue columns to look data from my other dimension...

I am using Excel 2010 and using Windows 7 professional. I am creating a spread sheet to act as a timetable for a list of exam subjects. On the first sheet (Called Timetable) I have a table with the names of school subjects along the vertical heading, and then names of various stages along the...

Now that people have learned I know Excel just SLIGHTLY better than the average joe, I have suddenly found myself the recipient of every Excel project in the business. ;) So here's the latest: Marketing/Mailing campaign involving 10s of thousands of people. Our team wants to keep track of...

Hi, I'm new with VBA but did quite a bit of macros last week with the help from this forum. Now I'm stuck with this one and can't figure it out. Any help is much appreciated. I have a schedule something like this on Sheet1: <tbody> Name Mon Tue Wed John Surrey 0900-1700 Van 1230-1945 APH...

I'm using the below formula to use a Vlookup to copy from an adjacent cell, out of the range B3:C20 =IFERROR(VLOOKUP(A3,$B$3:$C$20,2,0),"") I am wondering what the formula would be to pull the number from a different sheet, within the same workbook. Specifically i'm working with: Cell (A3)...