LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
praveen_khm
 
Posts: n/a
Default Problem with Subtotals


Hey all,

I need your help to complete a project of mine. I am making project
using Macros. I have least knowledge of VB Script. I am creating macros
by recording it. I have created subtotals for a worksheet. Now, I need
to copy only the titles and the numbers assigned to it. But when I copy
it and paste it, or even using paste special, Values, I get the complete
content but not the only required data. Ex. I select option 2 when
created subtotals. There, I get a list of all the variables with a +
mark next to it. If I copy the content and paste it else where, I get
all the details which appear when + is clicked. I need only the data in
there, i.e, only + contents to be copied and pasted. Please help. Quick
response is appreciated.
Thanks,
Pravi


--
praveen_khm
------------------------------------------------------------------------
praveen_khm's Profile: http://www.excelforum.com/member.php...o&userid=30364
View this thread: http://www.excelforum.com/showthread...hreadid=500182

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy an Drag cell Formula Problem Nat Excel Discussion (Misc queries) 1 June 20th 05 03:24 PM
problem office assistant R.VENKATARAMAN Excel Discussion (Misc queries) 0 June 15th 05 06:22 AM
Problem with nested subtotals, placing secondary subtotals BELOW . Dawn Cameron Excel Discussion (Misc queries) 1 June 3rd 05 10:13 PM
Freeze Pane problem in shared workbooks JM Excel Discussion (Misc queries) 1 February 1st 05 12:04 AM
multi-level subtotals are in the wrong position Worksheet Guru need Excel Worksheet Functions 1 December 6th 04 05:22 PM


All times are GMT +1. The time now is 09:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"