selcect data 3nbase TbY

I'll do this tomorrow unless someone else gets to it first.

Martin

can be an enter date  (may be an text box or combo box)
then show the years required ??

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.
Should I do the same here?

This will work no matter how many years there are or how many different counts there are,
29091526.xlsb

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

Martin

ID: 42514725

Should I do the same here?

yes ! that's what i need

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.

Martin

ok let me show  something

this file is good until here
29091519_3nbase_num_byyear_.xlsb

this explain sheet HIST_ALL_YEARS  (not  ORD_HIST_YEARS)

then

ORD_HIST_YEARS   sheet now

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

Martin

Please let me knows
if i explain good by now

I do not want to confuse

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

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

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

Martin

this also is great and needed

this what i need

Martin

but this is out  

and is needed too!

Martin

then need have the History all years  NUM  and count  in an different sheet

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.?

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



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

need create

this in his own sheet   can be call NUM_by_YEARS

Why do you need two sheets? Isn't this good enough?

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??

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

What does "don't show the same as you show me" mean?????

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

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?

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 !

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?

Great Job !
best expert !