Hello friends
i am doing a program in manpower statistics report in excel,
I want to insert value according to date and month from another sheet using as front page.
i attached a file with this page, \
kindly help me to fix this issue,
Hello friends
i am doing a program in manpower statistics report in excel,
I want to insert value according to date and month from another sheet using as front page.
i attached a file with this page, \
kindly help me to fix this issue,
Hi beneesetas14, could you put in some sample data in the spreadsheet with expected result and some description?
_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved
Alvin
Do you need the values to stay in the 'Day' sheet?
Or each time you enters different data in 'Front Page' only 2 specific cells in 'Day' sheet that matches will show the values?
_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved
Alvin
thanks for your reply
i want to values need to stay in the cells corresponding to date and month
and when date and month change in front page, its need to add in daily manpower sheet on according to date n month of front page
example
if
month : march
date : 2
sapl :5
ajc : 10
this value to be insert to daily report manpower sheet to the cells of date : 2 & month : march and this value need to be fixed on this cell
and once if i change the
Month : april
date : 3
value need to be add on april and date : 3 on daily report sheet
on the place of SAPL and AJC
Re: Insert Value according to month and date value
thanks for your reply
i want to values need to stay in the cells corresponding to date and month
and when date and month change in front page, its need to add in daily manpower sheet on according to date n month of front page
example
Month : march
Date : 2
SAPL :35
AJC : 199
this value to be insert to Day sheet ( Daily Manpower ) to the cells of
Date : 2
Month : march
and this value need to be fixed on this cell
Once if Date and Month change like
Month : April
Date : 3
value need to be add on Day Sheet ( Daily Manpower ) to the cells of SAPL and AJC where
Month :April
Date : 3
to be add on this cell
Once the value added from front page sheet to day sheet, its should be fixed
thanks
Try in D10:
=INDEX(Day!$B$4:$Y$34,$D$7,MATCH($D$4,Day!$B$2:$Y$2,0)+(D$9="AJC"))
Copy to H10
Quang PT
Hi beneesetas14, Excel formula will not be able to accomplish your goal.
Would you consider using Excel macro, i.e. adding a button to your [Front Page] and once click will add the value to respective cells in sheet [Day]?
ps: what if existing cells [Day] already having values and you're entering new values on the same date, ignore?
_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved
Alvin
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
kindly help me with vba source code to fix this issue
thanks
hows this. i made a button
Manpower.xlsm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks