See Below

Zac

Well-known Member
Joined
Feb 20, 2002
Messages
796
I have Data from B2:R500.
In Col Q is my Salesman Code (026, 029, etc).

I've sorted the SSheet by Salesman Code, then by Customer, then by Inv#.
I've then used a Data Filter to only show the 026 Sales Code. My intent is to Cut the 026 data from B2:B40 and paste it to another Sheet in the Workbook. I did this by going to B2 and hit CTRL + Shift + END (which hi-lites the lines I need).
However when I do so, it copies over all 500 lines rather that the 39-40 I need.
Is there a way around this?
Recording the MAcro will be easy if I can get by this snag.

Should I even be using the Data Filter?
I thought maybe I could somehow look in Col Q and where the data ends for SAlesman 026, insert a blank line. Then when I use CTRL + SHIFT + End from B2, the Cut and Paste would be easy. However, I don't know how to accomplish this either.

I can then do the same for the other Salesman.

Need someones help or Suggestions.

Thanks,
Zac
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Instead of using try using

Advance filter

It will give you the option where to post your data.. criterial etc.

in advance filter you select the range as per your need only.

ni****h desai
http://www.pexcel.com
 
Upvote 0
On 2002-04-18 06:26, Zac wrote:
I have Data from B2:R500.
In Col Q is my Salesman Code (026, 029, etc).

I've sorted the SSheet by Salesman Code, then by Customer, then by Inv#.
I've then used a Data Filter to only show the 026 Sales Code. My intent is to Cut the 026 data from B2:B40 and paste it to another Sheet in the Workbook. I did this by going to B2 and hit CTRL + Shift + END (which hi-lites the lines I need).
However when I do so, it copies over all 500 lines rather that the 39-40 I need.
Is there a way around this?
Recording the MAcro will be easy if I can get by this snag.

Should I even be using the Data Filter?
I thought maybe I could somehow look in Col Q and where the data ends for SAlesman 026, insert a blank line. Then when I use CTRL + SHIFT + End from B2, the Cut and Paste would be easy. However, I don't know how to accomplish this either.

I can then do the same for the other Salesman.

Need someones help or Suggestions.

Thanks,
Zac

Once you've displayed the filtered rows, go to EDIT/GO TO.../SPECIAL and select VISBLE CELLS ONLY
then your operation wuill only copy the filtered rows instead of the whole sheet.

Hope this is what you're after?
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,144
Members
448,552
Latest member
WORKINGWITHNOLEADER

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top