data comparison

I have 2 tabs where the first 4 columns have similar data sets. The 1st tab is the existing data. The 2nd tab is the new data (which may or may not be different from the existing). Essentially: I need to be able to update "Existing Data" with the New Data. Any new employees on New Data I will...

Hi Guys, I have "SalesTable" and If I select March 1st 2017 to March 15th 2017, it has to calculate immediate 15 days before data and show the % change. or If a user select 10 days of data it has to compare the immediate 10 days previous data and show the % change. Please help! Thanks &...

Hi, I have problem with this formula: Sub Cell_color()Dim MyWorkbook As Workbook Dim Matrix As Worksheet Dim Help As Worksheet Dim Data As Worksheet Set MyWorkbook = ActiveWorkbook Set Matrix = MyWorkbook.Sheets("Matrix") Set Data = MyWorkbook.Sheets("Data") Set Help =...

Hoping someone can help me with this one. I've tried the COUNTIF and the IF methods I could think of and I can't figure how to make a simple formula I can put into the cells of a column that will do the following: Consider that Column E needs to contain a list of dates. 1. I need a formula...

Okay, don't know if that Title will do it. However hopefully someone can help me with the following. I think it is conditional formatting that I want to use, but it doesn't seem to be quite right. I have a row of numbers and I want to have the system notify me or colour the cell or in some way...