Hard code to break

[NAVEXCEL]

Hai All Excelians,

I am wondering for a solution. I have three worksheets namely "Anj", "Leo" & "Nav" in a workbook "ComplaintRegister". I have anther worksheet namely "Analysis-2" in another workbook "MIS-C".

Sheet "Analysis-2" have the main database. And the sheets in workbook "ComplainRegister" is where we punch data. All the three sheets have a unique field that is "Ticket No" and "Date".

We have to punch data on daily basis. My requirement is that every morning all the fresh data should go in the sheet "Analysis-2".

One way is to copy & paste manually. But it would be great if any code can be invented to move the things fast.

All help would be greatly appreciated.

Thanks,

Nav

 

[Martin Perera]

check out the Workbook_Open() and or Workbook_BeforeClose(Cancel As Boolean)

reference your copy n paste code in either of these and the data will be transfered automatically, as long as
1 both workbooks are open - could run code to open them from here also
2 macros are enabled.

HTH

martin

 

[NAVEXCEL]

Martin thanks for your info. It would be great if you also provide a code for the same.

looking forward, Nav