Detected the Data which in my condition and copy it to another sheet

[pedjvak]

Dear all
I have a big database that contain about 25000 rows and 250 columns
now as I show you manulally : in my sample file (that attached) I want that in each row where I have >0 then copy the name of row and related data to another sheet with head of each item
if you open my file I show you manually that I want do it by a code or macro or . . . automaticly
thanks in advansed

[Leith Ross]

Hello pedjvak,

Not sure if the output of the attached workbook is what you want but it is a starting point. A new sheet has been added for the output. There is button at the top of the new sheet to run the macro. the macro is written for the data in this workbook. If you plan to use the macro in your other workbook, the macro will need to be updated. The statement that determines the last column of the data will need to be changed from "BM" to "IP, assuming 250 columns.

The macro will take some time to complete when run on a workbook 25000 rows by 250 columns. For my computer, I estimated about 23 minutes.

Please Login or Register  to view this content.