Macros or vba for data validation [Closed]

Report
Posts
2
Registration date
Thursday January 22, 2015
Status
Member
Last seen
January 22, 2015
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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..

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
790
post a very small extract of sheet1 using
speedyshare.com

and give one set to be added.