PDA

View Full Version : Help with excel



nikmar
09-30-2006, 08:42 PM
I need help on how to write using excel and Visual basic with the following statement. if codes 97112,97052,97023 or 97234 is used in any combination with 97112 then code 59 will automatically be placed in this row. any help will be appreciated. Thanks in advance.:banghead:

Jacob Hilderbrand
09-30-2006, 10:23 PM
Can you explain a bit more on what you want to do, it is not clear to me. Can you provide an example?

nikmar
10-01-2006, 09:42 AM
if code 97112 is used in conjunction with let's say 97052, 97023, then a modifier 59 is placed in the appropriate spot to justify them being used together. This would apply to any combination like 97234 used with 97052 or 97023 etc, etc. I want the excel program to detect when these codes are being used in any combination and place the modified code 59 below them in the cell. If I knew how to write or set-up Visual Basic in excel to identify this, it would be a big help. Thanks

mdmackillop
10-01-2006, 10:33 AM
Hi Nikmar,
Your description is too vague. Can you post an example with your proposed layout. Use Manage Attachments in the Go Advanced section.