LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,836
Default Use loop to filter, copy/paste to new sheet; run through entire li

How can I filter all items on a sheet named 'Summary Sheet' in Column C, then
run a macro?

I already have the macro, which calculates unique items on Row 3; will just
call it here.

Finally, copy paste the results from the filtered list and Row 3, to a sheet
named €˜Rep Summary, skip a row for the next copy/paste procedure, then loop
back to the beginning and do it again until I have done this for every item
in the list? This seems to be harder than I initially thought...

Thanks,
Ryan---


--
RyGuy
 
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
Loop thru sheets copy and then paste in other sheet LuisE Excel Programming 2 August 7th 08 07:28 PM
If Font.ColorIndex = 3, Copy Entire Row and Paste to New Sheet ryguy7272 Excel Programming 3 November 2nd 07 06:45 PM
Need macro to filter, create tab on filter and copy/paste Jen[_11_] Excel Programming 1 May 2nd 06 04:45 PM
Filter and copy entire row yami-s Excel Programming 2 February 17th 04 10:26 PM
Macro - copy entire row and paste at bottom of another sheet miker1999 Excel Programming 4 January 31st 04 05:28 PM


All times are GMT +1. The time now is 01:43 AM.

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"