RE: Excel Formula/VBA code to update Account number based on signage acc. to mapping key

Hi All,

I would need your dearest help to get an excel formula or VBA for the logic as mentioned below:

1) I have an sheet named "Pivot" which contains item details along with its amount related to sales data. For easy understanding i have highlighted in yellow color where i need the help for below mentioned points:

Default logic for mapping key for account (40,50):

607412-40
4016000- 50

Based on signage account number needs to be swapped. Detailed explanation below:

1) I have an sheet named "Pivot" which contains item details along with its amount related to sales data. What i exactly need is - Excel formula to be updated for the logic-> Wherever negative sign is available in the sum of total amount column, account number need to be changed accordingly. (example – if amt is negative, account number "4016000" should be under “account 40” and acc num "607412" should be “Account 50” column)

2)If the amount value is positive in sum of total amount column, then the mapping key needs to be change vise versa ( if amt is Positive, account number "607412" should be under “account 40” and acc num "4016000" should be “Account 50” column)