Create Specific Text down Column Based on Specific Text in Another Column

A

AlwaysLearning2018

Board Regular
Joined
Nov 23, 2018
Messages
51
Hi All,

I have created the below macro that will populate a value in 1 specific cell based on 1 specific cell in a different column. My question is how do I look at the entire column for that word and populate the other word down a different column Any help would be much appreciated!


Sub Comments()


If Worksheets(1).Range("D54").Value = "Variation Margin" Then
Worksheets(1).Range("I75").Value = "Futures Margin"

End If
End Sub
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Sort by date Sort by votes
try these codes
Code: 
Dim a As Integer
a = WorksheetFunction.Match("variation margin", Worksheet("sheet1").Range("D:D"), 0)
If a > 0 Then
Worksheet("sheet1").Range("I25") = "It exists in D" & a
End If
 
Upvote 0
Couple of typos in the code try
Code: 
Dim a As Integer
a = WorksheetFunction.Match("variation margin", Worksheet[COLOR=#ff0000]s[/COLOR]("sheet1").Range("D:D"), 0)
If a > 0 Then
Worksheet[COLOR=#ff0000]s[/COLOR]("sheet1").Range("I25") = "It exists in D" & a
End If
 
Upvote 0
In that case, please post you entire code showing which line is causing the problem & what is the error message?
 
Upvote 0
Hi Fluff,

Example of what I am attempting to do below.

If Range("C33").Value = "Variation Margin" Then
Range("F33").Value = "Futures Margin"

I'm not sure how to change this to get the code to read all instances of the specific word in Column C to return a certain word in Column F. The above works when I refer to 1 specific cell but if I say "C2:C800" For example I get a type mismatch. Excel Criteria below. Thanks!!

[TABLE="width: 341"]
<colgroup><col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"> <col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;"> <col width="97" style="width: 73pt; mso-width-source: userset; mso-width-alt: 3547;"> <col width="64" style="width: 48pt;" span="2"> <col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181;"> <tbody>[TR]
[TD="width: 75, bgcolor: transparent"] TD
[/TD]
[TD="width: 68, bgcolor: transparent"]VD[/TD]
[TD="width: 97, bgcolor: transparent"]TRANSACTION [/TD]
[TD="width: 64, bgcolor: transparent"]UNITS[/TD]
[TD="width: 64, bgcolor: transparent"]Portfolio[/TD]
[TD="width: 87, bgcolor: transparent"]Client Memo[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018
[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Maturity[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]200[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Maturity[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]400[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Maturity[/TD]
[TD="bgcolor: transparent, align: right"]3[/TD]
[TD="bgcolor: transparent, align: right"]401[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Maturity[/TD]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent, align: right"]402[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Maturity[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]403[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Maturity[/TD]
[TD="bgcolor: transparent, align: right"]6[/TD]
[TD="bgcolor: transparent, align: right"]404[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Maturity[/TD]
[TD="bgcolor: transparent, align: right"]7[/TD]
[TD="bgcolor: transparent, align: right"]405[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Repo[/TD]
[TD="bgcolor: transparent, align: right"]8[/TD]
[TD="bgcolor: transparent, align: right"]406[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Repo[/TD]
[TD="bgcolor: transparent, align: right"]9[/TD]
[TD="bgcolor: transparent, align: right"]407[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Repo[/TD]
[TD="bgcolor: transparent, align: right"]10[/TD]
[TD="bgcolor: transparent, align: right"]408[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Repo[/TD]
[TD="bgcolor: transparent, align: right"]11[/TD]
[TD="bgcolor: transparent, align: right"]409[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Repo[/TD]
[TD="bgcolor: transparent, align: right"]12[/TD]
[TD="bgcolor: transparent, align: right"]410[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Repo[/TD]
[TD="bgcolor: transparent, align: right"]13[/TD]
[TD="bgcolor: transparent, align: right"]411[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Repo[/TD]
[TD="bgcolor: transparent, align: right"]14[/TD]
[TD="bgcolor: transparent, align: right"]412[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Repo[/TD]
[TD="bgcolor: transparent, align: right"]15[/TD]
[TD="bgcolor: transparent, align: right"]413[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Purchase[/TD]
[TD="bgcolor: transparent, align: right"]16[/TD]
[TD="bgcolor: transparent, align: right"]414[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Purchase[/TD]
[TD="bgcolor: transparent, align: right"]17[/TD]
[TD="bgcolor: transparent, align: right"]415[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Purchase[/TD]
[TD="bgcolor: transparent, align: right"]18[/TD]
[TD="bgcolor: transparent, align: right"]416[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Purchase[/TD]
[TD="bgcolor: transparent, align: right"]19[/TD]
[TD="bgcolor: transparent, align: right"]417[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Purchase[/TD]
[TD="bgcolor: transparent, align: right"]20[/TD]
[TD="bgcolor: transparent, align: right"]418[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Purchase[/TD]
[TD="bgcolor: transparent, align: right"]21[/TD]
[TD="bgcolor: transparent, align: right"]419[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Purchase[/TD]
[TD="bgcolor: transparent, align: right"]22[/TD]
[TD="bgcolor: transparent, align: right"]420[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Purchase[/TD]
[TD="bgcolor: transparent, align: right"]23[/TD]
[TD="bgcolor: transparent, align: right"]900[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Purchase[/TD]
[TD="bgcolor: transparent, align: right"]24[/TD]
[TD="bgcolor: transparent, align: right"]901[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Maturity[/TD]
[TD="bgcolor: transparent, align: right"]25[/TD]
[TD="bgcolor: transparent, align: right"]902[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Maturity[/TD]
[TD="bgcolor: transparent, align: right"]26[/TD]
[TD="bgcolor: transparent, align: right"]903[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Swap[/TD]
[TD="bgcolor: transparent, align: right"]27[/TD]
[TD="bgcolor: transparent, align: right"]904[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Swap[/TD]
[TD="bgcolor: transparent, align: right"]28[/TD]
[TD="bgcolor: transparent, align: right"]905[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Swap[/TD]
[TD="bgcolor: transparent, align: right"]29[/TD]
[TD="bgcolor: transparent, align: right"]906[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Purchase[/TD]
[TD="bgcolor: transparent, align: right"]30[/TD]
[TD="bgcolor: transparent, align: right"]907[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Maturity[/TD]
[TD="bgcolor: transparent, align: right"]31[/TD]
[TD="bgcolor: transparent, align: right"]908[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Variation Margin[/TD]
[TD="bgcolor: transparent, align: right"]32[/TD]
[TD="bgcolor: transparent, align: right"]275[/TD]
[TD="bgcolor: transparent"]Futures Margin[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Variation Margin[/TD]
[TD="bgcolor: transparent, align: right"]33[/TD]
[TD="bgcolor: transparent, align: right"]280[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Variation Margin[/TD]
[TD="bgcolor: transparent, align: right"]34[/TD]
[TD="bgcolor: transparent, align: right"]818[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Variation Margin[/TD]
[TD="bgcolor: transparent, align: right"]35[/TD]
[TD="bgcolor: transparent, align: right"]500[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Variation Margin[/TD]
[TD="bgcolor: transparent, align: right"]36[/TD]
[TD="bgcolor: transparent, align: right"]335[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Variation Margin[/TD]
[TD="bgcolor: transparent, align: right"]37[/TD]
[TD="bgcolor: transparent, align: right"]158[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Variation Margin[/TD]
[TD="bgcolor: transparent, align: right"]38[/TD]
[TD="bgcolor: transparent, align: right"]157[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Variation Margin[/TD]
[TD="bgcolor: transparent, align: right"]39[/TD]
[TD="bgcolor: transparent, align: right"]165[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Variation Margin[/TD]
[TD="bgcolor: transparent, align: right"]40[/TD]
[TD="bgcolor: transparent, align: right"]917[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Swap Income[/TD]
[TD="bgcolor: transparent, align: right"]41[/TD]
[TD="bgcolor: transparent, align: right"]918[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Swap Income[/TD]
[TD="bgcolor: transparent, align: right"]42[/TD]
[TD="bgcolor: transparent, align: right"]919[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Variation Margin[/TD]
[TD="bgcolor: transparent, align: right"]43[/TD]
[TD="bgcolor: transparent, align: right"]920[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Variation Margin[/TD]
[TD="bgcolor: transparent, align: right"]44[/TD]
[TD="bgcolor: transparent, align: right"]921[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Variation Margin[/TD]
[TD="bgcolor: transparent, align: right"]45[/TD]
[TD="bgcolor: transparent, align: right"]922[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Variation Margin[/TD]
[TD="bgcolor: transparent, align: right"]46[/TD]
[TD="bgcolor: transparent, align: right"]923[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Variation Margin[/TD]
[TD="bgcolor: transparent, align: right"]47[/TD]
[TD="bgcolor: transparent, align: right"]924[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Purchase[/TD]
[TD="bgcolor: transparent, align: right"]48[/TD]
[TD="bgcolor: transparent, align: right"]925[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Sale[/TD]
[TD="bgcolor: transparent, align: right"]49[/TD]
[TD="bgcolor: transparent, align: right"]926[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]sale[/TD]
[TD="bgcolor: transparent, align: right"]50[/TD]
[TD="bgcolor: transparent, align: right"]927[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]sale[/TD]
[TD="bgcolor: transparent, align: right"]51[/TD]
[TD="bgcolor: transparent, align: right"]928[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]sale[/TD]
[TD="bgcolor: transparent, align: right"]52[/TD]
[TD="bgcolor: transparent, align: right"]929[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]11/2/2018[/TD]
[TD="bgcolor: transparent"]Purchase[/TD]
[TD="bgcolor: transparent, align: right"]53[/TD]
[TD="bgcolor: transparent, align: right"]930[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Try
Code: 
Sub AlwaysLearning2018()
   With Range("F2", Range("C" & Rows.Count).End(xlUp).Offset(, 3))
      .Value = Evaluate(Replace("If(@=""Variation Margin"",""Futures Margin"","""")", "@", .Offset(, -3).Address))
   End With
End Sub
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
SUM of Columns based on multiple criteria with User Form
2
Replies
15
Views
353
Alex Blakenburg
A
M
  • Solved
Populate a cell with text and formatting based on a whether a date field falls within a date range
Replies
3
Views
194
Micron
M
J
  • Question Question
vba to find specific text in a column and then when found copy all the rows above it
Replies
1
Views
216
mumps
mumps
I
  • Solved
If a cell has specific text & another cell is empty then add value to that empty cell
Replies
6
Views
128
ipbr21054
I
M
  • Solved
cut/copy and paste row based on cell value not being equal to specific text
Replies
6
Views
623
mlan1604
M

Forum statistics

Threads
1,224,753
Messages
6,180,748
Members
452,996
Latest member
nelsonsix66

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top