Hard code to break

NAVEXCEL

New Member
Joined
Feb 19, 2005
Messages
15
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
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Martin Perera

Board Regular
Joined
Jan 17, 2005
Messages
147
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

New Member
Joined
Feb 19, 2005
Messages
15
Martin thanks for your info. It would be great if you also provide a code for the same.

looking forward, Nav
 

Watch MrExcel Video

Forum statistics

Threads
1,122,481
Messages
5,596,393
Members
414,063
Latest member
N_Bates

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top