Excel Macro/VBA for fill blank cells based on condition

In Progress Posted 3 years ago Paid on delivery
In Progress Paid on delivery

I would like a macro or VBA which would fill blank cells with value either from above or below based on a condition . For any blank cell, find a nonblank cell above or below with a matching value in column A and take that cell's value. The pseudo code will be something like

for each blankcell:

find nonblank above

if [login to view URL] == [login to view URL]:

blankcell == nonblank

else find nonblank below

if [login to view URL] == [login to view URL]:

blankcell == nonblank

else do nothing

Please see attachment for example. Looking forward to your bids

Excel Visual Basic Visual Basic for Apps Data Processing Software Architecture

Project ID: #25893573

About the project

15 proposals Remote project Active 3 years ago

15 freelancers are bidding on average $79 for this job

P0L

Hello, I am an Excel VBA expert and I would like to help you with your macro. Please check my profile and contact me to discuss further details. Regards.

$50 USD in 1 day
(493 Reviews)
8.0
bilalmaher053

Hi, i understand what u want, can we discus more in PM? i will start work right now, thanks.............

$80 USD in 2 days
(285 Reviews)
7.1
fabest

*** Dear, I AM EXPERT EXCEL / ACCESS DATABASES *** I think it is much more relevant to develop your tool in MS Access Can I show you some sample ? I will focus on user friendly interface. As you can see I have very g More

$80 USD in 3 days
(76 Reviews)
7.2
writingapp

Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within 1 day

$60 USD in 1 day
(220 Reviews)
6.6
AnowarRatul

Dear Sir, I have read your project details and reviewed your attachment carefully. I can make the VBA Program to fill the blank rows based on conditions with 100% accuracy absolutely as you want. I am an Excel Formula More

$49 USD in 1 day
(363 Reviews)
6.7
gokulanand

Hello I understand your requirement. I can get this task done in excel macro on a simple button click. I can start right away and get it done in the next 1 to 2 hours. Please let me know if you are interested. Than More

$30 USD in 1 day
(151 Reviews)
6.5
pranjalk2902

Hi, I'm Pranjal from Mumbai, India! I had a look at the picture and can build a macro in Excel VBA that can for each blank cell search for non blank cells above and below with matching value in Col A using for a 'for More

$30 USD in 1 day
(39 Reviews)
5.4
maks52andr

Hi, I'm a Excel/VBA expert with a lot of experience in Exce/VBA. If you want, I can do it immediately. I will wait for your positive response. Best Regards.

$30 USD in 1 day
(9 Reviews)
5.2
arunkumar9896

Hi, I will make Visual Basic code to fill blank cells based on condition. I have gone through the description and can do this using vba macro.

$45 USD in 1 day
(14 Reviews)
3.8
Manishnsingh

Hi there, I have recently completed a project relavent to this, in which I have to create API calculator. I think I am suitable match for your task and provides you a quality output with 100% accuracy. I am having more More

$200 USD in 1 day
(16 Reviews)
2.5
Hadi0850

Professional Summary Accomplished and energetic Sr. Data Executive with history of achievement in research analysis. Motivated leader with strong organizational and prioritization abilities. Areas of expertise include More

$140 USD in 7 days
(0 Reviews)
0.0
Shashiholik97

I am Expert of Data Entry excel work. I will do it professionally. i have done many work of excel work and Data Entry work.

$120 USD in 6 days
(0 Reviews)
0.0
AliRaza1200

I m here To provide Best possible solution to my client. Relevant Skills and Experience Hi, I am Ali Raza a Professional Data Scraping having 2 years of experience in this field. I'll scrape data from any website. Da More

$156 USD in 3 days
(0 Reviews)
0.0