Find Jobs
Hire Freelancers

Simple Excel project needed in 24 hours

$30-250 USD

Em Andamento
Publicado há mais de 11 anos

$30-250 USD

Pago na entrega
Program to match excel cells. First off this program MUST be completed within 24 hours. If you can't do it in that time frame do not bid. Also this is a very simple project, I know it and anyone with programming skills will know it. I am willing to pay $20 - $30 tops. If your bid is more than this then it is clear you did not read this and your bid will be ignored. I have an excel list with the same information in a cell that needs to be matched to contents of another cell. I am looking for a very simple program that will take an excel xlsx file and match the contents of a designated column cells to the contents of the cells in column “A”. The designated column needs to be able to be entered in by the user. Below is an example: Column A, Row 1 contains the following B0028QK6EY Column A, Row 2 contains the following B0028QK6EY Column A, Row 3 contains the following B0028QK6EY Column A, Row 4 contains the following B0028QK6EY Column A, Row 5 contains the following B0028QK6EY //Bold added for emphasize Column A, Row 6 contains the following B00292BLSC Column B, Row 1 contains the following B0028QK6EY Column B, Row 2 contains the following B00292BLSC Column B, Row 3 contains the following B00292BLSW Column B, Row 4 contains the following B00292BM68 Column B, Row 5 contains the following B00292BM7C As you can see Column B, Row 1 matches Column A, Row 1 – 5. Column B, Row 2 matches Column A, Row 6. What I am looking for is the contents of Column B, Row 1 to be inserted into the following rows 2 – 5, so that Column A and Column B match exactly. Once this happens Column B, Row 2 will become Column B, Row 6 and the process continues. Also the contents after the column will need to be extended so that all the data is kept in the correct fields. I am attaching some examples showing the before and after of what I am looking for. Start File Example – As you can see in the examples Column A has ASIN as the Column Header and in this case the comparison column is Column Z, ASIN1. Column A, Row 1 matches Column Z, Row 1. Moving onto Column A, Row 2, does not match Column Z, Row 2 but instead matches the contents from Column B, Row 1. Column A, contains the same contents in Row 1 – 9. So Column B should contain the same contents in rows 1 – 9. Also all the data in the columns past column Z should be carried down to match also. End File Example – First, very important, you can tell that nothing has been deleted but instead the contents of the cells in Column B – AK that do not match are simple shifted down and the space is filled in with the matching data. Also Column A, Row 40 is blank only for this example, in the actual file they will end at the same point on the sheet. As I said above this should be a simple program to write, as it seems like it will only take a comparison statement and a loop. Very simply put, the contents in the designated column, and columns past the designated column need to be moved down to match the contents in column A and the space created needs to be filled in with data from the matching column.
ID do Projeto: 4264583

Sobre o projeto

1 proposta
Projeto remoto
Ativo há 11 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
Hi, this is very simple. I've had a lot of Excel macro dev experience. I can do this within the hour, as soon as the milestone's been paid. Thanks for your consideration! Best, Yang
$30 USD em 0 dia
5,0 (1 avaliação)
2,0
2,0

Sobre o cliente

Bandeira do(a) UNITED STATES
costa mesa, United States
5,0
32
Método de pagamento verificado
Membro desde abr. 27, 2012

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.