Excel into Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

Is it possible to do something like Mail Merge but from one excel file to
another excel file.

I have one excel file with our dummy data (ie: First Names, Last Names,
Salary)
I have another excel file we use to create test scenarios.

What I need is to use the dummy data and input them into the test scenarios
in specific cells. Some cells have multiple information in them. For
example in cell A2 we have <Last Name>, <First Name>

Is this possible? Thank you for looking,
 
Is there a reason they could not be copied and pasted, or use VBA to make
certain cells in the test file equal to cell data in the dummy file?
xmpl:
Sheets("TestData").Range("B2") = Sheets("DummyFile").Range("D10").Value
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel VBA help: Text file formatting 19
Saving an Excel Wookbook to a Variable? 1
Excel file linking 1
I really need help 1
Macro for all Excel Workbooks to print to PDF 2
Tranfer data from Excel to word (Docx) via VBA in Excel 5
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Back
Top