My columns A and B on sheet 2 of a document get derive their values from columns A and B on sheet 1. I currently have sheet 2 sorted by column A first, then B (alphabetical on both). However, whenever I sort sheet 1 to try to get it in the same order it screws up columns C-F on sheet 2. The rows do not stay together, and therefore my client information on sheet 2 is shifted up or down a few rows. How do I ensure that when the rows change order when sorting that each row moves as a unit, not just the first two columns moving and the rest being out of order?
I have a spread sheet with list of employee id's in column B. I have a 2nd spread sheet that has list of last names in column A, first names in column B and employee id's in column C. I need something that will look at each employee id on the first sheet, match that id up with one on the second sheet and then find the correspnding last name on the same row and replace the employee id with the last name in column B of the first sheet.
I have share prices of several companies in a column for 10 years. I need to calculate the difference in share price each year. Can you help me how can I put a formula that calculates difference at every 10th item?
I have created an action item task list. Column C has drop down lists which say complete, pending, and in progress with corresponding color coding. The column next to it is the due date and I would like to get that column to change color as you change the progress status on the left simultaneously.