Dear Expert,
I need to put data auto on date of last i enter data in Stock sheet and graph sheet Table 12-Mar-18 column i use formula instead of references auto last cell data and month data is permanent i use reference....
Dear Expert,
I need to put data auto on date of last i enter data in Stock sheet and graph sheet Table 12-Mar-18 column i use formula instead of references auto last cell data and month data is permanent i use reference....
Thanks & Regards,
Navi_G
Please explain what you want. It's not clear from your very poor description or the attached file, which is not annotated in any way.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Dear Experts,
in sheet 2 i pick reference from sheet 1 i want to a formula instead of reference to pick
Knitting
Toe closing
Shifting
Wip Days
Total
data from sheet 1 to dnaymically update sheet 2....
Last edited by Navi_G; 06-09-2018 at 04:32 AM.
In B2
=INDEX('Mar-18'!$B$3:$M$33,MATCH(B$1,'Mar-18'!$A$3:$A$33,0),MATCH('Graph Data'!$A2,'Mar-18'!$B$2:$M$2,0))
in C2
=INDEX('Mar-18'!$B$3:$M$34,MATCH(TEXT(B$1,"mmm yyyy"),'Mar-18'!$A$3:$A$34,0),MATCH('Graph Data'!$A2,'Mar-18'!$B$2:$M$2,0))
copy both down
Thank Sir JohnTopley for sharing great information i m using offset function but it not work in Blank cells case but formula index match is truely dynamically....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks