Insert Value according to month and date value

beneesetas

New member
Joined
Mar 7, 2014
Messages
1
Reaction score
0
Points
0
I doing a program in manpower statitics report

I need to insert data from one sheet to another sheet according to date and month

attach sample copy of file this thread

in first sheet ( front page ) i have

Month :
Date :
SAPL :
AJC

in second sheet ( day ) i have calendar of year 2014 with a column for sapl and ajc

when i am adding value in first sheet in sapl and ajc column, this value need to insert on each corresponding columns of second sheet according to its
Month and Date

Example

Month : March
Date : 3
SAPL : 35
AJC : 199


when i edit this value in first sheet,its need to be insert in second sheet according to the month and date ,
like this i need to fill values in each cell in second sheet according to date n month



thanks
 

Attachments

  • Manpower1.xlsm
    20.6 KB · Views: 6
Back
Top