use of grouped cells

I have aprox 700 groups of cells "I selected a set of cells and named them". these groups cover 3500 rows. There sizes very in the number of rows per group but, all have the same number of columns.

What I'm tring to do is create a summary sheet. I want to copy all groups that have meet a single criteria to another sheet. The criteria will always be in the same column. The criteria is part of a function and will change each time I import new data into my excel sheet. Am I even close by trying to group them like this? Does anyone have a idea?

Originally Posted by stevebriz

My first thought is...This is possible.Secondly ....how to do this best depends on you sheet layout and the selecton criteria
Maybe a cut down spread sheet with some comment sto explain where the serach criteria is and where in the groups you are looking for a match would help

Thank you Steve I'll post some first thing Tuesday. Have a great weekend.

Originally Posted by stevebriz

My first thought is...This is possible.Secondly ....how to do this best depends on you sheet layout and the selecton criteria
Maybe a cut down spread sheet with some comment sto explain where the serach criteria is and where in the groups you are looking for a match would help

This is my first try at attaching a file. Plese let me know if it comes out correctly as I didn't see a way to attach the file as a Excel sheet so I attached them as .txt files.

summary test1.txt

summary test2.txt

Originally Posted by stevebriz

Can you zip the xls and post it please?

New Compressed (zipped) Folder.zip
I HOPE THIS WORKED
FIRST TIME TRYING THIS.

[QUOTE=stevebriz]try this:

[CODE]Sub Check_n_Copy()
Dim RW As Long
Dim RowJLastrw As Long
Dim LastRow As Long
' this macro will not copy a range unless it has a named range and has '*in the j column


stevebriz,

I placed the macro into my file, and it did nothing. I had a copy of the cut down version that I posted so I added it into that one and it worked great. ???
I'm kinda at a loss. The only thing that I'm seeing different is that the one that I posted for you; When I go to run it the macro is called "sheet1.Check_n_Copy" while in the full version when I go to run it it's called "Check_n_Copy". I don't have any idea where the prefex "sheet1." is coming from or why it is adding it to the one but not the other. If you have a moment could you give me some advice here. I have worked with functions alot but the code thing is really really new to me.

Originally Posted by stevebriz

I am not sure what exactly is causing this but I suggest you need to copy the code directly from the forum into the workbook.

If you still have issues ( and you cna email the Workbook) you can email at steve_briz and that is hotmail address. ( so at hotmail.com)( just don't want to type the whole address or I will be killed by spam)

I found my problem. I had deleted some of the sheets on the file I posted as they made the file so big otherwise. So the sheet that is named sheet1 was not the first in order. I went in and rearranged the sheets actual locations at the bottom of the screen so that they were in order to what I had posted and it worked like a champ. I sure do thank you.

Please Login or Register  to view this content.

then it will only use sheet names ( sheet1 and sheet2)

Sorry for the mistake..and hassle it caused you.[/QUOTE]

AHHH so that's how that works. Not a problem, you were much help. I never thought dumping some of the sheets was going to mean anything, but like I said I know zip about code.

Thanks again