<div>
It is hard to understand your description on the sheet.<br />
Would you please just populate the rows (after removing the comments from there) as per your logic and then explain the logic behind each row you populated on the sheet?
</div>


<div>
Are you wanting this to happen as a user enters data into the sheet changing those cells or as one of run over it or button someone presses?<br />
<br />
Cell checks or amendments are easy enough - I'm using phone at moment so bit looked at your sheet but can be as simple as<br />
<br />
if range (&quot;A1&quot;).value=range (&quot;A2&quot;).value then range (&quot;B1&quot;)=range (&quot;A1&quot;).value<br />
<br />
etc. &nbsp;you could trigger the VBA when a specific cell or range of cells is changed or being run by button, sheet being saved or whatever us required.<br />
<br />
Will look back when on Pc later.<br />
<br />
Steve
</div>


<div>
Hi Subodh<br />
<br />
I have attempted to illustrate a little better. I hope it makes sense. Thanks<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/08_w36/1114238/sample-data-for-experts-exc.xlsx" target="_blank" class="file-inline" title="sample-data-for-experts-exc.xlsx (12 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>sample-data-for-experts-exc.xlsx</a>
</div>


sample-data-for-experts-exc.xlsx

<div>
Hi Steve<br />
<br />
The data will be extracted from another source and pasted into the spreadsheet. The VB would then be executed to run through the spreadsheet and produce the desired results.<br />
<br />
Thanks
</div>


sample-data-for-experts-exc.xlsm

<div>
Subodh<br />
<br />
That's perfect thank you so much. You scored a hole in one.
</div>


<div>
You're welcome Diane! Glad to help.
</div>


<div>
This was very fast and very helpful
</div>


<div>
<div class="content wysiwyg-content">
I originally posted this as an Excel formula request to see if there was a clever way round without vb, but I don't think it's possible. VBA seems my best bet.<br />
<br />
I want to change the contents of a cell depending upon a comparison test, this basically what I am wanting to achieve<br />
<br />
if a2=b3 then make j2=g3 otherwise do nothing.<br />
<br />
I will actually have a series of these to check (see my attached file). This &nbsp;spreadsheet details what I want to ultimately achieve, but just the above element of it would be a tremendous help<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/08_w35/1113656/sample-data-for-experts-exc.xlsx" target="_blank" class="file-inline" title="Excel spreadsheet showing my data and a little more detail of requirement (28 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>sample-data-for-experts-exc.xlsx</a>
</div>
</div>


Excel spreadsheet showing my data and a little more detail of requirement

I originally posted this as an Excel formula request to see if there was a clever way round without vb, but I don't think it's possible. VBA seems my best bet.

I want to change the contents of a cell depending upon a comparison test, this basically what I am wanting to achieve

if a2=b3 then make j2=g3 otherwise do nothing.

I will actually have a series of these to check (see my attached file). This  spreadsheet details what I want to ultimately achieve, but just the above element of it would be a tremendous help

Excel VB to change the value of a cell dependent upon the value of another

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.