Trying to add a change to a VBA marco

[justinwb]

Good afternoon

this post is relating to another post
https://www.excelforum.com/excel-for...-best-way.html Which has since been closed 01-26-2018
as we where able to get a sheet working

I have been using this sheet for the passed month and now 3 different departments now use it and its working great
I have tried to read and learn from the VBA not having much luck


The problem I am finding is I would like to add 1 column on the Pick order sheet
I am trying to add Delivery Name From picking Column M to the Pick order Column G
and not having much luck I can see I'm missing some thing in the code just cant work out which bit it is

I changed the lines of code that I could work out

Please Login or Register  to view this content.

Which added Delivery Name

Then I looked at the arr and added arr(i, 13) to both which caused the sheet to debug

Please Login or Register  to view this content.

then after rereading

changed

Please Login or Register  to view this content.

This still leaves the new column Blank but does not debug the sheet any more

I have tried to play around with other parts of the code and everything I have tried places it in to a debug state

I have attached the excel sheet from the other Post also

Any help would be great
JustinwB

[oluapseyer]

Add this..

Cells(n, 7) = w(ii)(3)

Below

Please Login or Register  to view this content.

[justinwb]

Good afternoon oluapseyer

you are the best works great and run a test on another sheet

After added the new line of code I cant work out how it finds the information

I can see Cells(n, 7) is the 7th column but I cant work out how = w(ii)(3) finds the column M

Thanks for your help
JustinwB

[oluapseyer]

Because of this code...

Please Login or Register  to view this content.

the "w" array were passed by 4 values => arr(i, 1), arr(i, 6), arr(i, 7), arr(i, 13)
Where
w(0) = arr(i, 1)
w(1) = arr(i, 6)
w(2) = arr(i, 7)
and w(3) = arr(i, 13)

[justinwb]

Thanks oluapseyer

Kind of understand the code a bit more
was just missing that last line of the array

6 months of using excel and learning something new every week
Thanks again for all your help

[oluapseyer]

you're welcome