button to show week Pattern
in the DDWEEK sheet
button to show all weeks up to TODAY'S
week would be added. as the pattern shown
example
34W2017 B
35W2017 A
35W2017 B
follows
36W2017 A
36W2017 B
date_follow_to.xlsx
button to show all weeks up to TODAY'S
week would be added. as the pattern shown
example
34W2017 B
35W2017 A
35W2017 B
follows
36W2017 A
36W2017 B
date_follow_to.xlsx
Martin Liss
I need more information about what you need.
Nevermind, I think I understand.
ASKER
Martin
When click the button the weeks 1 to 52 should be added.
by years
a great way could be enter or select the year
then it create the pattern
When click the button the weeks 1 to 52 should be added.
by years
a great way could be enter or select the year
then it create the pattern
ASKER
when i say the pattern i mean
in this case this way
34W2017 B
35W2017 A
35W2017 B
follows
36W2017 A
36W2017 B
this file have some sample data but
the data should be create with the button itself
in this case this way
34W2017 B
35W2017 A
35W2017 B
follows
36W2017 A
36W2017 B
this file have some sample data but
the data should be create with the button itself
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Try this.
29120762.xlsm
29120762.xlsm
In my workbook you don't need to choose the year.
ASKER
Superior work.
Great Expert !
Great Expert !
Glad it worked as desired. Thanks for the feedback.
I'm sorry but I don't understand. In your question you said "button to show all weeks up to TODAY'S" which since today's week is 40 that you wanted to add rows to the existing data up to 40 and then stopping there. Nerraj's code doesn't do that. It always replaces the data with a completely new years worth of data.
Lo siento pero no entiendo En su pregunta, dijo "botón para mostrar todas las semanas hasta HOY", que desde la semana de hoy es 40, usted quiso agregar filas a los datos existentes hasta 40 y luego detenerse allí. El código de Nerraj no hace eso. Siempre reemplaza los datos con un valor de años completamente nuevo.
Lo siento pero no entiendo En su pregunta, dijo "botón para mostrar todas las semanas hasta HOY", que desde la semana de hoy es 40, usted quiso agregar filas a los datos existentes hasta 40 y luego detenerse allí. El código de Nerraj no hace eso. Siempre reemplaza los datos con un valor de años completamente nuevo.
The workbook that I attached had a problem if you already had a full year of data and this corrects that.
29120762a.xlsm
29120762a.xlsm
ASKER
Martin
Great JOb
i explain here
Great JOb
i explain here
Well I didn't notice that change from your original question, but please be aware that in Neeraj's code if you already have a full year of 2018 weeks and you say the year you want is 2019, the existing weeks will be replaced by 2019 weeks rather than adding 2019 weeks to the existing data.
No noté el cambio en su pregunta original, pero tenga en cuenta que en el código de Neeraj, si ya tiene un año completo de 2018 semanas y dice que el año que quiere es 2019, las semanas existentes se reemplazarán por 2019 semanas en lugar de que agregar 2019 semanas a los datos existentes.
No noté el cambio en su pregunta original, pero tenga en cuenta que en el código de Neeraj, si ya tiene un año completo de 2018 semanas y dice que el año que quiere es 2019, las semanas existentes se reemplazarán por 2019 semanas en lugar de que agregar 2019 semanas a los datos existentes.