hello guys,
i have a sheet named PE which is the main source of handling a contents in other sheet.
would you help me how to make a selected contents in PE sheet appears automatically according to weeks in sheet1?how do i use data validation, offset,or combo box to solve this problem?please show me some alternatives.any help are appreciated...
Okay.. On sheet "PE", can you have all data tables one below to other ?
After this it will be easy to use lookup / offset formulas to fetch the respective week's data
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
sure,it is. can you show me the way?
On sheet "PE", can you have all data tables one below to other ?
Regards,
DILIPandey
<click on below * if this helps>
rph(english).xlsxhere is the modified file.
Okay.. used offset function to achieve the desired results.. try changing week number and you'll see that data will be fetched as per week number on top
rph(english).xlsx
Regards,
DILIPandey
<click on below * if this helps>
thank you veru much,it solved!
cheers
please mark this thread as [SOLVED].. Thx
Regards,
DILIPandey
<click on below * if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks