Find Jobs
Hire Freelancers

adjust macro to perform same action -but over more columns

$30-250 NZD

Terminado
Publicado hace más de 12 años

$30-250 NZD

Pagado a la entrega
The MAX I expect to pay for this is $50. Hi. I have a macro (See attached). It currently takes a spreadsheet with 4 columns (see [login to view URL]) and makes some changes. Basically those changes have to do with adjusting the first two columns to "match" the second two columns in terms of dates (actually not exactly "matching" as you can see if you run it). The change I want is so that the second two columns can be expanded to any number of columns (say n) and have it do the same thing to all the columns from colunm4 to columnN. More specifically: column1 has a date and column2 has a number associated with that date column3 has a date and column4 has a price associated with that data. the macro aligns column3 (and moves the entries in column4 along with the entries in column3) so that basically the date in column1 precedes the date in column3 by 1 day (not exactly but that is the basic idea.) It does this without disturbing the relationship between the data in column3 and column4 and also without disturbing the relationship between the data in columns1 and columns2. That is the current macro. What I want, is to have more columns after column4 but in the same way that the current macro does not disturb the relationship between columns3 and columns4, I want the new macro not to disturb the relationship between column3, column4, column5, .... , columnN. By the way, what I mean by "not disturb the relationship between two columns is that if in RowK the entries in column3 and column4 were originally xxx and yyy, then in the new (outputted sheet), whatever row has the xxx data in column3, will also have the yyy data in column4 (note it almost certainly will not now be RowK because row wise everything is being changed by the macro). Hope this is clear. The MAX I expect to pay for this is $50.
ID del proyecto: 1152768

Información sobre el proyecto

5 propuestas
Proyecto remoto
Activo hace 13 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
See PM please. Thanks, Svet.
$50 NZD en 1 día
5,0 (80 comentarios)
6,7
6,7
5 freelancers están ofertando un promedio de $46 NZD por este trabajo
Avatar del usuario
Hi, please see PM!
$40 NZD en 1 día
5,0 (31 comentarios)
4,9
4,9
Avatar del usuario
Hi, please check your PM. Thank you.
$50 NZD en 1 día
4,5 (26 comentarios)
4,4
4,4
Avatar del usuario
Hello, I can do this job.
$50 NZD en 2 días
0,0 (0 comentarios)
1,0
1,0
Avatar del usuario
I am an Excel and VB expert. I can do it quickly and perfectly ...
$40 NZD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de JAPAN
Beppu shi, Japan
4,9
56
Forma de pago verificada
Miembro desde ago 30, 2005

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos 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)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.