URGENT HELP

  • Thread starter Thread starter jacqui
  • Start date Start date
J

jacqui

I have posted the following message numerous times to this
site but without reply. Can anyone please help with the
following on subtotals, my code is completely dependent on
this working and I'm unable to resolve it myself.
Basically, I need to subtotal on 5 different fields in my
source file. The routine works fine on up to 3 groupbys
but thereafter it seems like I've hit on a maximum with
the showlevel buttons. I use these to apply formats
using .styles to various totals.
I've tried breaking this into two parts by subtotalling on
2 of the fields first, then the remaining 3 but it's messy
in that I'm losing my formatting I've applied to the
subtotals on the original sweep. Does anyone have any
suggestions or would be kind enough to have a look at the
file for me. Your urgent help would be very much
appreciated.
Many thanks
Jacqui
 
Hi
probably you received no answer as your problem is not that clear. Try
the following:
- post your (relevant) code. Difficult to help without knowing this
- Give us some example data of what you're trying to achieve (plain
text - no attachments please)
- Show us - based on your example data - your expected result

To be honest based on your current description I do not know what
you're trying to achieve (and maybe i'm not the only one).

P.S.: Also stating something as 'urgent' won't help either :-)
 
Frank

Thanks for your reply. I take on board your comments but
in all fairness I have posted my code to the site before
regarding this question and again with no reply. I guess
it would be easier to send an example although it's
difficult to send this as plain text because of the
volumes of data involved. I feel it would be far easier
to attach a sheet with the underlying code which would
also help demonstrate what I'm trying to achieve as well.
ie I could send a before and after type example.
Are you still able to help?
Many thanks
Jacqui
 
Hi
yes still willing to help :-)
Though I open files send to me I won't open files with macros included.
sou you may mail me your sheet but make sure, macros are not included.
You may send me the code as plain text file.

Just describe your problem with as much detail as possible
 
Frank

Thank you for your reply and offer of help. How do I pick
up your full email address, part of it is cut from my
screen, I was going to send you an example of my source
file without any code. Would you like me to post the VBA
to this site or copy/paste it as text to my attachment.
Sorry I'm not very techno with things like this.
Thanks
Jacqui
 
Back
Top