Macro help in Excel

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

We have an excel spreadsheet for bulk data entry by external parties with conditional formatting within the spreadsheet that indicates if correct values have been added.

For the conditional formatting to work, the values need to be pasted values only.

We are having trouble with a macro that forces paste values only (so as not to over-ride the formatting that indicates a cell is correct).

Note: we have a macro that works fine in older windows versions of excel, however doesnt work in newer versions of Mac excel.

We need someone to write the macro script that will limit pasting to the spreadsheet to paste values.

DO NOT PITCH: if you dont have ready access to the version attached.

Spreadsheet attached with conditional formatting and current script in the VBA section.

Excel Excel Macros Excel VBA

Project ID: #14986669

About the project

45 proposals Remote project Active 6 years ago

45 freelancers are bidding on average $109 for this job

jaylancer43

Hello Sir, Thank you for this opportunity. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering More

$150 USD in 2 days
(779 Reviews)
8.6
sandroshubladze

Hi I am Excel Expert and VBA Developer I can help with your task easily If interested, contact me Thanks & Regards Relevant Skills and Experience Excel VBA Proposed Milestones $144 USD - Full

$144 USD in 1 day
(200 Reviews)
8.2
schoudhary1553

Greeting, i can deliver you the 100% results with in the timeliness. Please check the profile deliver almost 240 projects with 100% client satisfaction. Relevant Skills and Experience I have the 5 years of experienc More

$150 USD in 1 day
(355 Reviews)
8.0
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm still working on this proposal.

$150 USD in 3 days
(405 Reviews)
7.6
MohsanEijaz

I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Relevant Skills and Experience Excel Proposed Milestones $66 USD - vBa

$66 USD in 1 day
(92 Reviews)
6.4
narsim3128

With respect to this project I would like to present myself as a candidate for your consideration. I have more than 8 years of IT experience. I have successfully completed few projects for US clients Relevant Skills a More

$100 USD in 2 days
(51 Reviews)
5.8
osmemon

I have 7 years of experience in VBA and EXcel,,,, I can do your task very smoothly. See my profile for client reviews and portfolio to assess my performance before award. Relevant Skills and Experience Excel VBA 7 yea More

$155 USD in 1 day
(34 Reviews)
5.6
sonarkaushik

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have all the resources ready to do your project as per your requirement I am very much able to work on this. ***I am read More

$99 USD in 2 days
(43 Reviews)
5.6
furqanahmed55

Hello, I graduated from Boston University USA. I have a lot of experience with excel. I never miss work and always deliver on time. My personal qualities are: - Detail Oriented, as handled many sensitive con More

$250 USD in 1 day
(8 Reviews)
5.0
nelumindralal

Hi I went through your requirement and I feel that I can do this for you. please send me some sample job I will do that then if you satisfy please send me the correct job and I will do that thanks regards thus

$55 USD in 2 days
(27 Reviews)
4.5
AhmedHassan1122

I do this Perfectly

$66 USD in 3 days
(16 Reviews)
4.4
doctorkendrick20

Dear client I would like to do your project . Please consider working with me with everything done as required. If you have additional requirements, please talk to me. Best regards! Relevant Skills and Experience E More

$155 USD in 3 days
(14 Reviews)
4.5
shakerhany

Hi, I read the project description carefully, and checked the attachment, but I still have some questions if you dont mind, first the sheet attached doesn't include the macro. Relevant Skills and Experience If its pos More

$55 USD in 3 days
(13 Reviews)
3.2
prakash1317

I have done similar projects & confident to assist you. I'll take responsibility to complete the work accurately & on time. Relevant Skills and Experience I have done similar projects & confident to assist you. I'll t More

$70 USD in 3 days
(7 Reviews)
3.2
tuanthanhle

A proposal has not yet been provided

$55 USD in 1 day
(3 Reviews)
2.8
bondilimahesh

I have acquired very good excel VBA skills during the course of my work tenure. I can provide a very quick solution to the issue mentioned in the project. Looking forward to working on your project.

$132 USD in 2 days
(2 Reviews)
2.4
firozhossain606

Hi, I have the experience in working on different fields such as data entry, web research, web scrapping, product uploading, etc… Relevant Skills and Experience I am ready to do a free sample through which you can jud More

$30 USD in 1 day
(4 Reviews)
2.0
dnielkasza

I am highly proficient in using Excel as my full-time job requires it. Relevant Skills and Experience Expedite work efforts through development of VBA macros - Interpret high-volume data using statistical techniques, More

$30 USD in 3 days
(2 Reviews)
1.0
saiful56

I want to do this Relevant Skills and Experience excel Proposed Milestones $77 USD - that's it

$77 USD in 3 days
(2 Reviews)
0.6
parvejmp

hii Relevant Skills and Experience sgr Proposed Milestones $155 USD - demilestone

$155 USD in 3 days
(0 Reviews)
0.0