phoenix
phoenixPhoenix - Your AI Assistant
Inactive session will be ended in 24 hours
End Session

MS Excel 2016 VBA code MAPPING TABLE BETWEEN 2 values

  • Posted:
  • Proposals: 10
  • Remote
  • #2447589
  • Awarded
Ian C.Sanjoy D.Savita R.Harsha P.Ludovit H. + 5 others have already sent a proposal.
  • 9

Description

Experience Level: Entry
Hi looking for someone to help in a mapping table the procedure

1. A table provides the Values for accounts BETWEEN these two accounts, 1 account is generated

example: Account 1 and account 2, the mapping generates Account A (TARGET)

2. the mapping must provide the Account TARGET PLUS Description, so think there are 2 targets account A and the description of account A, and must adjust dynamically as the SOURCE account is changed or updated, and MUST be performance improved so we could have hundred of lines, so it must be manage as a object list or something light.

New Proposal

Login to your account and send a proposal now to get this project.

Log in

Clarification Board Ask a Question

  • Robert A.

    Marco,

    Happy to quote on this, but can you attach a simple example ,because I cannot understand your description of what you are asking for?
    1. Do you have a list of existing accounts?
    2. If there are ten accounts, are we adding a new one between every existing pair?
    3. What "descriptions" are we adding to each new Account?
    4. What is the "Source" account? And how must the new Account "adjust dynamically" if the source account is "changed or updated"? Does it change by the same percentage? Or the same value?
    4. What data will show whether an account has "improved performance"?

    Marco M.03 Jul 2019

    hi thanks

    Happy to quote on this, but can you attach a simple example ,because I cannot understand your description of what you are asking for?
    1. Do you have a list of existing accounts?
    like this
    1000000
    2000000
    3000000

    2. If there are ten accounts, are we adding a new one between every existing pair?

    no, any account based on range will be mapped to a new account
    so basically we are mapping 7 digit accunt to 5 digit account (PARENT) in a separate field.

    3. What "descriptions" are we adding to each new Account?
    account name
    1000000 Assets1
    2000000 Assets2
    3000000 Assets3
    4. What is the "Source" account?
    source account is the 7 digit account, transactional
    1000000 and we are identifiying th eparenst (5 digit account) with their descriptions

    And how must the new Account "adjust dynamically" if the source account is "changed or updated"?
    it is linked to a program interface, so the user selections will change the contents of the DATA table, so they change different company code, month, etc

    Does it change by the same percentage? Or the same value?
    changes by user selections
    4. What data will show whether an account has "improved performance"?
    it is just a mapping based on a between range, to a TARGET account, the mapping table stays the same, but the data range change.