non contiguous cells

I have been asked to build a spread sheet to collect data. Sheet1 " collection form" this is where the use enters the data they are collecting. Sheet2 "Report" is where the data needs to be stored after collecting. Goal is to take the relevant data from non contiguous cells in sheet1...

I have a table that looks like this (see below). I want to put in a new column the value that says "Nombre:XXXXXX" until a new value of "Nombre:" is found and then drag that new value intul I have a new column with names repeated. I know some names roll over to other columns and would need to...

All of my named ranges refer to valid cell references, but the range Values come up as null (see Name Manager in photo). This causes the SUMIF function I wish to apply =SUMIF(RangeofID_Codes, ID_Code, RangeOfValues). I have tried evaluating the criteria against the source (budget codes on...

Is there a formula to find the max value from columns C,G,K,O,S and put the value into column W for the example below: C,G,K,O,S ARE THE Term columns FIRST ROW: 1122, 1125, 1112, 111,1107 ( I CANNOT GET THE COLUMNS TO LOOK RIGHT WHEN I PASTE THE EXAMPLE) C G...

Hi all, hope all is well. Im trying to: 1. Protect a sheet using VBA. (I got this to work) 2. Use a range created using VBA as "Range Unlocked by password when sheet is protected" (I'm not sure if this will work, maybe someone can provide comments) 3. Use VBA to create a range of non contiguous...

Hi, I have a worksheet with 35,136 rows of data. I want to calculate the average of every 4th cell in the same column. Is there a way to create a macro to select every 4th cell in the average formula? If so, can I then substitute min and max for average? Thanks.

Hi I am wondering if there is a way to take a non contiguous range of cells from sheet1 of my workbook and have them printed on every page? So if I want a1-a10 and g5-g10 to print on every page it will? Any help would be greatly appreciated.