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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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
Martin LissOlder than dirtCommented:
Try this.
29090223a.xlsm
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great Job !

very best Expert !
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.