multiple cell reference

At some point I will be able to help more than asking for help. I'm trying to get it so the selected cell will display "WJ" if cell Z2 or AA2 has a number greater than 0 but less than 90. So far I have not been successful at getting it to work. You all are so knowledgeable that it's probably as...

I’m trying to create a macro to look through multiple workbooks that are daily logbooks and have the number in a particular cell from each work book be shown next to the date of the external workbook. Each workbook follows the same naming convention of Year_Month_Day Shift Log and the data I...

I am attempting to define names for all cells in an entire column of a range. In this column, there are repeating values, which are always next to one another, by design. What I am looking to do is to have each set of cells that have the same content (again these cells are next to eachother)...

Hi guys, Hopefully quite a quick question here. I'm trying to add data validation to a cell, based on two criteria: 1) The value entered in the cell must be a number 2) The cell one to the left of it must be blank In the custom formula input of the Data Validation box for cell B1, I have...

G'Day Excel people's, Background: What I have is an Excel sheet set up as a monthly schedule. Currently a file number is allocated to each job manually in a separate Excel workbook and then this is manually inputted onto the monthly schedule. This is a cumbersome timely process (and who here...

Ok everybody this is my first post and I am completely stumped! I work for a company where we track our employees times by using gps time stamps through an iphone application. Here is the way I invision the spreadsheet working. The Meta data from the gps pings from the employees phones comes...

I have a sheet where in Column A1:A1001 there is a list of numbers, similarly in column B1:B1001 there is another list of numbers. I wish to see which of the numbers in Column A are there in Column B and then have the absolute cell address / reference of these matching numbers present in column...