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
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