Developing .CSV File

**sctraffic** · 07-09-2014, 04:24 PM

Hello,

Here is an outline of what I want to be able to do;

Take a .CSV file from one source - file 1.csv
Take a second .CSV file from another source - file 2.csv
Open a template file that contains equations that are based on information in file 1.csv and file 2.
Save 'Sheet' that performs equations as a .CSV file.

So far I am able to copy/paste from the source files onto sheets setup in the template. I was really hoping I could open all 3 files and 'move' the source sheets into the template, perform calculations, then save as new .CSV.

The problem I'm running into trying to 'move' the sheets into the template file is the sheet references break and equations are useless.

I hope this makes sense. File attached for reference.

**Tinbendr** · 07-11-2014, 09:48 AM

The problem I'm running into trying to 'move' the sheets into the template file...

and how are you doing that? If you are just copy/paste, make sure to paste values.

What are you trying to accomplish? To merge the missing values between the two of them?

**newdoverman** · 07-11-2014, 10:17 AM

I just did an experiment with your file. I saved the worksheets File 1 and File 2 into separate workbooks. The only successful method that I found to get the data into the main file was to select the whole worksheet of File 1, copy then Paste into worksheet File 1 of the main file. No deletion was necessary just paste right over the existing data. Repeated procedure for file 2 and it worked perfectly.