Copying the range of rows between two strings...please help

**shrimic** · 02-13-2012, 01:15 PM

Hi Friends,

Can you please guide me on how I can copy a range of rows between two strings occurring in ColumnA. Say between A1= Workstations and A10= Machines?
Many Thanks...

**Bob Phillips** · 02-13-2012, 01:22 PM

If you know it is a1 and A10, then just

Please Login or Register  to view this content.

**shrimic** · 02-13-2012, 01:49 PM

Thanks Bob,
but I have a code which will search for the instances at which these strings occur...so it cannot always be A1 and A10 cells..it can be any...
I am looking for a function which will help me to copy the row based on a cell value

**Bob Phillips** · 02-13-2012, 02:56 PM

Please Login or Register  to view this content.

**shrimic** · 02-13-2012, 03:46 PM

Thank you very much Bob. But I need a bit more guidance from you.
My problem explanation is:
I have to match the column A values(IMP_Plad_BF3 etc.) in Worksheet 'a' with Column A values in Worksheet 'b'. Once a match is found I have to look for a String "WS Group Totals:" in column B of Worksheet 'a'. Once the string is found I have to copy the entire range of rows from column A match to Column B match and paste it in a separate Worksheet "c".. I have written the code which is throwing up error. Can you please solve the error for me..thanks...I have also attached the original Workbook for your reference...

Please Login or Register  to view this content.

**Bob Phillips** · 02-13-2012, 04:21 PM

Please Login or Register  to view this content.

**shrimic** · 02-13-2012, 04:31 PM

Thank you very much Bob. As per my requirement if I run the macro it should copy only the rows A28 to A34 and A35 to A41...which are the blocks for the values Column A of WkSht'a' matches with that of Column A of WkSht'b'...but it is copying some other rows as well...can you please help me with that...Thank man...