I need to have the ability to load a .CSV file I receive and have it automatically have the following done to it:
If Column B and F are the same Column E would be False, if not True
Column C is always False
Column M is always <Cash Basis>
Column N is the number of lines that contain same number in Column L
Column O counts down the lines that contain same number in Column L
Column S is always 4010
Column V needs to be made into negative number
Column Y counts down the lines set of same numbers in Column L
---
Sample CSV
[login to view URL] [login to view URL]