purchase order error

hi guys

i have a problem in that this purchase order works perfectly except for one very small thing i cant get my head round

it prints as it should , it saves as it should but

when the macro runs it also transfers certain cell data to sheet 2
there is not a problem if i enter a job number ie j2345 but not all purchase orders are assigned a j number
this is in cell g23:h24

if i stick to j numbers it transfers fine but if i put the word sttock into it , it causes problems on sheet 2 and i dont understand why.
if any one understands why i would appreciate it

hi roy thanks for the reply

thats the save destination
and it saves where i want it to

but the problem i have is if i put the word stock in to that cell

it causes the transfer to sheet 2 to go awry

try it with 2 or 3 normal ones ie j2345
then check sheet 2 you will see they list

then try putting the word stock in and you will see the problem

hi roy
i have to admit i have been dependant on the code

the save to a specific folder code was made by one person
and the transfer data to sheet 2 was another person

it only causes a problem when i enter stock into the cell and want it to transfer to the second sheet

the save to a specific folder is fine

its the transfer to 2nd sheet thats aproblem

bump bump bump
anyone please