First of all, even using %% it would be possible for any user to "extrapolate" the hours worked for others!
I mean, if I know MY hours were 8 on a given day, and it shows 33.3%, then I know that anyone ELSE that shows 33.3% ALSO worked 8 hours! Now.. if what you wanted to do was to have separate sheets for each individual, you could have VBA determine the name of the user logged in, unprotect the workbook, unhide HIS sheet, then re-protect the workbook. Displaying data by user would be similar. Use VBA to unprotect the sheet, filter the data, then re-protect the sheet and NOT allow the use of filters. the sheets would be password protected along with the VBA project. paul ________________________________ From: MNM <mnaf...@gmail.com> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> Sent: Fri, July 23, 2010 9:57:12 AM Subject: $$Excel-Macros$$ Re: Auto Calculate Number to Percent All, thanks for all the reponses. That's what I was thinking that it was not possible without having 'base' numbers. Don't want to share data of hours worked between individuals so it possible to lockdown worksheets by individuals, with password per worksheet? On Jul 23, 7:08 am, Dave Bonallack <davebonall...@hotmail.com> wrote: > Hi, > > Have a look at the attached. > > Regards - Dave. > > > > > > > Date: Fri, 23 Jul 2010 14:51:00 +0530 > > Subject: Re: $$Excel-Macros$$ Auto Calculate Number to Percent > > From: sandymau...@gmail.com > > To: excel-macros@googlegroups.com > > > Hi Dave, > > > Please send the VBA solution for me. I can't get a logic which can > > solve this problem without saving "Hour Worked" values. The problem > > part with me is when a new value added to data it will not show the > > correct percentage value. The cause I already mentioned in previous > > reply. > > > If MNM need this with worksheet functions then he already have it. > > > So please send the VBA. > > > Thanks & Regards > > Sandeep > > > On Fri, Jul 23, 2010 at 10:43 AM, Dave Bonallack > > <davebonall...@hotmail.com> wrote: > > > Hi > > > This can't be done with worksheet functions without the use of another > > > column, because of circular referencing. > > > However, it can be done with macros, either automatically, or by button > > > click. > > > So, which would you prefer: Worksheet functions with extra column, or VBA? > > > Regards - Dave. > > > >> Date: Thu, 22 Jul 2010 18:42:53 -0700 > > >> Subject: $$Excel-Macros$$ Auto Calculate Number to Percent > > >> From: mnaf...@gmail.com > > >> To: excel-macros@googlegroups.com > > > >> Hi, > > > >> I am trying to figure out if there is a way to auto calculate number > > >> entered into a column to total percent. Example > > > >> Column A contains 'Date' > > >> Column B contains 'User' > > >> Column C contains 'Hours worked' > > > >> Based on the value in column B User 'XYZ' I should be able to convert > > >> hours worked into total percent > > > >> Date | User | Hours Worked > > >> 7/16 | ABC | 8 > > > >> This should self calculate and return on save > > >> 7/16 | ABC | 100% > > > >> Example 2 > > > >> Date | User | Hours Worked > > >> 7/16 | ABC | 8 > > >> 7/16 | ABC | 8 > > >> 7/16 | XYZ | 12 > > >> 7/17 | ABC | 8 > > > >> This should self calculate and return on save > > >> 7/16 | ABC | 33.3% > > >> 7/16 | ABC | 33.3% > > >> 7/16 | XYZ | 100% > > >> 7/17 | ABC | 33.3% > > > >> At the end the total should equal 100% by User > > > >> -- > > > >> >---------------------------------------------------------------------------------- > > > >> Some important links for excel users: > > >> 1. Follow us on TWITTER for tips tricks and links : > > >>http://twitter.com/exceldailytip > > >> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > >> 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > >> To post to this group, send email to excel-macros@googlegroups.com > > > >> <><><><><><><><><><><><><><><><><><><><><><> > > >> HELP US GROW !! > > > >> We reach over 7000 subscribers worldwide and receive many nice notes about > > >> the learning and support from the group.Let friends and co-workers know >they > > >> can subscribe to group at > > >>http://groups.google.com/group/excel-macros/subscribe > > > > ________________________________ > > > Find it on Domain.com.au Need a new place to live? > > > > -- > > > >---------------------------------------------------------------------------------- > > > > Some important links for excel users: > > > 1. Follow us on TWITTER for tips tricks and links : > > >http://twitter.com/exceldailytip > > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > <><><><><><><><><><><><><><><><><><><><><><> > > > HELP US GROW !! > > > > We reach over 7000 subscribers worldwide and receive many nice notes about > > > the learning and support from the group.Let friends and co-workers know >they > > > can subscribe to group at > > >http://groups.google.com/group/excel-macros/subscribe > > > -- > > >---------------------------------------------------------------------------------- > > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links >:http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > HELP US GROW !! > > > We reach over 7000 subscribers worldwide and receive many nice notes about >the learning and support from the group.Let friends and co-workers know they >can >subscribe to group athttp://groups.google.com/group/excel-macros/subscribe > > _________________________________________________________________ > New, Used, Demo, Dealer or Private? Find it at >CarPoint.com.auhttp://clk.atdmt.com/NMN/go/206222968/direct/01/ > > Book1.xls > 35KViewDownload- Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
