Recent content by cyberx1

Hi. I tried above with a formula constant and everything looked ok but only first occurrence of sum worked then stopped.

After some quick trials, even the F5 function isn't gogin to help me with my problem - I'm just screwed at this point:(

Thank you very kindly, but I can't use your solution. Reason is code. I don't understand code nor will I be able to maintain the code given changes to the format and things like that. Guess I was looking for a function solution, whcih I do underdstand. I'm going to use some of your tips from...

Excellent. After reviewing your code, guess I wil just have to edit in the event of new column names, correct? Can functionality be put back on Rollup tab to repeat data cells so all records show as contiguous? Does Match formula in cell K34 on Sample1 tab necessary? Thank you again. Mark

Oh, just FYI that in PART 2, Yes means OK, No means Error found and documented in PART 3, and N/A just means N/A. Mark

Ooppss...revised attached. Mark

Works perfect now. Thnak you. DO you mind if I ask addtionjal question should I encounter any additonl issues as I contoinue to decvlop this modle? Thank you again. Mark in Plano, TX (20 degrees here now - yikes!) Thank you. I feel like a total idiot now :( After my initial post, I...

Seems Seems to work OK. But when I add another tab, I get a type mismatch error when running macro again. We're getting very close. Mark

After entering a test 3rd tab called Sample3, and including just the heading and no data, I got a type mismatch error when running the macro. It is possible that a tab cold have no data, but all tabs wil have headings. Mark

Oh, I see. Had to open macro window. Will this macro work if any if any tab has no record? Mark :)

Hi Narayan. Rollup tab shows no data on your posted file. Mark

Hi Somendra. I just did in Balli's post above. Mark :)

Thank you Kindly Balli. Pivot table looks nicer, but my real issue still remains...notice on the Rollup tab that rows 5-13 and 17-25 still contain zeros. What I am looking to do is have each record with active error data show contiguously. For example, rows 2-5, then rows 13-16 to show as...

Thnak you Balli. Close - but I'm trying to find a way to capture the errors with the zeroes. in other words, I want to only capture the actual numebr of types errors by the user on a given tab onto the rollup tab, and not capture the remaining cells with no values. For example, if Employee A...