Re: $$Excel-Macros$$ Need a code to update the non existing data

2014-04-27 Thread Ganesh N
Thanks Vaibhav!!! On Sun, Apr 27, 2014 at 3:07 PM, Vaibhav Joshi wrote: > Here goes file as per your need.. > > Cheers!! > > > On Sun, Apr 27, 2014 at 12:59 PM, Vaibhav Joshi wrote: > >> Hi >> >> Use this code instead, this is simple & easy: >> >> Sub dataupdate() >> Range("A2").Select >> Rang

Re: $$Excel-Macros$$ Need a code to update the non existing data

2014-04-27 Thread Vaibhav Joshi
Hi Use this code instead, this is simple & easy: Sub dataupdate() Range("A2").Select Range(ActiveCell.End(xlDown), Selection.End(xlToRight)).Select Selection.Copy Worksheets("Data update").Select Range("A100").End(xlUp).Offset(1, 0).Select ActiveCell.PasteSpecial Application.CutCopyMode = Fal

Re: $$Excel-Macros$$ Need a code to update the non existing data

2014-04-26 Thread Ganesh N
Hi Ravinder sir, The Prj code mostly will repeat (week on week the Prj code will be same only date and value will change) . So I need to check the date and respective prj code so it wont be duplicate. If I already updated for current week I need a msg else it should update. Can you please help me

Re: $$Excel-Macros$$ Need a code to update the non existing data

2014-04-26 Thread ravinder negi
hi, please visit below link for your solution, please advise if anything else required. http://excelvbasupport.com/forum/showthread.php?tid=15 Note I have checked only code number. On Sat, Apr 26, 2014 at 7:20 PM, Ganesh N wrote: > Hi Team, > > I need to update the data in second sheet. befor

Re: $$Excel-Macros$$ Need a code to update the non existing data

2014-04-26 Thread Ganesh N
Hi Team, Any update on my request ? Thanks & Regards, Ganesh N On Sun, Apr 27, 2014 at 7:50 AM, Ganesh N wrote: > Hi Team, > > I need to update the data in second sheet. before that i want to check the > data is already updated or not if already updated i need a msg else the > data needs to b

$$Excel-Macros$$ Need a code to update the non existing data

2014-04-26 Thread Ganesh N
Hi Team, I need to update the data in second sheet. before that i want to check the data is already updated or not if already updated i need a msg else the data needs to be update (I want to check the date and prj code, becoz week on week prj and date will change. so i dont want to make a duplicat