Originally Posted by
joeny0706
Paul_Hossler
First I want to say your macro is working perfect. It is allowing me to convert and upload the data until I have a better way.
I have a question I want to ask and see if you can help me with. I need column L contents to also copy to the credit. In row L is the rep for the customer. The credits do not include the rep.
So currently the macro searches out all the stores that have a credit on the same day as the invoice then copied the invoice number and put a 9 in front of it. If it is possible to also have the contents of column L copied to the credit that would be great.
If this is possible and you have time to help me out I would appreciate it.
Thank for the help.