Search results

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...

But I think the view format is not the issue (or requirement) and you want to use this 'rollup' sheet data for pivot table. Are you not able to use this data format for Pivot table and hence you wanted to remove blank fields in 'rollup' sheet?

Hi. Yes, precisely.

Thank you. Each tab (with exception of rollup tab) stands for an employees's name. The actual file would have 80 different tabs, one for each empoyee, one rollup tab, and one pivot table tab based on the rollup tab. I like the light orange option. This would work, correct, if an employees...

-------------------------- Hi. Thank you all for your patience. Please notice on the sample file that each tab shows 12 cells down for the Error Reference Number and 12 cells down for the Error Description - this is what I meant by 24 cells - sorry for the confusion. In repsonse to above...

Oh, each tab can contain from 1 to 12 errors (average is about 2 or so). Also, actual tab is a word-like format, but cell references are made from the Rollup tab to form a single records for each tab (that is the intent anyways). Mark

Oh, sure. I hope the sample file is clear. Each tab represents a single record, but I'm a little lost on how to acount for the multiple error codes and error descriptions on the rollup tab, as I wish to keep all of the data as contiguous as possible so I can pivot the data and otherwise use...

I have an issue that I can't seem to resolve. I have a single workbook with 80 tabs containing a fill-in form. Each tab is filled in by a seperate user. I also have a linked rollup tab that has a row for each tab. Here is my challenge - currently there is a cell on each tab that has several...

Thank you for the reply. Unfortunately, I can't due to the nature of the material. Now on a regular Pivot Table without use of slicers gives one the exact numebr of records, however, when using slicers, and one selects a specific date, for example, more records are returned than are assinged...

I have a worksheet with many slicers and everything appears to work just fine, until...I try to drilldown on the total value for any record - I get all of the records for that ID - why is this as I ony want the number actions listed in the total cell, not ALL o fthe actions for that person? FYI...