copy cell data from worksheet to worksheet

hi

i like to now how to copy cell data from one worksheet to another.

the thing is, a am working on a function that copys multiple worksheets to one master, and saves all into one sheet.

the code to get and open thouse worksheets

Please Login or Register  to view this content.

i like to now how to insert a funktion to copy specifyed cells to master worksheet sheet .

i tryed varius codes for about a few houers but with no respons.

please help // Lizerd

This code will change the value of [workbook2]SheetB!$b$1:$b$2 to be the same as [workbook1]SheetA!$a$1:$a$2. This does values not formulas. (It acts like PasteSpecial Values rather than Paste.)

Please Login or Register  to view this content.