Can This Macro for a command button be made to work in any book

Greetings,

I am hoping to change this code I am using in the following way,

Right now the code operates in the Book "1 INV EST JT TEMP 2016 INC"
It copies specific cells and deposits it into "2018 INC LDGR DPST ALLOC"
IT also inserts a new line in "2018 INC LDGR DPST ALLOC" and pushes the old data down the sheet.

I wish to be able to use this code in a command button in any book I choose to put it in without having to continuously modify the code.

The destination of the book("2018 INC LDGR DPST ALLOC") and sheet("WSBC LABOR PRODUCT TRACKER") would stay the same.

Only the name of the book it comes from would continuously differ.
The sheet ("Contract Job Tracker") where the information comes from would remain the same.




[/CODE]

Please Login or Register  to view this content.

I guess it needs this part of the code to be Generic.

[CODE]Call CLFILL("GENERIC BOOK NAME ??????", "2018 INC LDGR DPST ALLOC")

Any help would be appreciated

Yes that works, now how do i get that particular macro to follow it to a new folder when the book is saved with a new name?

and still work without editing the macro

OK so I input the macro into the actual sheet instead of a module.

This seemed to be the trick

thanks for your help