Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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=500170 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtotals
If I understand correctly you want to copy only the visible cells and paste
them? Assuming that to be the case Select the area you wanted to copy as usual. Hit F5 - Special - Visible Cells Only. Copy and then paste. You can record a macro while doing this and it should be fine... -- HTH... Jim Thomlinson "praveen_khm" wrote: 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=500170 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotals problem: Excel 2003 (not, AFAIK, the nested subtotals bug) | Excel Discussion (Misc queries) | |||
Original subtotals should not be within nested subtotals in excel | Excel Worksheet Functions | |||
Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) |