Can you please share sample file with VBA? Fairly new to VBA side. Thanks
On Jul 23, 10:15 am, Paul Schreiner <schreiner_p...@att.net> wrote: > 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 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 -- ---------------------------------------------------------------------------------- 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
