Spreadsheet With Various Formulas To Automatically Work Out Certain Data Requirements

  • Posted:
  • Proposals: 4
  • Remote
  • #672455
  • Awarded
Simon P.
Stephen H.ExcelStudioWorks A.DEEPAK M. have already sent a proposal.
  • 0

Description

Experience Level: Entry
Estimated Job duration: 1 day or less
Description of excel work: I need a macro created that will do the following:

1 - Scan codes in column A & D. If there are codes that only appear in column D and not in A, then display the code in column J and the price of this (column E) in column K

2 - Scan codes in column A & D. If codes match and the price match, display code in column H (as it will be a match it can be either the supplier code or our code. If the code is matched, but the price is different, then please display the results in columns M, N and O

3 - I will require a button that can be pressed before i run these results that will remove any spaces from the characters entered into column A should it be required.

4 - I will require another button that will search column A and allocate any brackets. It will need to delete the brackets and also any text that is in the brackets.

Notes
the number if items to be entered into columns A and D could be in the thousands on occasion.

the results to be displayed should be numeric and to two decimal places, no currency should be shown. If the values entered into columns B or E are showing a currency then they should be converted automatically when i click to run the macro.
Extra notes:

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.