copy sheet from one workbook to another

[joh46k]

hi friends,

I have 2 workbooks .YC55(RANGE A1:D7245) and Book1(RANGE A1:9000) . In YC55 , I have one sheet with values. I need to automatically copy that sheet and paste into BOOK1.

Note: Every week yc55 is updated .

How to write VBA code for that !

[joh46k]

i should use record macro to find code or SQL . Which is better
?

[FDibbins]

Hi jon forum rules require you to wait 24 hours (1 day) before bumping

Having said that, you could probably write your own macro to do this, quite easily using the macro recorder.

Have everything ready, click the record button, go through all the sequence of steps as you normally would, stop the recorder when you are finished. Create a button, add the macro, and you'r done

[arlu1201]

Should the data from the sheet be copied or should the sheet be copied as a whole?

[joh46k]

Should the data from the sheet be copied or should the sheet be copied as a whole?

Data from the sheet be copied !!

[joh46k]

Bump no response

[FDibbins]

Did you even try my suggestion, or are you waiting for some-one to hand you the solution?

and did you even read my 1st post?

Hi jon forum rules require you to wait 24 hours (1 day) before bumping

[joh46k]

i tired but not satsfied with result. so now i waiting for some to hand me the solution !!

[arlu1201]

You can post whatever you tried here and we can help you edit it.