Need help while using concatenate formula in macros

viv_karthy

New Member
Joined
May 30, 2015
Messages
2
Hello
The problem statement is this:
1. I have a column in an xls ie work book1-> Sheet A-> Column AA(source)
2. I need to bring in each of the value from that column into another xls workbook2-> Sheet 1-> Column BB(destination)
3. Paste each of the value from the source(column AA) to the destination(column BB)
4. After pasting at the destination, I need to concatenate each value of the cell with the string "Application Manager"
The sample code looks like this:
ActiveCell.FormulaR1C1 = _
"=CONCATENATE('[Seaton - Non GBS Application Inventory.xlsx]Application Questionnaire'!R34C1,"" Appliocation Manager"")"
Range("B4").Select
ActiveCell.FormulaR1C1 = _
"=CONCATENATE('[Seaton - Non GBS Application Inventory.xlsx]Application Questionnaire'!R35C1,""Application Manager"")"
Range("B5").Select
ActiveCell.FormulaR1C1 = _
"=CONCATENATE('[Seaton - Non GBS Application Inventory.xlsx]Application Questionnaire'!R36C1,""Application Manager"")"
Range("B6").Select
Where :
Source file name =Seaton - Non GBS Application Inventory.xlsx]Application Questionnaire
Source cell location : R34C1, R35C1, R36C1
Attaching string: Application Manager

Now, i would like to variabalize the portion "Seaton - Non GBS Application Inventory.xlsx]Application Questionnaire'!R34C1" so that it picks the data from the source and and concantenate it with "Application Manager"
How do I variabalise this?

Please advice
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
you spotted the typo on the first statement
 

Watch MrExcel Video

Forum statistics

Threads
1,130,112
Messages
5,640,165
Members
417,128
Latest member
Xianter

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
Top