Extract Data to next worksheet

Hi

I have large data in the format of sample file attached.

I want to copy the same to next work sheet. Sample data and expected result attached.

Wherever the "Name" coming in Column, next row to that (Highlighted for Yellow) to be copied to next work sheet.
With below the row of "Category" to next cell.



Please help to create VBA for this.

Hi jolivanes

thanks, i want to take specific rows only to next work sheet. example Wherever the "Name" coming in Column, next row to that. and additionally need to include down row cell reference also. hence seeking VBA for this.

After you changed your sheet as suggested in Post #2, this will do what you need.
Change references if and where required.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I updated the hyperlinks in Post #2. You can access them now and fix your workbook if you want.

Hello Jolivanes

Code is working fine. Thanks for your help

Hello Jindon

Thanks the code is working fine and getting the results.

I was shared you the example data

Is it possible to specify the condition of Wherever the "Name" coming in Column, next row to that to be copied ? Seems its currently taking from row4th

Originally Posted by KKR1975

Is it possible to specify the condition of Wherever the "Name" coming in Column, next row to that to be copied ? Seems its currently taking from row4th

I don't understand what you are trying to say.

If other code is working, you can stick with it.

Hello Jindon

Sorry may be my English is poor. Requesting you to add the condition of searching "Name" in column C then copy the data.

Are you saying the column reference of "Name" changes?
Not always in col.C?

Or it is always in col.C?

Hello Jolivanes

The sample workbook which i given is perfectly working, even if i add some more data on the same format. But when i apply this code to my original data, its getting copied only first row to results worksheet.

Test workbook the data starting from row c3. Actual workbook its starting from N14. I changed this on the below line, but i am getting only first row in result. can you please help is there any other line of code also i need to change?

Please Login or Register  to view this content.

I have changed as below

Please Login or Register  to view this content.

Hi Jindon

Its always C but the text "name" will change in actual workbook.
So when i apply this code in actual workbook wants to change that.

thanks

My code doesn't care about the text "Name" at all.

If it is in col.C and the first row of each block of data and the data always begins from Col.B (Col.A needs to be balnk) as your attachment, it should work even if "Name" doesn't appear anywhere.

Hi Jindon

Now i understand. need one help, if the column is "N" instead "C" and data starts from "I" instead B

what changes i need to do on your code. Please help for this

Actually i was in the mind the code will search and provide the results but the way you are doing also good only

Re: Test workbook the data starting from row c3. Actual workbook its starting from N14
If the only change is the Column, you also need to change the 3 to the Column number of Column N.

Please Login or Register  to view this content.

But in your attachment your data is in Columns B to Column N.
Where is it in your actual Workbook.
Make a Workbook with ACTUAL layout and attach it.

Hi Jolivanes

I have attached the actual layout. I have modified the below and tested. i am getting results correctly for one line item others are not coming.


F

Please Login or Register  to view this content.

Results i am getting is attached

Please Login or Register  to view this content.

This works on your attachment.

Thanks jolivanes. Perfectly working on my actual layout now.

Thanks Jindon for the help. its worked for me.

Thanks for letting us know and good luck.