Need macro code

Closed
Johnzz
Posts
2
Registration date
Thursday January 22, 2015
Status
Member
Last seen
January 22, 2015
- Jan 22, 2015 at 02:43 AM
Hi,

I have a data in sheet1 with ID, name ,area, amount,January amt,February amt.....(below month column particular dates are mentioned)

Anybody please help me for data modification, whenever i want to enter the data with for particular id with date and amout, i have to scroll down search for name and column..

I need a table in sheet2 with ID,name month data,amt..if i Edit/add in sheet 2, it should modify in sheet1..

can anybody suggest me on this...
Appreciated if given help, with macros for anyother way.



Thanks..