Excel - Move Cell Values

£10-25 GBP

Completed

Posted

over 6 years ago

£10-25 GBP

Paid on delivery

I'm using Excel. I have a sheet with values in non contiguous columns. I would like a macro or formula (if possible?) that would move the contents of the selected cells into the two cells to the left of the selected cells. On the attached sheet you can see that there are cells with numeric values in adjacent cells. These values can be under different columns. Some rows may not have a value. I would like an automated way to move the values from their current cell to the columns B and C on the same row. So if, for example, there are values in cells 2F and 2G, they get moved to 2B and 2C. If there are values in cells 8L an 8M they get moved to 8B and 8C. Other sheets may have a different number of columns to select from so a hard coded solution wouldnt work.

Project ID: 15403794

About the project

27 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@Taisho

Hello, I will send You a formula for placing data in these 2 columns. Macro is not needed and this formula is very flexible and relatively simple (NOT an array formula). I can send at once. Regards Relevant Skills and Experience I'm a full-time VBA developer and Excel specialist. In this case macro would be an overkill. Proposed Milestones £17 GBP - Excel formula added to example file + explanation

£17 GBP in 0 day

5.0

(66 reviews)

5.3

27 freelancers are bidding on average £19 GBP for this job

@ParisPallas

Hi there - My name is Paris. I can develop a smart code function that will recognize the number of columns in the active sheet and will move the cells' values to B and C columns accordingly. Relevant Skills and Experience I am an Excel expert for about a decade. The delivered code will be very flexible to handle any number of columns. I can deliver today if awarded. Proposed Milestones £20 GBP - You have tested and approved the file that I will have sent to you. When can we chat or talk? I am online from 3 to 11 pm (GMT+3).

£20 GBP in 1 day

5.0

(677 reviews)

8.7

@Khurramz

Hi, What's the maximum columns can go to? I can offer you both a macro or a formula. Relevant Skills and Experience Excel Proposed Milestones £25 GBP - Macro/Formula

£25 GBP in 1 day

5.0

(417 reviews)

7.9

@elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Habilidades y experiencia relevante VBA/Formulas Htos propuestos £21 GBP - final delivery

£21 GBP in 1 day

5.0

(345 reviews)

7.5

@bilalmaher053

hi, i understand what you want, can you send me chat so i send you sample??? Stay tuned, I'm still working on this proposal.

£10 GBP in 1 day

4.9

(299 reviews)

7.2

@RPaul73

Hi, Have the solution ready. Please get in touch and I can deliver it instantly. Regards. Relevant Skills and Experience Excel, Data Processing Proposed Milestones £10 GBP - Final

£10 GBP in 0 day

5.0

(36 reviews)

6.8

@avinav606lx

Hey There, I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Aman

£44 GBP in 1 day

4.9

(181 reviews)

6.6

@narsim3128

With respect to this project I would like to present myself as a candidate for your consideration. I have successfully completed few projects which involved Excel macros. Relevant Skills and Experience Excel (Advanced) VBA Proposed Milestones £23 GBP - This task will be completed within schedule

£23 GBP in 1 day

4.9

(75 reviews)

6.1

@zu02

Hi, I'll do it or via formulas, or macros or user form etc quickly. Relevant Skills and Experience I’m a ms Access/Excel/VB programmer from 97 year Proposed Milestones £25 GBP - default

£25 GBP in 10 days

4.8

(55 reviews)

6.2

@sorinacho88

Hello, I can create a macro function (this will work as a custom formula) to move the values from any columns to B and C (or other columns if needed) Please open a chat with me if you are interested Relevant Skills and Experience Excel VBA Attention to details Free support for the template for 6 months Proposed Milestones £21 GBP - Full payment only after you are happy with the result. Nothing upfront

£21 GBP in 10 days

5.0

(78 reviews)

5.8

@rahulrahangdale

I have more than 11 years of extensive experience in all areas of data entry, data mining, data extraction, blog posting, mailing list development. Relevant Skills and Experience I am expert in Data Entry work with 52 WPM of keystroke speed with exception interpersonal communication, management and marketing skills. Proposed Milestones £21 GBP - Let's start

£21 GBP in 1 day

5.0

(30 reviews)

5.2

@MerpDataS

I CAN move it to Columns B & C. But, I CANNOT move it to Columns 2B & 2C respectively. Please let me know if I meet your expectations. Thank you. Relevant Skills and Experience Basic Excel Skills Proposed Milestones £10 GBP - On Completion

£10 GBP in 2 days

5.0

(36 reviews)

4.6

@huongth

Hi. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now Relevant Skills and Experience I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle Proposed Milestones £13 GBP - complete

£13 GBP in 1 day

4.5

(20 reviews)

4.0

@nidhi1509

A proposal has not yet been provided

£18 GBP in 2 days

5.0

(6 reviews)

3.7

@gulzarhussain

I've gone through your description and attached file. I'll develop a macro which will do the trick and for that i want you to assign me this task. I am New Freelancer but know how to get things done. Relevant Skills and Experience Excel VBA. Excel. Data Entry. Typing. Proposed Milestones £15 GBP - Full Project Completion

£15 GBP in 1 day

5.0

(8 reviews)

3.7

@shakerhany

READY , I read the project description carefully, and your requirements, and checked the attached sheet, and I can confirm I've done something very similar to this very recent. Relevant Skills and Experience I am also ready to complete a demo before you award me the project, so you can make sure I understood the requirements. and ready for the job . Proposed Milestones £23 GBP - For the project requirements.

£23 GBP in 0 day

5.0

(13 reviews)

3.8

@ReneRondon

Hello. I bid for this project because I'm an Chartered Accountant with lot of experience in MS Excel and VBA programming (macros) Habilidades y experiencia relevante I guarantee you an accurate job, full functionality and fast delivery, all this in exchange of a fair rate that is perfectly adjusted to your budget. Htos propuestos £21 GBP - Programming an Excel macro

£21 GBP in 1 day

4.8

(25 reviews)

3.5

@samerbadee

Hello, I think it's not a big deal as it may appear. But I have one question: The two values to be moved, will be always in adjacent cells? Relevant Skills and Experience I'm an excel expert for over 15 years with VBA skills. Drop me a message to explore more details. Proposed Milestones £21 GBP - Excel

£21 GBP in 3 days

5.0

(4 reviews)

3.3

@Devotion20

Hello I have created macro. How this macro works: It'll find last filled cell in each row & cut it & paste to Col C of same row. then cut value from adjacent cell to last filled cell & paste to Col B Relevant Skills and Experience Experienced in various data entry task. Proposed Milestones £10 GBP - Create Macro

£10 GBP in 1 day

5.0

(7 reviews)

3.5

@samerjoseph

sir , I've been working on Excel for years , i can do some formula for this task , i just got some questions about it if you can chat with me may be things will be clear Relevant Skills and Experience I'm a software developer with a strong background in MS Office application in general and Excel in particular , try me out and you won't regret

£18 GBP in 1 day