VB Macro Sheets

Job ID: 33977630

Budget: $10 – $30 USD

Here are instructions for a new sheet i would like to work on. please let me know if you have any questions.

1. Delete column C
2. Insert a blank column between columns A & B
3. Copy column A and paste into column B
4. Now we have two identical datasets in column A & B
5. Insert a blank row in row 1
6. Name the columns as follows:
A = DATE
B = NOTES
C = IN
D = OUT
E = DESCRIPTION
7. In column C cut all negative numbers and paste into the same row in column D but paste as a positive number (strip out the minus character)
8. Output filename “Wells Fargo Output Data.csv”
9. The converter file name should be “Wells Fargo Master.xlsx”
Related categories: Excel VBA