council

Dear all I am having trouble trying to put together a macro. In Sheet1, I have my data table. I put a simplified version below: <tbody> Gender Breed City Council Microchip Number Status M Dog Council A 1030999876287540 Adopted F Dog Council C 4425588004585700 F Cat Council B...

I am combining data in several columns into one single column using this formula: =OFFSET($F$2:$F$509,MOD(ROW()-ROW(ColumnData1),ROWS($F$2:$F$509)),TRUNC((ROW()-ROW(ColumnData1))/ROWS($F$2:$F$509),0),1,1) Then I'm using this formula to ignore blank and zero cells, round the number and only look...

I have a report that is based upon a query where I'm getting the dreaded #Type ! error. All the query in the report shows up as it should but when I go to the report (which is comprised of 3 fields in the detail) I get this error in two of them. In the header row, I have State Council Positions...

I have a sheet that I need to send to a client each month - they require each person as seen in column F (Adam , Alaco) in a new tab in the same spreadsheet (there are numerous names in the one sheet) - so in the example below all the data for Adam will go into one sheet, all the data for Alaco...