HI Guys
i struggling here so looking for help
I have a spreadsheet called ORDER STATUS, that contains data from A2 though to AH10000
What i am trying to achieve is to simply print all Rows that contain a certain order number (Column A) and then print only the columns
A, B, C
E
FG
I
K (and only if K = In progress)
M
I can do this using filters and hiding columns but im looking for some VB code to simply enter the Value of A (say 13270) and it will print the columns as shown above
Anyone have a solution to do this?
thanks in advance
Adrian
i struggling here so looking for help
I have a spreadsheet called ORDER STATUS, that contains data from A2 though to AH10000
What i am trying to achieve is to simply print all Rows that contain a certain order number (Column A) and then print only the columns
A, B, C
E
FG
I
K (and only if K = In progress)
M
I can do this using filters and hiding columns but im looking for some VB code to simply enter the Value of A (say 13270) and it will print the columns as shown above
Anyone have a solution to do this?
thanks in advance
Adrian