Copying Same Cells of all the sheets to another workbook

[Bikash Shaw]

I have a workbook of 500 party details.
i want to copy the 7th Row of all the sheets to a another Sheet.

can anyone please help me out with this.
i am very new to macros and VBA.

Please help me out

Thank You for u support in advance.

Regards
Bikash

[patel45]

I have a workbook of 500 party details.
i want to copy the 7th Row of all the sheets to a another Sheet.

another Sheet or another workbook as title says ?

[Sean Thomas]

to copy row 7 of each sheet to the next row of a new sheet in a new workbook

Please Login or Register  to view this content.

[Bikash Shaw]

Thanks a lot for ur reply Mr. Sean,

As the cell contains formulas i want to copy only the values
how can it be done.

Please revert

[Sean Thomas]

try this

Please Login or Register  to view this content.