Get instant live Excel expert help with ROW Functions

I'm trying to put together a workbook that keeps track of the monthly productivity of 50 officers in 5 different categories over a period of 6 months. The first 6 tabs of the workbook will be the months. Each will have the names of the officers listed alphabetically down column B, followed by their productivity numbers in the 5 categories for that month across the row. The list of officer names for each month will be identical. The 7th tab will be the officer activity tab, a 32 line printable summary page for each officer that shows their productivity in each of the 6 months, their totals, and their monthly averages. Problem 1: In the officer activity tab, I want the name of the first officer to appear in cell A10, and then each subsequent name to appear 32 lines down (A42, A74, A106, etc.). Is there a formula to output the names listed from column B in the first tab (April) to the proper cells in the officer activity tab? Problem 2: I used the TRANSPOSE function to get the monthly data for the first officer into the proper cells in the officer activity tab. (Data for Officer A came from April!C2:G2, May!C2:G2, etc.) I would like to copy the 32 line summary page for each officer. How can this be done so that the right data appears for the right officer? (Data for Officer B comes from April!C3:G3, May!C3:G3, etc.)

Need a macro to insert a row above a certain cell, keeping the formatting of the row above the inserted row

We need a way to calculate the overall scores by category for each candidate on the Applicant Overall Evaluation tab. The challenge here is that we will not know which row the candidate is on for each worksheet unless we do multiple VLookups. We then have to add these VLookups together for all of the applicable areas; however the formula will fail if one of the values is NULL. The sheets and columns that need to be added up are already in formulas in Row 3 of the Application Overall Evaluation worksheet. What we need to do is find a way to tell Excel which row the candidate is in for each worksheet to make sure we have data integrity.

Trying to conditional format a range of cells in a column based on a separate column that are in the equivalent row

I want to create a vba button to add a row on multiple sheets with a input box to chose where to insert

Hi - i'm looking at data that is exported where detail data is grouped under a "header", like this: Client A Address Account Number Ticker Price Value I need it to look like this Client A Address Account Number Ticker Price Value The row about the "Client A" row is the text "Client" Is there a way to clean up this type of file using the client row as an indicator of a change?

I have 1000s of these types of files so i'd like to be able to run a macro or something that will clean it up - separating based on changes in "Client" row.

I need the row highlighted in blue to be formulated like the others please

How do I lock a column or row and scroll through to the isle I locked?

hello trying to populate cells in a row regarding a person details based on that person populating these details in another sheet. In other words If name "XYZ" appears in Sheet 1, then populate in Sheet 2 the row where "XYZ" is with detail of "XYZ" in sheet 1