Select Data and show all the ocurrences

select data

 then

 show all the appear and his    follow  6 weeks

here the file
4n_up_down_to_week.xlsm
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?
 
Martin LissOlder than dirtCommented:
Try this.
29090223a.xlsm
1
 
Martin LissOlder than dirtCommented:
select data

 then

 show all the appear and his    follow  6 weeks
Sorry but I don't know what that means.
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

select an  number  ans show all the ocurrences

and  3 weeks before and 6 weeks after

sheet 2 have the sample
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Martin LissOlder than dirtCommented:
When you say "select an number" do you mean "double-click a number"? If so, what should be done differently than what is done doe?
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

Need have in sheet 2  

after the select number (appear in yellow)

6 weeks down and show the weeks as in  sample
0
 
Martin LissOlder than dirtCommented:
You didn't answer my question which was
When you say "select an number" do you mean "double-click a number"?
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

When you say "select an number" do you mean "double-click a number"?

yes !
0
 
Martin LissOlder than dirtCommented:
In the sample, what did you "select" and what was added to Sheet2 when you did?
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

i just try to show how i need be the sheet 2

in that sample  
but any number need work the same as is show
0
 
Martin LissOlder than dirtCommented:
Unless you can say something specific like "If I double click cell A1273 in sheet1, then the data in sheet1 from row 1200 to 1300 should appear in sheet2 starting in row 4" I can't be sure what you want.
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

if i double clik row A2002

need then be show all the occurrences for that number

and be show 6 weeks  3 weeks up and 6 weeks down

and show the weeks numbers too
0
 
Martin LissOlder than dirtCommented:
In the sample workbook, on Sheet2, why is the week below the selected number labeled as week 1?
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

need to know where  1 week is and where end
0
 
Martin LissOlder than dirtCommented:
That's not what I mean. Why is it W1 and not W4 since there are 3 weeks above it?
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

3 weeks need be before and 6 weeks need after
0
 
Martin LissOlder than dirtCommented:
That doesn't answer my question. Why does it say W1? It's the 4th week of data so why doesn't it say W4?
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
a1.PNG
0
 
Martin LissOlder than dirtCommented:
Again, that does not answer my question.
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
1aaa.PNG

week number are show at the final of the week because need to know where it end
0
 
Martin LissOlder than dirtCommented:
This shouldn't be this hard.

Please supply me with a workbook that shows what sheet 2 should look like, including all the week numbers you want to see, after A2002 is double-clicked.
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

here is
4n_up_down_to_week.xlsm
0
 
Martin LissOlder than dirtCommented:
In this workbook you'll find a worksheet named "Template" which I use to make the formatting of Sheet2 easier. You can hide the Template sheet if you want to.
29090223.xlsm
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

i need  6 weeks down
like i explain at the begining
0
 
Martin LissOlder than dirtCommented:
OK I can do that but when I asked you to do this

Please supply me with a workbook that shows what sheet 2 should look like, including all the week numbers you want to see, after A2002 is double-clicked.

you uploaded the 4n_up_down_to_week.xlsm workbook, and my code exactly reproduces what is in that workbook.
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

the workbook i upload have the  mechanic  to make 3 weeks  already  

all i need is add  3 weeks down

like i explian  

and the weeks numbers  like i show
0
 
Martin LissOlder than dirtCommented:
Please excuse the small size of the rows shown here, but is this what you want at the bottom?
2018-03-21_08-45-00.png
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

yes  

when select an number
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great Job !

very best Expert !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.