Discussion on:

Copy Excel subtotals without making a mess

I've been needing something like this for about a month now since my boss asked me to develop a report on product usage. I'm not a neophyte but I just couldn't find out where to accomplish this task. Thank you so much for saving me hours of work in the future as I generate these reports!

Ctrl/G is another quick way to pop-up the Go To dialog box

I completely appreciate this shortcut! I used it yesterday with great success....today however it is giving me an error saying it cannot use the data range because it is too complex. The things to try, per the error message, are actually being done. (selected in one contiguous rectangle, and data from the same sheet) Needless to say I'm having one of those moments with Excel. Any suggestions?