Jump to content
Macro Express Forums

eddoria

Members
  • Posts

    4
  • Joined

  • Last visited

Everything posted by eddoria

  1. Ok thanks. I will give it a go. However I am still now sure what T54 is. How does this get populated. Sorry for being thick.
  2. Thanks heaps for the response. We are processing a csv file. I will give it a go. My concern is that I need to compare the order number half way through the loop. I dont want to go back to the very beginning. It is when I get to variable T4 that I need to compare T3 with the new line before it is processed. My situation is that I am loading up information against an order number. This can have a few items in it. So currently I am doing a record for each order number and each item. So that for a customer we could have 7 individual printouts where I would like to have only 1. So to enable me to do this, I need to set if the next line in the csv file is the same order number as the one I am currently processing. If it is then I need to add another item. If it is not, then continue and create a new record. Hope this makes sense. Will your suggestion cater for that? Regards Vera
  3. Thanks very much for the response. I am not sure how to use your code though. Sorry but very new to this. My code is to process the csv with the following steps (but not all would take too long): 1) Tab to the Customer No T1 2) Tab to the rest of the fields to be filled out T2-T3 3) Open up the new screen 4) Enter in the order number T4 5) Tab to the Item T5 6) Tab to the Quantity T6 7) Down Arrow one row 8) Hit OK twice 9) Place Order 10) Add another order At this point I need to see if the order number placed in T4 is the same in the next line which will be processed after step 10. If it is the same I need to only do steps 5-7 for each new item on the same order. Once the order number is different then continue on with step 8 to 10 and start all over again. I am not sure about how to use your code (sorry again). Will not it always be T4 no matter what line it is? They do not increment in each line? Regards Vera Hawkins
  4. Hi there, first time poster in this forum. I have written a macro to allow uploading from a csv file which is working fine. However there are instances where we have the same order numbers so I want a different set of instructions to run. What I need to happen is: Compare order number for each line to be uploaded. If the next instance is the same as the one before, then do some instructions if it is not the same do another set. How is this possible? Any help would be greatly appreciated. Edd
×
×
  • Create New...