We help IT Professionals succeed at work.

adjust 3N to 2N range

adjust this 3n file to work with 2N



Full Pair week (column D to G)  and mid pair week (column H to K)

rigth now  it create the range for an 3N  but not for 2N

need be adjust to work  with 2N




SOURCE CODE
2n_adjust_R.xlsm
2N_as_SOURCE-CODE.xlsm
Comment
Watch Question

Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:

No workbook attached. I need two of them...

  • The workbook you want changed
  • Any workbook that contains the 2N numbers


rigth now  it create the range for an 4N  but not for 3N

need be adjust to work  with 3N.


Don't you mean...

right now  it create the range for an 3N  but not for 2N

need be adjust to work  with 2N

ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Don't you mean...

right now  it create the range for an 3N  but not for 2N

need be adjust to work  with 2N


Martin you Rigth !!
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:

No, I'm right.

ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
you right!!
"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:

Try this.

29170473.xlsm


If you don't see an update for the 3N file by tomorrow night the remind me I need to correct a bug in that file.

ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
ok
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Great JoB ! Best Expert !