Hey Hillary Can you show an example of what you want in tustee sheet & also highligh the same with yellow color.
Thanks On Fri, Aug 2, 2013 at 5:10 PM, Hilary Lomotey <resp...@gmail.com> wrote: > Hello Experts, > > In the attached file, i have created two database, FIS and Equities > Database, and based on the database i can generate reports or statements > for each database (FIS and EQS). However the trustees require the statement > in a certain format so based on the statement for each of the two database, > i have been able to use macro recording to generate that report partially > and i need ur assistance to conclude the last part of it. Now the issue is > in the trustee sheet > > The report requires the FIS statement to be generated first and > categorized by investment type-(that has been done) > Then followed by the equities statement (that has also been done) > > the issue is to dynamically sum the equities total capital gains & market > values and use that total to compute the % of equities to total . > > This is how the sheet works, 1st select the client statemnt for the FIS > and generate report and go to the trustee sheet and click on complete > report (ie after you have also selected statement for same client in the > EQS. > > kINDLY HELP WITH MACRO TO SUM THE EQUTIES TOTAL > , > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
