IGNORE >>.
In my workbook, I have 6 Excel sheets each with nearly 1,200 rows &
>> nearly 15 columns, all with similar first 10 column headers.
>>
>> Data in every sheet is unique by virtue of different formulas. Have
>> removed all formulas hence the number in cells is long. Lets say, you
>> click a cell showing 19.00, its actually 18.99565456 but rounded up to
>> 2 d.p.
>>
>> First how do i "chop off"-truncate- these other numbers in Excel, to,
>> lets say, rounded up to only 19.00 when I click the cell again.
>>
>> ALL am interested in after filtering/programming is: the 3rd column
>> header (C) that meets these stringent (whole number & .50) conditions
>> in all these 6 sheets.
>>
>> Is Excel (Pivot table) or Excel VBA better or an App is appropriate. I
>> prefer a simple app. because what I do is repetitive - every 30 mins.
>>
>> Regards.
>> Wesley
In my workbook, I have 6 Excel sheets each with nearly 1,200 rows &
>> nearly 15 columns, all with similar first 10 column headers.
>>
>> Data in every sheet is unique by virtue of different formulas. Have
>> removed all formulas hence the number in cells is long. Lets say, you
>> click a cell showing 19.00, its actually 18.99565456 but rounded up to
>> 2 d.p.
>>
>> First how do i "chop off"-truncate- these other numbers in Excel, to,
>> lets say, rounded up to only 19.00 when I click the cell again.
>>
>> ALL am interested in after filtering/programming is: the 3rd column
>> header (C) that meets these stringent (whole number & .50) conditions
>> in all these 6 sheets.
>>
>> Is Excel (Pivot table) or Excel VBA better or an App is appropriate. I
>> prefer a simple app. because what I do is repetitive - every 30 mins.
>>
>> Regards.
>> Wesley