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

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
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
272
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
134
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
116
mumps
mumps
M
  • Solved
cut/copy and paste row based on cell value not being equal to specific text
Replies
6
Views
462
mlan1604
M
B
  • Question Question
How to auto populate a table on another sheet/tab based off of a drop down.
Replies
1
Views
330
severynm
severynm

Forum statistics

Threads
1,223,711
Messages
6,174,020
Members
452,542
Latest member
Bricklin

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