selcect data 3nbase TbY

ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?
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:
I'll do this tomorrow unless someone else gets to it first.
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

can be an enter date  (may be an text box or combo box)
then show the years required ??
0
Martin LissOlder than dirtCommented:
Did you see the change I made in the previous question? I added code that colors the results in a yellow to green gradient so that it looks like this.
2018-03-28_06-14-42.pngShould I do the same here?
1
The Ultimate Tool Kit for Technolgy Solution Provi

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 for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Martin LissOlder than dirtCommented:
This will work no matter how many years there are or how many different counts there are,
29091526.xlsb
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin


is great an  job
 

  need an little adjustment
because i have an situation  

sorry if i did not explain good or better




I have 2 total columns history ( they belongs from different  columns )

because

one for NUM ( Column C ) and  one for ORD ( column BN)


need have both with the top 15


then I have by year column for NUM  (column E)  and for ORD (column BP)


we make the first 2 history all



( ID: 42514199    29091493.xlsb     history all for NUM)

and for ORD in

(ID: 42514001   29091457.xlsb)


need keep that as it was because they are all history not by year

then in this question I need goes by year  


please let me knows if i explian good   I do not want to confuse you
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

ID: 42514725
Should I do the same here?

yes ! that's what i need
0
Martin LissOlder than dirtCommented:
Sorry, but I don't understand.

If you want me to change the ORD_HIST_YEARS sheet then I need to see a picture of what you want. I only need for you to show me the headings and 1 row of data.

If you want me to change the HIST_ALL_YEARS sheet then I need to see a picture of what you want. I only need for you to show me the headings and 1 row of data.
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

ok let me show  something

this file is good until here
29091519_3nbase_num_byyear_.xlsb
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
x1x1x1.PNG

1z1z1a1a.PNG

this explain sheet HIST_ALL_YEARS  (not  ORD_HIST_YEARS)
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
then

ORD_HIST_YEARS   sheet now


qqqqqq.PNG

rrrrrrr.PNG
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

i show the 2 history by years i need to be show
they are not by year


by year need be make separete section because used other columns for get the data
is not the same column count
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

Please let me knows
if i explain good by now

I do not want to confuse
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

the by all years columns  count

are diferents to the all history count column

that's why i do first the all years for NUM and ORD

then  the specific  years  (example 2012, 2013, 2014)
have to be done in others sheet or section
0
Martin LissOlder than dirtCommented:
Do you agree that the ORD_HIST_YEARS sheet is correct in the workbook I posted above?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin


o you agree that the ORD_HIST_YEARS sheet is correct in the workbook I posted above?

yes! im agree


with this
this needed and is great

ooooooooooooooooooooooooooo.PNG
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

this also is great and needed

this what i need

s1111.PNG
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

but this is out  

and is needed too!

x1x1x1.PNG
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

then need have the History all years  NUM  and count  in an different sheet
0
Martin LissOlder than dirtCommented:
Now you've confused me. Earlier you said that the first set of columns on HIST_ALL_YEARS should be for all years, but now you show a picture where that's not true and you say "this what i need". Which is it, "ALL YEARS", "2012", "2013", etc. or just "2012", "2013", etc.?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

ok

let me review step by step please!


 don't want confused  you


1-we create  HIST_ALL_YEARS  sheet  from column C  The count)  and column L ( The NUM)

 HIST_ALL_YEARS will count how many times NUM is count in column C

this is what we did  and that ok i need have this

dd111.PNG

now  this last file you did answer my question here  because is year by year is good


but the History ALL for NUM is out

then i asking to keep the original HISTORI as it was and put the year by year in another sheet

because they are needed
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
need create

this in his own sheet   can be call NUM_by_YEARS
0
Martin LissOlder than dirtCommented:
Why do you need two sheets? Isn't this good enough?
2018-03-28_14-22-57.png
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

i need what you show  in ID: 42515499

thats what i need

the file you upload to me
don't have the HISTORY ALL NUM

this what i have WHY??

zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz.PNG
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
ggggggggggggggggggggggggggggg.png
0
Martin LissOlder than dirtCommented:
So you want this part (in red) in it's own sheet?
2018-03-28_14-22-57.png
0
Martin LissOlder than dirtCommented:
What does "don't show the same as you show me" mean?????
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
tttttttttttttttttttttttttttttttttttt.PNG
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

So you want this part (in red) in it's own sheet?

not is ok to me be in the same sheet  

but the file i download dont show  as your pic
0
Martin LissOlder than dirtCommented:
I know that the file that I uploaded doesn't have the "ALL YEARS" column. I was only asking if that is what you wanted?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin



I know that the file that I uploaded doesn't have the "ALL YEARS" column. I was only asking if that is what you wanted?


yes !
0
Martin LissOlder than dirtCommented:
So when I asked you
Why do you need two sheets? Isn't this good enough?
and showed the picture with the "ALL YEARS" column, it looks like your answer could have simply been "Yes". Correct?
0
Martin LissOlder than dirtCommented:
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 !
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
VBA

From novice to tech pro — start learning today.