Previous Topic Next Topic

Macros or vba for data validation

Closed
Johnzz Posts 2 Registration date Thursday January 22, 2015 Status Member Last seen January 22, 2015 - Jan 22, 2015 at 11:34 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 24, 2015 at 07:32 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..

1 reply

Answer 1 / 1
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Jan 24, 2015 at 07:32 AM
post a very small extract of sheet1 using
speedyshare.com

and give one set to be added.
0

Similar discussions

Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses
copy a row from one worksheet to another, based on criteria
wy -
vcoolio -

15 responses