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
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