Hi,
I have excel file that contain 8 sheets,
in each sheet there is cell that contains "serial number" (cell B)
i need a vba , that will be able to go through all the sheets, and search for the specific serial number and copy the whole row to new sheet according to that serial number
after it copy the first row from the first sheet it should move to the next sheet look for that same number and copy it to the end of the same row from the first sheet. and so on and on till it finish all the 8 sheets and i get at the 9 th sheet the values in one long row
(i know its not good for vba, but maybe it will give more clear view to understand what i need- i have it in ny mind as : if at sheet1 cell B contain 1 copy the whole row to 9th sheet, row 1, then if sheet2 cell b contain 1, copy it to the end of row 1 at sheet 9 and so on..)
then i need it to go automaticly from serial number 1 to 1,000,000
if anyone have idea how i might do that please help.
I have excel file that contain 8 sheets,
in each sheet there is cell that contains "serial number" (cell B)
i need a vba , that will be able to go through all the sheets, and search for the specific serial number and copy the whole row to new sheet according to that serial number
after it copy the first row from the first sheet it should move to the next sheet look for that same number and copy it to the end of the same row from the first sheet. and so on and on till it finish all the 8 sheets and i get at the 9 th sheet the values in one long row
(i know its not good for vba, but maybe it will give more clear view to understand what i need- i have it in ny mind as : if at sheet1 cell B contain 1 copy the whole row to 9th sheet, row 1, then if sheet2 cell b contain 1, copy it to the end of row 1 at sheet 9 and so on..)
then i need it to go automaticly from serial number 1 to 1,000,000
if anyone have idea how i might do that please help.