Search results

Hi All. I have been plying with Pivot tables and dashboard to present info from a flat excel spreadsheet. My question is, how can I access a data fields from a number of spreadsheets (via SharePoint, etc) At the moment i simply export data to a spreadsheet and create a pivot table, each time I...

Hi Chirayu. Please find attached sample xls file. I have a single data tab which records individual scores from User_form but I need to included/record Monthly scores and view in dashboard. (i.e Jan, Feb, Mar, etc) No date is used in this version, let me know if you have any questions. Mike

Hi All, I have been learning some excellent tricks and tips using excel from this forum (Thanks to all). I have a dashboard that captures and displays values (scores) against individuals into an array. This array is captured using a data_form and held in a 'single' Sheet (data) Unfortunatly I...

Hi Narayan/Bosco. Many thanks for your help, appreciated. The formula indicated worked.! I made a small change to the COUNTIF statement to allow for '0' values (">=0) as the above returned a #DIV/0! if all values = 0: =SUM(C39:R39)/COUNTIF(C39:R39,">=0")/6 Many thanks again. Mike

Hi All. I am struggling to understand which formula to use when try to calc total pecentage from a array. I have a list of 16 results (number values between 0-6) and wish to calc a total percentage for all 16 values.? (ignoring '0' values). example values: 1,3,5,3,5,6,2,6,2,1,0,6,4,3,5,6, I...

Excellent.!! Thanks Thangavel. Scrollbar link to dataset working, I wouldn't have spotted the typo/error in the named range. Much Appreciated.. Mike

Hi Thangravel, thanks for getting back to me, i have been pulling my hair off trying to fix the error in the 'Resident Dependency Report'. The problem appears to happen when you use the scrollbar. When you scroll through the names the Report below (Resident Dependency Report) should update the...

The report section is not working correctly and flagging errors. can you help...

Hi Belleke. Can you please let me know how to apply the userform to the dashboard report, I have tried but password/restrictions have been applied of the sheet. The report section is not working correctly and flagging errors. can you help... Thanks Mike ▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to...

Hi Belleke, Thanks for userform. The userform look good and I like the search option on the right, i didn't think of including this option. I see you created a new 'data' tab for the userform, how can I change the titles from the form (remove text 'KPI') and formatting (i.e. fonts size and...

Hi Belleke. I assume you mean Program Language :) As I am no programmer I will leave choice to you, VB, PHP, what ever works.. Regards Mike

Hi Thangavel / Belleke I have set Column C to = auto number, thanks, I didn't know of that option. :) The only Mandatory fields are Column C, Room Number (Number Value) & Column D, Name (Text Value). The record must have a room number and a name allocated to room. All other values are optional...

Hi, Yes, I hope to use a user-form to Add, Delete or Update the values in the Data Tab. Amy help appreciated.

Hi All, I am an intermediate excel user and have used this forum to create a number of simple dashboards and reports but, I would like to understand how to create input userforms which will allow to 'add', 'delete' and 'update' values. I am no VBA guru and am struggling to create a working...

Hi Narayan, many thanks for adding the two procedures allowing views to work, much appreciated. I can know see how this works and how to included in any future excel project. Thanks again...

Hi Chandoo and all here, I am a intermediate excel user and find this site invaluable, thanks to all. I have a question relating to linking 2 VLookup views on a sheet. Both Vlookup views use the same data, 1 VLookup uses a scroll and the other uses a picklist. Although both view work well as a...